How to move our Wordpress to Another Host via Database

Today i want to share, how to migrate our wordpress blog into another host. I do not know why you will you do this, maybe you choose bad host services (oftenly down) or you have short off your space or bandwith. No more way to fix it except move your web into another host. What ever is your problem is, i will show you how to move your wordpress blog into new host. In this case, i want to transfer my Precast Concrete Technology web into new host.

There are two major way you can get through this,
FIRST you can export via xml files,
and the SECOND were via Database.

In this tutorial, i will concern with Database way, because it much easier for me.
To migrate our wordpress blog with database implant all you need is Backup your database first. Then deploy it into new location. But do not forget to backup the files also!

Step-by-Step to move our wordpress via database :

Login into your OLD directory of blogs, and download your wp-config.php file

Open those wp-config.php file, and find your database name. It will displayed below this sentences /** MySQL database username */. It will looks like define(’DB_USER’, ‘***_wrdp**’); . The “**” sign will be differ every blogs.

Next step is Login into your OLD CPANEL site, and choose PhpMyAdmin to backup your database. Select the proper database name (info from wp-config.php), then click export button on the top sidebar. Click the “save as file” option, then fill database name. Next, click GO button. And save it into your hardisk.

Files in the directory in the next step is to come back up just insidewp-content folder, then backup Plugins, theme, and Upload Folder. You can compress this folder first, than download it (to make the file smaller and easy to download). Use this backup process via File Manager Inside your Cpanel.

After all of “backing up stuffs” done, you should change your Domain DNS (Name Server) with new DNS of your new host. maybe this will make you wait until it resolved. It times depend on your host, it could be 3 hours until 24 hours.

Domain After you have turned to new host correctly, you have to do is log into your CPanel and create new Wordpress (site). You can use Fantastico, or you can install the manual. It's all up to you, just remember thatYOU MUST remember what Database Name for the new Wordpress installation. In this parts i will not teach you how to Install Wordpress, because when you read this, you must ever install wordpress, even it only once. LOL

After you successfully install new wordpress, simply openMyPhpAdmin and select database name for the new wordpress that you’ve been installed before. Make sure that you have select the correct database name!. Then click “Check All” option and select “Drop” Menu. Then click Go button. You will have last confirmation about dropping this table, just click YES. Then all the result is all table were deleted successfully.

Next step is to import your old database contained in this database. To take this step, simply click on the Import button in the upper pane, and select the secure database by clicking

Last Step to do, were uploading your file backup (plugins, themes, and upload folder). You can using FTP software or using File Manager through CPanel. If you follow my instruction before, you should upload your ZIP backup into “wp-content” folder, than extract it.

All step has DONE. Your site will works fine, but first time you login into your wordpress, maybe there will be one message shown from wordpress to confirm Database Upgrade. Don’t worry, it’s natural!. Just click the Upgrade button. And all your efforts will be finish.

Some time should you need to re-check your permalinks, may change (it should not change), but please check it to be safe.
You can find more WordPress theme tutorial on my website.

Regards,
Irwanbee

--------

Wordpress Theme Tutorial