Exporting and Importing Databases using PHPMYADMIN

Export (backup):

1. Log in
2. Select your database
3. Click Export.
4. Choose Structure and Data.
5. Click Select All.
6. Click “save as file” and “zipped”
7. Click “GO”
8. Choose a location on your local drive to save the zip file.

Import (restore):

1. Unzip the file on your local system (should end up with a .sql file).
2. Log in
3. Create a new database (probably named the same as the exported one)
4. Click SQL.
5. Unclick “show this query here again”
6. Click Browse and browse to the location of the unzipped (raw) sql file and double-click on it.
7. Click GO.
8. It will take a minute … or two … or five … hopefully not more than 15.
9. When it’s done it will say how many instructions were processed.
10. Your database is probably restored now.