How to move our Wordpress to Another Host via Database

Posted by irwanbee on Jul 21st, 2009 and filed under featured. You can follow any responses to this entry through the RSS 2.0. You can leave a response or trackback to this entry

migration wordpressToday 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 service (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.

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 :

  1. Login into your OLD directory of blogs, and download your wp-config.php file
    download-wp-config
  2. 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.
  3. 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.
    export-database
  4. The next step is backup your files inside your directory, just come inside wp-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.
    backup-database
  5. 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.
  6. After your Domain were redirected into new Host correctly, all you have to do is Login into your CPanel and Create new Wordpress (install). You can Use Fantastico, or you can install manual. It’s all up to you, just remember that YOU 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
  7. After you succeed installing new wordpress, just open MyPhpAdmin 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.
    drop-database
  8. Next Step is importing your old database into this database. To do that step, just click Import button on the top sidebar, and choose your saved database by click “Browse”. Then click Go. Just wait the magic comes out (i mean importing succeed).
    import-database
  9. 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.
    extrack-backup
  10. 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.
    upgrade-database

Some time, you should need to re check your permalinks, maybe it changed (it should be not change), but please check it for make sure.
That’s all the tutorial today, if you have any problems when do all this step, leave your comments here.

Regards,
Irwanbee

You Can Download This Article in PDF File Here
Please Login or Register to see the download link.

1 Star2 Stars3 Stars4 Stars5 Stars (1 votes, average: 5.00 out of 5)

5 Responses for “How to move our Wordpress to Another Host via Database”

  1. Maxheadshot says:

    I have been dreading transferring my WP blog from a lame duck host to something more robust, thinking the issue was too difficult to manage. However, after finding this article and following the steps precisely, I managed to move my entire blog, database, comments, users, everything, to the new host. Many, many thanks for making it easy on me. Much appreciated.

    [Reply]

  2. where can i download this wp-config.php file in my cpanel

    [Reply]

    irwanbee Reply:

    you can see it on your root directory of the blogs.
    example :
    1. Your site is a ADD ON domain or subdomain inside folder “EXAMP”, then you can see those wp-config.php inside “/public_html/examp/”
    2. If your site is main domain,.. then this file will be inside “/public_html/” folder.

    Download that file, and open it with notepad. Then you can read, what is the DATABASE name that you should backup.

    Still got problem?, feel free to ask.

    [Reply]

    Telugu movie blog Reply:

    Thanks for solving my problem,i am searching lots of sites since 2 days to find this.

    [Reply]

    irwanbee Reply:

    you’re welcome.
    please come back again if you have another problems

Leave a Reply

Translate

English flagItalian flagKorean flagChinese (Simplified) flagChinese (Traditional) flagPortuguese flagGerman flagFrench flagSpanish flagJapanese flagArabic flagRussian flagGreek flagDutch flagBulgarian flagCzech flagCroatian flagDanish flagFinnish flagHindi flagPolish flagRomanian flagSwedish flagNorwegian flagCatalan flagFilipino flagHebrew flagIndonesian flagLatvian flagLithuanian flagSerbian flagSlovak flagSlovenian flagUkrainian flagVietnamese flagAlbanian flagEstonian flagGalician flagMaltese flagThai flagTurkish flagHungarian flagBelarus flagIrish flagIcelandic flagMacedonian flagMalay flagPersian flag

Print

Print This Post Print This Post

Search

Host Unlimited Domains on 1 Account

Related Post

Photo Gallery

Log in / Advanced NewsPaper by Gabfire Themes
Education and Training Blogs - BlogCatalog Blog Directory