MySQL Tutorial

MySQL Export: How to backup your MySQL database?

You can easily make a dump of (export/backup) your MySQL database via the cPanel > MySQL Databases > phpMyAdmin. The shortcut to the phpMyAdmin tool is located at the very bottom of the MySQL Databases tab.

Once the database administration tool loads, please select from the drop down menu called Database (located in the left upper corner of your web browser) the database that your application uses.

After the page is fully loaded, please navigate to the [Export] button:

Click on the Select all tool and please check the Add DROP TABLE box.

Finally check the Save to file check box and click on [Go] and the database dump will be downloaded to your computer.

MySQL Import: How to restore your MySQL database?

To restore (import) a database in phpMyAdmin, first choose the database you'll be restoring from the left menu. Then click the SQL tab. You have the option of importing an .sql file. Use the [Browse] button to find it on your local computer and then click Go at the bottom of the page.

You might want to check the cPanel backup tutorial for more information about your website backup.

You may also request a backup creation of your whole account by posting a ticket from the Exclusive Professional Services tab inside your Help Desk area.