Moving out WordPress hosting

I just moving out from my old web hosting to a new one that are bigger space, bigger bandwidth and faster performance. And as I expect, the moving of WordPress files and database from my old hosting to a new one is easy enough.

There are actually two ways (at least that I know of), the one is the easiest way, the the other one yet still an easy way. I already tried both ways. Please note that both my hosting are using Cpanel and Fantastico.

The Easiest Way

Backup

  1. In old hosting, login to cpanel
  2. Go to Backups
  3. Click on ‘Download a home directory backup’. It will start downloading a file with tar.gz extentions
  4. Now take a look at ‘Download a MySQL database backup‘ and click your WordPress database (if you only have WordPress, it should be the only one), should be wrdpxxx (in my case wrdp1). It will download a file with gz extention

Restore

  1. In new hosting, login to cpanel
  2. Click on Backups
  3. In a Home Directory Backup, upload your tar.gz file.
  4. In Restore a MySQL Database, upload your gz file.

That’s it. Nothing more easier than that.

But, there is a catch.

Fantastico will not recognize the version of your WordPress installation. It does recognize the WordPres, but not the version. As a result, it will not support upgrade using fantastico. In future upgrade, you must do it manually.

If you don’t like the catch (just like me), you can try my second method.

Yet Another Easy Way.

Backup

  1. In old hosting, login to cpanel
  2. Go to Backups
  3. Click on ‘Download a home directory backup‘. It will start downloading a file with tar.gz extention
  4. Back to cpanel frontpage
  5. Go to MySQL databases
  6. In the bottom of the page, click on PhpMyAdmin
  7. Click on Databases
  8. Click on your WordPress database, in my case is wrdp1
  9. Click on Export tab
  10. Click on Select All tables, SQL, Add DROP TABLE, Complete Insert, and finally Save as File then Go. It will created a SQL file (with sql extention)

Restore

  1. In new hosting, login to cpanel
  2. Create a new installation of WordPress in the same directory through Fantastico
  3. Back to Cpanel frontpage
  4. Go to MySQL databases
  5. In the bottom of the page, click on PhpMyAdmin
  6. Click on Databases
  7. Click on your newly created WordPress database, in my case wrdp1
  8. Select all the tables, and the drop it (drop = delete)
  9. Go to insert tables, and then insert your SQL file.
  10. Remember that you have a home directory backup, with tar.gz extention? You can open it with winrar. Now go through the files and locate your WordPress\wp-content folder. Copy all your files inside wp-plugins and wp-themes. You can do it much more easier with good ftp client such as filezilla

That’s it. More harder than the first method but still easy, but much more cleaner.

Leave a Reply