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
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.
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.
Click into your WordPress database. Most likely the name will correspond with the name of your site.
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.
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.”
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.
A cookie is a piece of information that a website stores on a visitor’s computer. We use this for some functionality on our website to work properly, and also to collect analytics to better understand our visitors and offer them a better experience. You can accept all cookies at once or fine-tune your preferences in the cookie settings.
Thanks, we've saved your settings, you can modify them any time on the cookie settings page
These cookies are needed for our website to function providing payment gateway security and ther essentials. Therefore they are always on but they do not contain personally identifiable information (PII).
If you've set preferences (which cookies you accept and which you don't) we store your preferences here to make sure we don't load anything that you didn't agree to.
WordPress sets a couple of cookies that track logged in users and store user preferences set in their WordPress user profile. These are set for members of the Kinsta website only - members of our staff.
Stripe is our payment provider and they may set some cookies to help them with fraud prevention and other issues. This is required for our payments to work.
This cookie contains information about the affiliate who refered a visitor. The cookie contains no information about the visitor whatsoever.
Analytics help us deliver better content to our audience. We have made sure no personally identifiable information (PII) is sent by anonymizing IPs.
Analytics cookies allow us to gather data to help us better understand our visitors and offer them a better experience.
Set and used by Hotjar. We use Hotjar to analyze user behavior without identifying the user.
Marketing cookies help us target our ads better. We mainly use them to target ads to users who have visited Kinsta.
Set and used by Twitter, used for targeting advertisements and promoting content to users who have visited kinsta.com.
Set and used by AdRoll for remarketing and targeting advertisements to users who have visited kinsta.com.
Set and used by Facebook, used for targeting advertisements and promoting content to users who have visited kinsta.com.
Set and used by Quora, used for targeting advertisements to users who have visited kinsta.com.