Option 1: Download/unzip and run the the attached file to send a copy of the NolaPro database to your desktop.
Option 2: Manually create a backup this way.
* Enter a DOS prompt: Start -> run -> type: CMD and click [ok]
* Type: cd "\program files\noguska\nolapro\apache\mysql\bin\" [Press Enter]
If the above command results in a path not found error you are likely using a 64-bit version of Windows and should instead type the following:
cd "\program files (x86)\noguska\nolapro\apache\mysql\bin" [Press Enter]
* Create a database file - type: mysqldump -uroot nolapro>nolapro.sql [Press Enter]
* Open up "My Computer"
* Go to c:\program files\noguska\nolapro\apache\mysql\bin
* You should see the file "nolapro.sql" --> this is the backup file -- copy to a flash drive, network drive, CD, etc.
This creates the "nolapro_backup.sql" file with a complete data record. If you are removing NolaPro and reinstalling be sure to copy that file and place it back in C:\Program Files\noguska\nolapro\apache\
mysql\bin directory before you restore it.
Note: If your backup file is not created you may not have administrator access for your command prompt in Windows. Open the command prompt by going to Start->Programs->Accessories. Right-click on Command Prompt and Run as Administrator. Repeat the steps in Option 2.
Restoring Your Database
Note: attached is a file named RestoreNolaPro that shows the commands used in yellow. Thanks to Ted for providing the screenshot!
If using Linux you can use Terminal and navigate to your database in the mysql directory. Enter the following command (assuming your database is called nolapro):
mysqldump -u root -p nolapro > nolapro_backup.sql [Press Enter]
(If you receive an access denied error, add a directory after the ">" that you have write permission to. Example: >C:\Documents and Settings\username\mydir\nolapro_backup.sql)
Restore using the above instructions.
If you need to reformat make sure your backup database is copied to an external hard drive or flash drive before formatting.
Attachments: nolapro_export_to_desktop.zip RestoreNolaPro.png nolapro_export_to_desktop_win64.zip
« Go back