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.

7 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

  3. Khubab says:

    I have also read another wonderful tutorial related to migrate every kind of php application from one host to another. Most of the details are discussed in that post including crons.

    [link removed, reason: not related to post]

    Cheers:)

    [Reply]

    themetutorial Reply:

    Hi Khubab,

    Thanks for your comment.
    Btw, I remove your link as it is not related to this post. I do not want to make my reader confused. :)

    ThemeTutorial

    [Reply]

Leave a Reply

1 Star2 Stars3 Stars4 Stars5 Stars (1 votes, average: 5.00 out of 5)
Categories: featured
Tags: how to move a wordpress blog to another host, wordpress to another host, re-uploading my old database into another wordpress, moving wordpress shopp to another server, wordpress change database login, database tutorial, proper database, how do i host pdf file in my blog, how to move wordpress to new host 2010, how to transfer wp database, different database name on host, backup files, migrate worpress db with myphpadmin, how to move wp to another host, importing database from another wp, wordpress comfy featured probleme, export db wpmu, domain dns, complete mysql database backup to transfer to another host, how to move wp on cpanel, download file, plugin to transfer wordpress another host, transfer wordpress database to new hostname, hosting via wordpress, how to install a website from another host site, wordpress read different database, wordpress change categoryid in cpanel, new location, move wordpress to new host with different name, comfy magazine sidebar problem, how to transfer wp to another host, using wordpress themes on other host sites, move wordpress to another host, migrate wordpress to new server, moving database to another hosting, how to move a wordpress theme via ftp, name server, mover blog wordpress plugin hosting backup, export button, move database wordpress theme widgets, host service, how to create a file in other host, moving wp to another hosting, blogs, import wordpress website to another host, moving a wordpress website to another host, move my website to another host step by step, how to migrate a site from cpanel to another host, moving database category id wordpress, wordpress move theme new host

Translate

Print

Print This Post Print This Post

Search

OneNews WordPress ThemesBlogohblog.com - Premium WordPress Themes
Theme Forest - Quality Themes, Great SupportElegant Wordpress Themes
WooThemes - WordPress themes for everyone

Community

Login with Facebook:
Last visitors
Powered by Sociable!

Related Post

Recently Commented

Photo Gallery

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