How To Migrate WordPress Manually To New Host

Sohail

2 years ago

Any website migration is regarded as one of the most difficult operations. Fortunately, WordPress provides a plethora of backup plugins to help and automate the entire backup and migration process. However, WordPress is constructed in such a way that manually migrate WordPress could not be simpler.

In this tutorial, I’ll show you how to migrate a WordPress site manually to a new host or server. This is especially useful if the site is hosted on a server with insufficient resources to enable the backup plugin. Backup plugins typically demand a minimal amount of resources to execute site backup and migration to another server. I’ve prepared a list of backup plugins for WordPress. So, if your server is healthy and has sufficient resources, I recommend that you install a backup plugin for WordPress migration.

Let’s start the process.

Prerequisites –

Estimated reading time: 8 minutes

SSH Access to both servers

Backup WordPress

Each WordPress site is made up of three major components: WordPress core files, User files (i.e. the wp-content directory), and the WordPress database. Unless the version of WordPress is modified, the core files do not change. wp-content and the database, on the other hand, change on a daily or even hourly basis, depending on website traffic. If you create new content on a regular basis, new images, videos, and text are uploaded every day, increasing the number of files on the server and the size of the database.

The first step is to compress wp-content in order to reduce its size and transfer it quickly to the new server. Second, export the WordPress database, compress it with the user files, and prepare it for migration.

wp-content

wp-content is a subdirectory of the WordPress directory. It stores all of the data that the user has uploaded, such as themes, plugins, attachments, photos, videos, and so on. Unless the site administrator configures the CMS to do so, most WordPress sites do not upload user content to any other directory. If you’re using a heavily customised theme, make a backup of the directories that contain data relevant to the structure of your custom website.

Many backup plugins save backup files somewhere other than wp-content. So, if you wish to migrate stored backup files to the new server, include them in the archive as well; alternatively, download them and save them somewhere secure. Adding stored backup files may significantly increase the size of the complete backup, so please download them locally if possible.

.htaccess

The .htaccess file is a configuration file that allows users to configure distinct settings for each directory. WordPress hosts multiple .htaccess files, the main one of which is located in the WordPress root.

Backup the .htaccess file because it contains useful configuration settings set by installed plugins such as firewall and cache plugins.

wp-config.php

wp-config.php is a WordPress configuration file that contains the most critical information for WordPress to work. The wp-config.php file provides database connection information. The wp-config.php file can also overwrite PHP limits established by the server, among other things. If you are migrating your site to a new host, make sure to copy wp-config.php along with the other files to the new server.

WordPress Database

When creating a new site or transferring an old one, ensure the database is appropriately configured with the site. As previously stated, the wp-config.php file contains database information such as the database name, database user (with full database access), and the user password.

To effectively migrate WordPress, we must export the entire database from the old server and prepare it for transfer to the new host.

Migrate WordPress Manually to new host

For the purposes of this demonstration, I’ll suppose our old host server IP is 192.168.29.5 and our new host server IP is 192.168.57.8.

First, let’s ssh into our old server –

ssh root@192.168.29.5

If your server’s ssh port is other than 22, use -p option followed by the port number.

ssh -p port_number root@192.168.29.5

Export database

The ﬁrst step is to export the database. If your website receives a high volume of traffic, you can either put it on maintenance or divert visitors to the backup server. WordPress constantly writes data to the database, and larger websites may experience slowdowns while the database export process is in progress.

Once ready, use the following command to dump all database locally –

mkdir $HOME/site-backup
cd $HOME/site-backup

mysqldump -u root -p wordpress_database > wp_database.sql

Change wordpress_database with the name of the WordPress database.

Hit enter and enter the MySQL root password. Now sit back and relax. Depending on the size of the database, this process may take sometime. Do not press + C during the process.

After the process completes, you will have wp_database.sql file in the working directory, i.e. site-backup.

Backup wp-content, wp-config.php, and .htaccess

It’s now time to back up user files. As previously stated, I assume your WordPress is using standard WordPress themes rather than highly customised or custom-built themes. If you utilise custom-built themes, please include the relevant directories in the following command.

Get into the WordPress root directory, and run the following command –

$ tar -czf website-content.tar.gz /path-to-wordpress/wp-content/ path-to-wordpress/wp-config.php path-to-wordpress/.htaccess

Now sit back and unwind. See how easy it is to migrate a website. You get to unwind twice!

After the files have been compressed, move the compressed file in the above-mentioned site-backup directory.

mv website-content.tar.gz $HOME/site-backup/

We have the site’s compress database, WordPress user data, and customizations in our $HOME/site-backup/ directory. Now compress the entire site-backup directory so that it can be easily transferred to the new server.

tar -zcvf site-backup.tar.gz $HOME/site-backup/

You now have a full backup of your WordPress site. You may either download this backup locally and move it to the new server, or you can use rsync to transfer it directly to the new server.

Let’s download this backup directly on the new server.

SSH into the new server –

ssh root@192.168.57.8

Use rsync to download the backup file –

rsync root@192.168.29.5:/home/site-backup.tar.gz .

The dot at the end of the above command is the destination directory, i.e. the current working directory.

Enter the root password and wait until download completes.

Install WordPress on New host

Now that we have our backup data on the new server, we can setup a new WordPress site and import all our data on that site.

Create database for new site

Login to the mysql command-line and use the following commands to create a new database, new user and grant new user all privileges to the WordPress database.

sudo mysql

Create new database

create database wordpress;

Create new database user

create user 'username'@'localhost' identified by 'password';

Replace username and password with your preferred values.

Grant database access to new user

grant all privileges on wordpress.* to 'username'@'localhost';

flush privileges;

Import database

Now that our database has been created, we can export the downloaded database.

Untar or uncompress backup file –

tar -xvf /home/site-backup.tar.gz

It’ll export two more files, wp_database.sql and website-content.tar.gz.

Import database to wordpress with the following command –

mysql -u root -p wordpress < /home/site-backup/wp_database.sql

Enter the root password and relax. Again.

Install WordPress

I assume that you’re using Apache web server. So the default web root for Apache server is /var/www/html. cd into the root directory and delete index.html.

$ cd /var/www/html
$ rm index.html

Download WordPress

wget -O /tmp/wordpress.tar.gz https://wordpress.org/latest.tar.gz

sudo tar -xvf /tmp/wordpress.tar.gz -C /tmp/

sudo mv /tmp/wordpress/* /var/www/html

Import WordPress backup to new site

tar -xvf /home/site-backup/website-content.tar.gz

The above command will uncompress site’s wp-content, wp-config.php, and .htaccess. We can use rsync to move wp-content/ to the new WordPress installation.

$ rsync -avu /home/site-backup/wp-content/ /var/www/html/wp-content/

$ cp /home/site-backup/wp-config.php /home/site-backup/.htaccess /var/www/html/

Edit wp-config.php

And one of our last steps is to connect our site with the newly created database. Remember we have already imported our site’s database so it’s ready. There is no need to run WordPress installation.

$ nano /var/www/html/wp-config.php

Now replace old database name, database username, and password with the current server’s database we created above, i.e. wordpress.

Fix WordPress file permissions

Never forget to set correct file permissions. Without it, WordPress may not function properly, and you may expose your data if incorrect permissions are set.

$ chown -R www-data:www-data /var/www/html/

$ find /var/www/html/ -type d -exec chmod 755 {} \;

$ find /var/www/html/ -type f -exec chmod 650 {} \;

Change ‘siteurl’ and ‘home’ in database

If you are moving your site without changing the domain name, you can skip this step. If you change the domain name, make sure to update the database with the new domain name.

We need to update to columns in wp_options table. If you have phpMyAdmin, then you can open phpMyAdmin > wordpress > wp_options > siteurl.

Change column ‘siteurl‘ value to ‘https://www.newdomain.com’. Also, change column ‘home‘ value to ‘https://www.newdomain.com’.

Update siteurl and home using mysql command-line –

sudo mysql

use wordpress;

update wp_options set option_value='https://www.newdomain.com' where option_name='siteurl'

update wp_options set option_value='https://www.newdomain.com' where option_name='home'

At last, point your domain name to the new server. If your web server is correctly setup, you should see your old website on new host.

Final Words

The manual procedure appears to be quite complicated, but trust me when I say that once you get used to it, it will save you money on a premium backup plugin. Using the steps outlined above, we can even build a script and set up a cron job to automatically backup our website. All of this without the use of a plugin.

Finally, if you had any difficulties or errors while following this post, please let us know in the comments section below. Alternatively, you can join our Discord Server for faster responses.