import MySQL database3

Import MySQL database from one hosting server to another server

Import MySQL database from one hosting server to another server

Step 1: Login to the cPanel of the hosting server.

Step 2: On the cPanel, find the phpMyAdmin

Import MySQL database from one hosting server to another server

Step 3: Once you are in the phpMyAdmin, you can see all the list of the database. Select the existing database where you want to import the content to.

import MySQL database1

Step 4: Select the import option and upload the sql file which was exported from another server.

import MySQL database2

Import MySQL database from one hosting server to another server

Step 5: Import the sql file. Once the import is completed you can see all the table names under the database.

Import MySQL database from one hosting server to another server

Step 6: Now you need to change the url of existing hosting server, so go the query and open the query window. In the query window, type the command as below:

UPDATE wp_posts SET guid=REPLACE (guid,’new domain name’,’your old domain name’);

Step 7: You have successfully imported the database from one server to another.