Restore your wordpress database from backup using phpMyAdmin

So you have previously backed up your wordpress database and you need to restore your database from your backup. Restoring your wordpress database from backup is a quick and simple process using phpMyAdmin. I will go through the steps below.

  1. Open phpMyAdmin from your web hosting control panel.
  2. Select your database using the drop down menu in the top left of the screen.
  3. Click on the “Import” tab in the top navigation menu.
  4. Now click on the “Browse” button to search for your database backup file on your computer.
  5. Ensure that the “SQL” option is selected then click the “GO” button.
  6. That’s it, you’re done!

It may take a few minutes to restore your database depending on the size of it.

Adham Dannaway

Web Designer and Front End Developer with a passion for web design, coding, blogging, WordPress and chewing gum. Check out my web design portfolio and follow me on Twitter and Facebook!


  1. Aleksandar Tasevski on May 28, 2009

    But you must be sure that there is not a CREATE, or USE statement in the begining of the exported .sql file.


  1. […] up your wordpress database using phpMyAdmin and I will go through the steps below. You can easily restore your wordpress database using a similar […]


Have your say!