How to Backup MySQL Database Using phpMyAdmin

Written on January 18, 2017. Updated on November 09, 2017

Most WordPress hosts, including Kinsta, have automated backups so you don’t have to worry about manually backing them up yourself in case of an emergency. However, there might be times where you need a copy of your MySQL database. This could be because your migrating hosts or perhaps you want to do some local development. In any case, you can follow this quick and easy tutorial below on how to backup mySQL database using phpMyAdmin.

how to backup mysql database using phpmyadmin

How to Backup MySQL Database Using phpMyAdmin

phpMyAdmin is a free open source tool available via your browser that is used to handle administration of MySQL or MariaDB. It can be used for all sorts of different operations, such as migrating databases, managing tables, indexes, and executing SQL statements. Today we are going to simply export a WordPress mySQL database with phpMyAdmin.

Step 1

Login to phpMyAdmin. With Kinsta, we have an easy to access link to login to phpMyAdmin from within the MyKinsta dashboard. Depending on your WordPress host, this could also be located in your cPanel account.

login to phpmyadmin

Step 2

Click into your WordPress database. Most likely the name will correspond with the name of your site.

phpmyadmin wordpress database

Step 3

Option 1 – Quick Export Method

Click on the “Export” tab. If you are going to be using your database in a place where an old version of it doesn’t exist, or if you just want a backup, you can select the “Quick – display only the minimal options.” Then click on “Go.” This will generate a *.sql file which you can keep as a backup, or restore/import elsewhere. Remember, that the WordPress database only contains the information from your site, the files (plugin/themes) are completely separate and must be downloaded and backed up via FTP.

export tables phpmyadmin

Option 2 – Custom Export Method

If are going to be importing your database to a place where it already exists with tables of the same name, you will want to choose the “Custom – display all possible options.”

phpmyadmin export custom

Scroll down to the object creation options section and select “Add DROP TABLE / VIEW / PROCEDURE / FUNCTION / EVENT / TRIGGER statement.” This will ensure that it simply overwrites existing tables of the same name.

add drop table phpmyadmin

Then click on “Go.” This will generate a *.sql file which you can keep as a backup, or restore/import elsewhere. Check out our tutorial on how to restore your MySQL database using phpMyAdmin.

Was this article helpful?
No, or there was something off

Hand-picked related articles

Send this to a friend