Today we are going to migrate a wordpress website from one server host to another running cpanel.
In this instance we are not changing the domain name, we are simply moving to another host.
Step 1: Backup all the data!
The first thing we need to do is sign into cpanel on the existing host and download a backup of both the Home directory and the SQL database using the backup wizard.
We could also grab emails but it’s a better idea to use Outlook to export the PST files, in this instance there are no emails to back up.
Step 2: Create a new SQL database on the new host
Log in to the cpanel on your new host, go to ‘MySQL Databases’
Under “Create New Database’ type a name, for this demonstration we just used ‘wordpress’
Remember the username including the prefix as we will need this later.
Step 3: Create the database user and update permissions
Scroll down to ‘Add New User’
Give the user a name, and set a password, you can use the generator to create a complex password, just be sure to copy it somewhere as we will need it later.
Click ‘Create User’
Next we scroll down to ‘Add User to database’ give the user a name and ensure you are adding itto the database we just created
On the ‘Manage User Privileges’ page tick the ‘ALL PRIVILEGES’ box
Click ‘Make Changes’
Again, remember the username and password you have set!
Step 4: Restore the SQL database
Go back to the cpanel menu and open ‘phpmyadmin’
Select the database we just created and select the ‘import’ tab
Choose the database file we backed up earlier (you may have to unzip this file)
Untick the box under ‘Partial Import’
Click ‘Go’, this will take some time depending on the size of your database.
Step 5: Import Home directory
On the cpanel menu select ‘File Browser’
Navigate to the ‘public_html’ directory, this is where we will upload the files
Click ‘upload’ and choose the home directory backup file we made earlier
Once it has finished uploading go back to the file explorer page
Right-click on the zip archive and select ‘Extract’
We have now restored the site files
Step 6: Update the wp-config.php file
While in the file explorer, find the ‘wp-config.php’ file and right click on it, select ‘edit’
Find and update the following lines with the database name, username and password we created earlier:
define(‘DB_NAME’, ‘DATABASE NAME HERE’);
define(‘DB_USER’, ‘USERNAME HERE’);
define(‘DB_PASSWORD’, ‘PASSWORD HERE’);
Once you have made the edits, click ‘save’
Step 7: Update the name servers on the domain name
Be sure to update the nameservers on your domain name to point to the new host, if you’re keeping the same domain name simply wait 24 hours and your site is ready to go! If you’re changing your domain name you will have to perform a search and replace on all the site links to reflect this change. A good plugin for this is the search and replace plugin at https://wordpress.org/plugins/search-and-replace/
That’s it! As always let us know if this guide helped you. If there is something you would like us to cover, please leave a comment.
#computerrepair #computers #technology #tech #computer #laptoprepair #computerhelp #computerscience #itsupport #computerservices #iphonerepair #itsolutions #cybersecurity #desktoprepair #itbusiness #computerengineering #itworks #itissues #itservices #techcompany #it #informationtechnology #helpdesk #windows #microsoft #townsville #wordpress #mysql #cpanel