Migrating WordPress from Bluehost to DigitalOcean

We’ve migrated to DigitalOcean! (Various reasons, more on that later.)

The process was straightforward, for the most part. The few snags were relatively easy to resolve (the main one was figuring out how to change the default DigitalOcean WordPress install to use the migrated tables).

Create a DigitalOcean Droplet

Use >>>THIS LINK<<< to sign up for $10 free in DigitalOcean services (that’s 2 free months at the lowest tier, with no committment!).

Sign into your DigitalOcean account and click the `Create Droplet` button next to your profile picture.
Choose an image (default is Ubuntu, which is fine), and the WordPress 4.7 One-click app.

Choose your pricing tier and leave everything else defaulted, unless you want to customize your hostame or add SSH keys.
Click the Create button. This will set up all the files you’ll need for a WordPress site. We’ll overwrite some of these and change others later to import our Bluehost files. If you aren’t migrating, congratulations! You’re done! If you are migrating, read on.

Connect to your droplet via ssh and set up your keys

Check out SSH and SCP: Howto, tips & tricks over at the Linux Academy Blog for more details on SSH and SCP.

Generate an ssh key locally if you haven’t already.

$ ssh-keygen -t rsa
# hit enter for a default-configuration key pair

Copy your public key to your droplet, using your droplet’s root user and password (provided to you when you generated the droplet).

$ scp ~/.ssh/id_rsa.pub root@your-digitalocean-ip:

Connect to your droplet.

ssh root@your-digitalocean-ip

Add your public key to your `authorized_keys` file, so you can ssh without a password.

cat id_rsa.pub >> ~/.ssh/authorized_keys

Back up your Bluehost WordPress files

Go to Bluehost cPanel and access the File Manager (cPanel > files > File Manager).

Backup `public_html/wp-content/` as a .zip file (right-click > Compress). Find the new `wp-content.zip` file and download it (right-click > Download).

Go to Bluehost cPanel, access phpMyAdmin (cPanel > database tools > phpMyAdmin).

Click your database in the list on the left, then click the `Export` tab. The default settings work fine here, so just click the `Go` button.

You should now have 2 files: `wp-content.zip` and `your-database.sql`.

Get the files onto your droplet

Use scp to move `your-database.sql` and `wp-content.zip` to your droplet.

$ scp wp-content.zip root@your-digitalocean-ip:    
$ scp your-database.sql root@your-digitalocean-ip:

Install the wp-content files

First, install the `zip` and `unzip` libraries on your droplet (This was one of the reasons we wanted to migrate from Bluehost to DigitalOcean: every droplet has full sudo! The low-tier BH did not). Then, unzip `wp-content.zip`.

sudo apt-get install zip unzip
sudo unzip wp-content.zip -d /var/www/html/

Install your schema

Execute this command in the DigitalOcean shell (`wordpress_mysql_pass` is in `/root/.digitalocean_password`):

mysql -h localhost -u wordpress -p wordpress_mysql_pass < your-database.sql

Log in to the mysql console and verify your tables were correctly added.

mysql -u wordpress -p
        mysql> use wordpress
        Database changed
        mysql> show tables;
        | Tables_in_wordpress                |
        | wp_commentmeta                     |
        | wp_comments                        |
        | wp_links                           |
        | wp_nkbq_commentmeta                |
        | wp_nkbq_comments                   |
        | wp_nkbq_es_deliverreport           |
        ... you get the idea
mysql> quit

You can add admin users here if you like, with the following statements.

mysql> INSERT INTO `wordpress`.`wp_users` (`id`, `user_login`, `user_pass`, `user_nicename`, `user_email`, `user_url`, `user_registered`, `user_status`, `display_name`) values (NULL, 'your-username', 'your-MD5-password-hash(google 'make MD5 hash')', 'your-username', 'your@email.com', '', NOW(), 0, 'Your Name');        
mysql> INSERT INTO `wordpress`.`wp_usermeta` (`umeta_id`, `user_id`, `meta_key`, `meta_value`) VALUES (NULL, 'the wp_users.id you just created', 'wp_capabilities', 'a:1:{s:13:"administrator";s:1:"1";}');
mysql> INSERT INTO `wordpress`.`wp_usermeta` (`umeta_id`, `user_id`, `meta_key`, `meta_value`) VALUES (NULL, 'the wp_users.id you just created', 'wp_user_level', '10');

Next, you'll want to update the prefix in your `wp-config.php` file so the correct database tables get accessed by WordPress.
From your console (sshd into your droplet), open the `/var/www/html/wp-config.php` file.

vim /var/www/html/wp-config.php

Find the following line:

$table_prefix = 'wp_';

And change the value to whatever prefix your Bluehost tables have (ours was `wp_nkbq_`).

$table_prefix = 'wp_nkbq_';

Save the file and exit.
That should be all the configuration needed to access your WordPress blog using the public IP of your droplet. But using the public IP to access a blog is hokey. It makes people nervous. Search engines probably don't like it.
Let's apply your domain name to make everyone feel better.

Update your Nameserver

Our domain is still hosted at Bluehost, so we just updated the name servers there.
Go to Bluehost's domain manager (cPanel > Domains > Domain Manager).
Click on your domain in the list on the left, then go to the name servers tab. Add the three DigitalOcean name servers.


Point your domain to your droplet

Add your domain

Go to the networking tab, fill out the field with the placeholder text 'Enter Domain' and click 'Add Domain'.

Add your 'A' record

This should bring you to the DNS records page. Add an 'A' record (this will take care of `yourhostname.com`). Use `@` for the `HOSTNAME` field, and your droplet's public IP for the `WILL DIRECT TO` field.

Add your 'CNAME' alias

A 'CNAME' record is an alias. It will redirect `www.yourhostname.com` to `yourhostname.com` (which will redirect to your droplet's public IP.) Use `www` for the `HOSTNAME` field, and `yourhostname.com` for the `IS AN ALIAS OF` field.

All set!

You should be all set up. The name servers may take a few hours to update, but your SEO and traffic should transfer over without any issues.

Leave a Reply