Most WordPress hosts, including Kinsta, have automated backups that allow you to restore in case of an emergency. However, there might be times where you need to restore and or upload your own MySQL database manually.

This could be because you are 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 restore MySQL database using phpMyAdmin.

Suggested reading: How to Export a WordPress Site.

How to Restore 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 restore a WordPress MySQL database with phpMyAdmin.

Note: This tutorial assumes you already have a backup or exported *.sql file for which you will import. If not, see our tutorial on how to backup your mySQL database with phpMyAdmin.

Step 1

Log in 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.

Log in to PHPMyAdmin.
Log in to PHPMyAdmin.

Step 2

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

Click on your Kinsta site's MySQL database in phpMyAdmin.
Click on your Kinsta site’s MySQL database in phpMyAdmin.

Step 3

Click on the “Import” tab and then on “Choose file.” Select your *.sql file backup/export. And then click on “Go.”

Import database in phpMyAdmin.
Import database in phpMyAdmin.

Get all your applications, databases and WordPress sites online and under one roof. Our feature-packed, high-performance cloud platform includes:

  • Easy setup and management in the MyKinsta dashboard
  • 24/7 expert support
  • The best Google Cloud Platform hardware and network, powered by Kubernetes for maximum scalability
  • An enterprise-level Cloudflare integration for speed and security
  • Global audience reach with up to 35 data centers and 275+ PoPs worldwide

Test it yourself with $20 off your first month of Application Hosting or Database Hosting. Explore our plans or talk to sales to find your best fit.