First of all, using a FTP client, connect to the server, and download the whole folder containing the WordPress files. This action will take some time, depending on the local and the server connection speed, it might take up to a few hours.
Now, on the new server, open the cPanel web hosting administration or other website administration tool, and find the MySQL Databases. Prior to importing the data, a new database, user, and user access to the database has to be setup.
Here, start by creating a new database, giving it any name.
Then, add a new user, with a good password - mix of letters, numbers, special characters. The password won't ever need to be remembered, only copy and pasted once, so save it somewhere handy until like an open Notepad++ tab the next step.
And finally, add the user created to the database, with all access, as this user will be the administrator of the database for Wordpress.
Now, open the MySQL database in Phpmyadmin, and go to the import option. This is how WordPress import database will happen.
Here, select the file that has been created before, make sure the format selected is SQL, and also uncheck the partial import box. This is especially important for big sites, as the script might sometimes take longer to import the database than it is allowed to run.
By unchecking this box, the script will not stop from importing data in case it reaches the timeout execution, which is what we want to do here.
And of course, start the database import operation by clicking OK.
After the SQL import has been completed, a success message should be displayed in phpMyAdmin.
Now that the database is setup, it is time to tell WordPress about this new database, by opening the file wp-config.ini on the local backup. As this file is located in the root folder, it was most likely one of the first files to be downloaded, and should be available even if the transfer is not over yet.
If you only do an export WordPress site to new host, then the last step is not necessary, as the access URL will remain the same.
If you move WordPress to new domain, and the URL is different, then the last step is mandatory, as some URL have the old domain name, and the transfer of the WordPress site to a new domain will necessitate this operation to have correct URLs in the WordPress database.
Transfer WordPress site to new domain isn’t so complicated, as it is only a matter of copy paste of both the files and the database for a transfer WordPress to new host, the database doesn’t have to be moved for a transfer to another directory.
However, when performing a WordPress site transfer to new domain, do not forget to update the database access codes in the configuration files, and to change the new URL in the database, and you should be covered!
Have you managed to export WordPress site to new domain? Let us know in comment how it went!
About the author - Admin Yoann is an International Business Consultant, facilitator and coordinator. He worked more than 10 years in global business, supply chain, financial, SAP ERP projects, Web and SEO optimization for various industries, such as logistics, cosmetics, consumer goods, beauty care, or fashion, in more than 30 countries around the globe.