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
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.
Step 4: Select the import option and upload the sql file which was exported from another server.
Step 5: Import the sql file. Once the import is completed you can see all the table names under the database.
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.