Backup/Restore your Windows Database

Backup/Restore your Windows Database

Only the database needs to be backed up in order to preserve your licenses. If you need to reinstall your OS and NolaPro again then all you need to do is import your database into the NolaPro install. The instructions to backup/restore the database are as follows:

Backing Up Your Database

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 (x86)\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!

* Ensure the backup file is still in c:\program files\noguska\nolapro\apache\mysql\bin (file must match NolaPro version being restored to)

* 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]

* Enter MySQL by typing: mysql -uroot [Press Enter]

* Type: drop database nolapro; [Press Enter]

* Type: create database nolapro; [Press Enter]

* Type: exit [Press Enter]

* You will be back at the DOS prompt, now type: mysql -uroot nolapro<nolapro.sql [Press Enter]

 


Backing Up Your Linux Database

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.