Skip to main content
All CollectionsUseful Tools and Tips
How to Backup or Restore MySQL Databases Using phpMyAdmin
How to Backup or Restore MySQL Databases Using phpMyAdmin

Backups and restores with MySQL Databases using phpMyAdmin

Scott avatar
Written by Scott
Updated yesterday

This article explains how to take a backup or restore a backup using phpMyAdmin.
​

Backup MySQL Database

Step #1:

Log in to cPanel. If you're unsure how to do this, you can follow this guide. Then, go to the Databases section and click on 'phpMyAdmin'.

 

Step #2:

Select the database you would like to backup from the left navigation.

 

Click the Export tab.

Step #3:

Choose the 'Quick' export method, select the 'SQL' option and click 'Go'.

The database dump will be downloaded to your local machine's default download location.

Restore MySQL database from a Dump

Step #1:

Choose the database we want to restore from the left navigation.

Step #2:

The phpMyAdmin script that restores the database does not drop the tables so click the 'Check All' check box.
​

Select the 'With selected:' drop-down menu and choose 'Drop'.


Step #4:

Click the 'Import' tab and browse for the database backup.

Click Go.

Congratulations! You’ve successfully taken a backup of your database and imported it.

If you have any questions, please don’t hesitate to contact our team via live chat.

For technical inquiries, please feel free to reach our support team by emailing support@bigscoots.com from your registered email or by submitting a support ticket.


​

Did this answer your question?