Migrate Your WordPress Website In 6 Steps Using PHPMyAdmin

Ok, the title is quite misleading. While there are 6 steps in this post, each step involves specific tasks. If I were to be totally true, the title would be “migrate your wordpress website in 59 steps using phpmyadmin, webhost manager, ftp, and notepad ++”. Gladly, the entire process is a lot easier than it sounds.

1st Step – Backup Your Database

You’ll need a fully functional, 100% safe backup of your current wordpress mysql database. Check out the steps to backup your db using phpmyadmin.

migrate-wordpress-steps-1

2nd Step – Setup Your New Domain

Whether you’re simply moving the domain to a new server or migrating the entire site to a new domain, you’ll need to have the new server properly setup before importing anything. If you use WHM on your VPS, you can check out the instructions to create a new WHM account.

migrate-wordpress-steps-2

3rd Step – Import Your Old Database

Once your new domain/server is setup, you’ll have to upload your database. If you’re migrating to a new domain, you’ll want to edit your database to replace every instance of [yourolddomainaddress] with [yournewdomainaddress]. I recommend using NOTEPAD++ to do so.
You can follow step-by-step instructions to upload your mysql database using PhpMyAdmin.

4th Step – Make A Local Backup of your File System

This is by far the easiest step – simply FTP into your top folder, select all of your files, and drag them into your computer to create a local backup. As you can imagine, we’re going to upload them to the new server in the next step.

5th Step – Prepare and Upload Files To Your New Server

The only thing you need to do before uploading your files to the new server is to edit your WP-CONFIG.PHP file. You’ll need your database name, username, and password. See below:

edit-wp-config-file

Good old Notepad++ is perfect for this task. Once your wp-config file is ready, you may FTP into your new server and upload all of files.

6th and Final Step – Switch Nameservers

The very last step is to switch your nameservers, pointing them to the new server. The DNS switch usually takes 3-24 hrs to complete, and a good way to check its status is to open a command prompt screen and simply PING the site (type “ping ‘mydomainaddress.com'”) and verify which IP is responding to the PING.

Creating New MySQL Database & Importing Your Old One Using PhpMyAdmin

If you’re migrating a site to a VPS, your first steps are to backup your database and then create a new account for that site in your WebHost Manager. This tutorial constitutes the 3rd step in the migration process.

Log Into The New Site’s CPanel

Once your account is fully migrated, you’ll be able to access CPanel by going to yourdomain.com/cpanel. Until then, visit the following address to access it:

https://YourVPSRootAddress:2083

cpanel-login-whm-address1

To log in, you’ll use the credentials setup during the new account creation process.

Create a new MySQL Database

You’ll need a new database and a new username, and then you’ll add that username to the database, giving it FULL POWERS. See below:

mysql-add-user-privileges1

Log Into your PhpMyAdmin

Once your new database is created, you’ll find it in the left-nav of your PhpMyAdmin. Click on it to begin the import process.

new-acct-import-phpmyadmin2a

Find the .sql backup file you saved during the 1st step and make sure its filesize is not larger than the maximum allowed by your server. The defaul import settings will work for 90% of these cases:

Allow partial import

SQL format

SQL compatibility mode – NONE

Do not use AUTO_INCREMENT for zero values

Once your Database is successfully imported, you’ll be able to see all of its tables. PhpMyAdmin will let you know how many tables were uploaded and if there were any errors.

How To Backup Your WordPress MySQL Database Using PhpMyAdmin

This is usually the 1st step before migrating your wordpress site to a new server, transferring it to a new domain, or for simple backup reasons. It’s highly recommended to backup your database as frequently as possible.

Log into PhpMyAdmin

In some hosts, it’s easier to log into your main control panel and then find the PhpMyAdmin icon. Below is what Hostgator’s cPanel looks like:

php-my-admin-cpanel

Looking under the “databases” section might help as well.

Select the Database to Export

Within PhPMyAdmin’s left nav you’ll find a list of your server’s databases. Select the one you want to export by simply clicking on it.

php-my-admin-db

If you have more than one database and are not sure which is the correct one, you might want to FTP into your site and open a file called /wp-config.php – all your database details are stored there.

Click “Export”

Section by Section:

Click for higher resolution.
php-my-admin-db-export

1 – Choose “Custom” under Export Methods

2 – Select ALL TABLES

3 – Save Output to a file

4 – Choose SQL under “Format”

php-my-admin-db-export-drop

Format-specific settings:

5 – Check “display comments”

6 – Dump table “Structure and data”

7 – Check ALL options under “add statements”

8 – Check “Enclose table and field names”

php-my-admin-db-export-go

Data dump options:

9 – Select “both of the above” under syntax to use when inserting data

10 – Check “Dump binary columns in hexadecimal notation”

11 – Check “Dump TIMESTAMP columns in UTC”

Save it in a Secure Directory!

12 – Click “GO”!

If you’re looking to migrate your site, you’ll then upload your database backup to your new server’s PhpMyAdmin, using the Import function.