Sunday, February 6, 2011

How do I make a backup copy of a MySQL database in phpMyAdmin?

To make a backup copy of your MySQL database, please follow these steps:

  1. Login to your Control Panel.
  2. Click Hosting.
  3. Choose Databases.
  4. Click MySQL.
  5. For the database you wish to backup, click the corresponding phpMyadmin link.
  6. Click your database ID located on the left (eg. d#######).
  7. Click Export.
  8. Click the appropriate option:
    • Structure only.
    • Structure and data (recommended).
    • Data only.
  9. Click Select All to select all tables.
  10. Click Save as File option.
  11. Click Go.
If your database is too large or the phpMyAdmin backup feature times out, we suggest using SSH to back up your database