How to move our Wordpress to Another Host via Database

Posted: Jul 22, 2009 |Comments: 0 | Views: 164 |

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.

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.

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.

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

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.

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).

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, you should need to re check your permalinks, maybe it changed (it should be not change), but please check it for make sure.
You can get more wordpress theme tutorial in my site.

Regards,
Irwanbee

--------

Wordpress Theme Tutorial

Questions and Answers

Ask
200 Characters left
Rate this Article
  • 1
  • 2
  • 3
  • 4
  • 5
  • 0 vote(s)
    Feedback
    Print
    Re-Publish
    Source:  http://www.articlesbase.com/blogging-articles/how-to-move-our-wordpress-to-another-host-via-database-1058033.html

    Article Tags:

    transfer web

    ,

    change hosting

    ,

    migrate to another host

    ,

    move to other host

    If you are not satisfied with the quality of website hosting solutions offered to you, it is time that you start thinking about changing your web host. However, you should remember some things before you make the final decision.

    By: Akhileshl Internet> Web Hostingl May 02, 2012
    Stephanie Rosendahl

    Web Based Business - Your Web Hosting Provider You're thinking about taking that leap of faith and building a web-based business, joining the other 125 million entrepreneurs that populate today's web. So you talk to some friends, you do a little research on site designers and maybe you even call one.

    By: Stephanie Rosendahll Internet> Web Hostingl May 07, 2011
    Johnny Ngo

    This article delves into the nuts and bolts of Web Hosting. When it comes to your blogs, should you choose a free host, or paid host? Read on to find out.

    By: Johnny Ngol Internet> Web Hostingl Jan 16, 2011

    Webhosting services are providing a number of services. It is important to go through them carefully and select a provider that matches the requirements.

    By: jhonalasterl Internet> Affiliate Programsl Oct 21, 2011

    Setting up a web site now is easier than ever these days. There is a wide selection of tools accessible to allow it to become much easier to accomplish this. But there might be an occasion when you want to transfer your registration, web host, or both!

    By: GeraldBolenl Internetl Mar 11, 2011
    Martin Wann

    When your business outgrows the platform you're using, you might want to consider migrating to another shopping cart. In this case, choosing Magento eCommerce platform is an ultimate solution. Here are the instructions for the step-by-step procedure of the migration process from any shopping cart platform to Magento.

    By: Martin Wannl Internet> ECommercel Nov 18, 2011
    ellumbra

    A fresh look at some of my reasons for suspicion - and a continuing battle against the organised group of bloggers.

    By: ellumbral Internet> Bloggingl May 26, 2012
    vi le thanh

    7 Steps Important to Make Best Strategy Blog to Development for Your Business Online

    By: vi le thanhl Internet> Bloggingl May 25, 2012
    Dario Montes de Oca

    Getting into social media marketing is a smart idea for any business owner. No matter whether your business is online or offline, this still remains true. With so many businesses reaping the benefits of social marketing, it's a shame to see so many others losing out. Just looking at it from this angle highlights the value of using a blog for your business. A blog can give any business an immediate benefit when it comes to social media.

    By: Dario Montes de Ocal Internet> Bloggingl May 25, 2012
    Dario Montes de Oca

    Getting into social media marketing is a smart idea for any business owner. No matter whether your business is online or offline, this still remains true. The web environment for business is focusing on social marketing so much that it becomes imperative. Just looking at it from this angle highlights the value of using a blog for your business. A blog can give any business an immediate benefit when it comes to social media.

    By: Dario Montes de Ocal Internet> Bloggingl May 25, 2012
    Dario Montes de Oca

    If you want to see real results from your online marketing efforts, a blog for any business is the perfect choice. Seriously, you can build the simplest blog and do well depending on your business. When you have your blog running, you can focus on some serious marketing for it. A blog will support just about any kind of content format, so a video blog will work very well indeed. This article will look at some simple strategies for building up a blog for your business.

    By: Dario Montes de Ocal Internet> Bloggingl May 25, 2012
    Irwanbee

    But for someone that need a Garage in urgent time, only have small place and no time to build by them self, Precast Garages will be no replaceable choice!.

    By: Irwanbeel Home Improvement> Remodelingl Feb 18, 2011
    Irwanbee

    The Canon EOS Rebel T3i features an expanded ISO range that makes shooting possible in situations previously unthinkable without flash. With an ISO rating up to 6400 (expandable to ISO 12800), along with the DIGIC 4 Image Processor's improved noise-reduction technology, creative possibilities abound. Combine the EOS Rebel T3i with one of Canon's EF or EF-S lenses with Optical Image Stabilizer and the shooting possibilities for both movies and stills expand even further.

    By: Irwanbeel Technologyl Feb 16, 2011
    Irwanbee

    We know that SEO trick still have to use for our site (if you want your site be top 10 in search engine). We can use On-site SEO, or Off-site SEO, both of them should be maintained carefully. Very basic on-site SEO trick is Title, H1, bold, and italics the main keyword for every post. For do this tricks, we can use special plugin help, so we will have 100% robotic site that has On-Site SEO optimized for every post

    By: Irwanbeel Internet> Bloggingl Jul 15, 2010 lViews: 181
    Irwanbee

    Have any site? Of course you have, at least you have one Wordpress Blog, if you don't have it, you will not read this post ;) When we do blogging with wordpress or any else generator, our first enemy were SPAM COMMENT BOT. This is software or script that automatically submit comment in your site with fake email and lots of hyperlink to their (spammer) site. Frankly, this will not harm your website rank, but it will make you angry to deleting that spam comments one by one.

    By: Irwanbeel Internetl Aug 25, 2009 lViews: 212
    Irwanbee

    The result were AMAZING!. It's more than i expected before. It's quality still below Nowspaper Advanced Theme from Gabfire, but this theme we free! We can use this theme without spend any money at all! Awesome!

    By: Irwanbeel Internet> Web Designl Aug 25, 2009 lViews: 415

    Discuss this Article

    Author Box
    Articles Categories
    All Categories
    Quantcast