The topic of this article is not supported by our customer support department, however for your convenience we are providing this material to assist you in troubleshooting potential issues related to this topic.

MySQL allows you to import/export text files containing database entries in a standardized format. By creating a MySQL Dump file, you will have an exact copy of your database in a single file; this file can be saved for emergency purposes and can be imported back in to MySQL to re-create and restore your database contents.

Making a MySQL Dump (Backup) of Your Database With phpMyAdmin

• Login to phpMyAdmin at http://yoursitedomain.com/phpmyadmin
• From the Database menu on the left, choose the database you want to backup.
• Click on the Export tab; the options needed for a full backup of the database will already be selected.
• Click the Go button located at the bottom of the page.
• NOTE: Choosing the “Save as file” option will prompt you to download a file.  If no check is placed beside of “Save as file”, the following screen will provide you with the SQL code for the database backup.

Making a MySQL Dump (Backup) of Your Database Through SSH

• Connect to your server with an SSH client using the domain name and the FTP username and password.
• In the SSH client type the command: mysqldump database_name > backup_filename
• NOTE: database_name will be the name of the database that you’re backing up; backup_filename represents the file that the SQL code is saved to.  Depending on the size of your database, the backup may take a few minutes to complete.

Related Articles: