If you have noticed that I have not been posting for a few days, the reason is I have been moving my WordPress blogs from one host server to another. You would think this should be pretty straight forward and to be honest, once you establish the steps you need to take, moving a WordPress blog using CPanel is relatively easy. This is the method I used successfully for 5 blogs, so if you need the detailed version you can now click on the eBook image for a .pdf version of the instructions.
Or if you are already familiar with CPanel the summary sequence is below.
- Using CPanel for the existing account, make a compressed file of the domain directory in file manager
- Download the zip file to a suitable location on your PC
- Go back into CPanel and using the back up Icon create a back up of the database for the domain being moved, and store it on your own PC
- For the new server, create the domain name either as a separate account using WHM or as an add on domain using CPanel
- Using CPanel for the new domain, go to ‘backup’ and restore the database downloaded earlier
- Go to file manager via CPanel and upload the zip file created earlier from your PC (note if the file is too big you may need to break it up into smaller files). Then extract all the directories and files making sure the directory structure is exactly the same as it was on the original host’s server
- With all the files reinstated on the new server, including .htaccess you will now need to re-establish a connection to your database,
- In Cpanel go to ‘MySQL databases’ and create a new user, the name and password can be anything you like as it is a temporary name and password you will only use once
- In the same panel add the user to the database, and assign all roles to the user
- Now you need to configure the database using the new users details
- Go to file manager for the new domain server via CPanel and look for the ‘wp_config.php’ file in the main directory. Select it and use ‘code editor’ to edit the file. You need to change the server name to the new name on the new server, change the user name to the temporary name you just created (including the automatically assigned prefix) and change the password to the password you created for the temporary name, then save the changes.
- Your website should now load using the temporary URL that allows you to view the files e.g http://123.456.789.10/~username But there will be an Error-404 page not found. The reason for this is that the ‘wp_options’ calls up the actual URL not the temporary one. So to view the website you need to go into wp_options find the 2 instances where the URL is defined and change it to the temporary URL. These are ‘site URL’ on the first page and ‘home’ on the 2nd page. The ‘wp_options’ tables can be accessed via ‘phpMyAdmin’ in Cpanel.
- Check the site loads properly using the temporary URL, and if it does you can then go back into ‘wp_options’ and put the site URL’s back to the permanent format. You will also need to update the file ‘upload directory path’ while you are in there to reflect the new server directory structure
- Now all you need to do is go to your domain supplier and change the named server to the new server and wait for it to propagate
- The end
