How to Restore Your WordPress Database
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
- a backup of your database
- Access to CPanel or similar
- Access to phpMyAdmin
Step 1) Log in to your web host’s CPanel or similar
Step 2) Open MySQL Databases
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.
Step 4) Open phpMyAdmin.
Step 5) Select the database you wish to import to from the left hand menu
Step 5) Click Import in the top navigation menu
Step 6) Click “Choose File” and locate the backup of your MySQL Database you have, then click “Go”
If your database import was successful, you will see a screen similar to below, note the newly created tables on the left hand side.
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', '');