Restore a Database using phpMyAdmin - smalos/nuBuilder4-Code-Library GitHub Wiki

Carry out the following steps to restore your MySQL/nuBuilder database by importing a MySQL backup file in phpMyAdmin. You will have to manually delete all the tables (or delete and recreate the database) before restoring your database dump.

1. Login to phpMyAdmin.

2. Select the nuBuilder database from the list of databases on the left pane. All tables/views in the database will be listed.

3. Head to the right pane and click the option "Check all" at the bottom of the list to select all tables/views in the database.

4. Click the box "With selected": and choose Drop. This will execute the DROP TABLE SQL query on all tables and once you confirm that you wish to proceed the database will be emptied.

5. In the left navigation tree click the nuBuilder database you want to import the backup file into.

6. Click on the 'Import' tab.

7. Click on the button named "Choose File" (or similar, depending on the local language)

8. In the dialog, locate the database backup file stored on your computer and click 'Open'. You should see your chosen file name shown next to the Choose File button.

9. Click the 'Go' button.