Database Import

1. Launch MySQL Database Wizard from your cPanel.

 

wordpress mysql setup

 

2. Type your new database name (this will be your ‘DB_NAME’ line 19 in wp-config.php) and click “Next Step”.

 

mysql create database

 

3. Create your username and password (these will be DB_USER and DB_PASSWORD lines 22 and 25 in the wp-config.php) and click “Create User”.

 

mysql username password

4. Select “ALL PRIVILEGES” and then save the change.  You have your Database Setup, and make sure your config file has ‘DB_HOST’ set to ‘localhost’ if you are using cPanel Hosting.

 

mysql all priveleges

 

Below is an example of a wp-config.php file where you will be updating these settings for a manual MySQL Database setup. Remember to replace DB_HOST with ‘hostname’. (Click on the Image for a larger view).

wp-config.php

5. To import your .sql backup, click on “phpMyAdmin” from your cPanel account.

phpmyadmin launch

 

5. Select your Database Name from the left hand column, and import the .sql file from the “Import” Tab in phpMyAdmin by browsing for your .sql file and clicking “Go”.

Database Import