PhpMyAdmin Backup/Restore

This tutorial assumes you use a commercial web host and that host has phpMyAdmin installed. The exact instructions may vary from server to server. Please note that we are not endorsing phpMyAdmin and we hold no liabilities for the information provided below.

Backup Your Database

  1. Select phpMyAdmin in your web host's control panel.

  2. Find your database, located in the top left corner of phpMyAdmin. (You may have to click the + sign to view all the databases.)

  3. Select the Export tab in the top of the page.

  4. Under 'Format', select SQL.

  5. Click 'Go'.

  6. When asked if you want to save or open the file, select Save File.

  7. Your backup is complete.

Restore Your Database

  1. Start with a new, empty database that you created through your hosting control panel.

  2. Select phpMyAdmin in your web host's control panel.

  3. Find the new database, located in the top left corner of phpMyAdmin. (You may have to click the + sign to view all the databases.)

  4. Select the Import tab in the top of the page.

  5. Click 'Browse', then find the database backup you want to import. Note that this should be in the format filename.sql.

  6. Under 'Format', select SQL.

  7. Click 'Go'.

  8. Your restore is complete.

Large Databases

Note: if your database is especially large and will not load, you may need to zip it first. When exporting, select 'Custom', then choose 'zipped' under 'Compression'. If it still won't load, try 'gzipped'. You can import as usual; just make sure you select the .zip or .gzip file. (You do not need to unzip it first.)