How to Restore Your WordPress Database

Posted OnOct 30, 2013     CategoryDevelopment     CommentsNo comment

In this tutorial we will walk you through the process of restoring a backup of your WordPress Database via phpMyAdmin, which is available on the majority of web hosts.

This tutorial assumes you are running WordPress with a Web Host that uses CPanel, or something like it, to allow you certain administrations over your server. Therefore you will require

Step 1) Log in to your web host’s CPanel or similar

Step 2) Open MySQL Databases

phpmyadmin

Step 3) Create a new MySQL database, with a name of your choice, and click create database. Note you can choose to make a new user here as well.

creating a new mysql database in cpanel

Step 4) Open phpMyAdmin.

Step 5) Select the database you wish to import to from the left hand menu

select the database

Step 5) Click Import in the top navigation menu

click import phpmyadmin

Step 6) Click “Choose File” and locate the backup of your MySQL Database you have, then click “Go”

importing a mysql database in phpmyadmin

If your database import was successful, you will see a screen similar to below, note the newly created tables on the left hand side.

mysql database import successful

Important: Depending on the circumstances under which you’ve restored your database, this might also count as a migration, and in either of these cases may require you to modify the database details in your wp-config.php file

// ** MySQL settings - You can get this info from your web host ** //
/** The name of the database for WordPress */
define('DB_NAME', 'database_name_here');

/** MySQL database username */
define('DB_USER', 'username_here');

/** MySQL database password */
define('DB_PASSWORD', 'password_here');

/** MySQL hostname */
define('DB_HOST', 'localhost');

/** Database Charset to use in creating database tables. */
define('DB_CHARSET', 'utf8');

/** The Database Collate type. Don't change this if in doubt. */
define('DB_COLLATE', '');

Leave a Reply

Your email address will not be published. Required fields are marked *

Send this to friend