How to Transfer Your WordPress Blog From One Host to Another Host

how tomove wordpress to new host

how tomove wordpress to new host

Step 1: Backup Your WordPress Database Using phpMyAdmin

Before transferring your WordPress blog, it is recommended that you make a backup of your database using phpMyAdmin. Once you have successfully logged into phpMyAdmin:

  1. Click on the name of the database which contains your WordPress blog.
  2. Click Export in the top navigation menu.
  3. Select the Quick option listed under the Export Method section.
  4. Leave the selection in the format section as SQL .
  5. Click Go.
  6. Once completed, there will be a prompt to save the file. Simply click on Save as File; this will download a file named wordpress.sql to your desktop.

You have then successfully backed up your database. If you don’t have phpMyAdmin installed on your hosting account, you can use mySQLDump from a SSH terminal.

Step 2: Download/Upload All WordPress Files Using FTP

You will need to download ALL your files from your old host and upload them to your new host. This includes files from your themes folder and plugins folder. Make sure you also download any folders which were referenced outside of your blog’s folder.

For example, if you are using a separate folder called images, located outside of the blog’s folder, the images must be copied and uploaded to the new hosting location; otherwise, the site will contain a lot of broken links to images within the blog post.

Filezilla is the recommended FTP client. By default, Filezilla does not display the .htaccess file, for security reasons.

To ensure that your .htaccess file is included in the download, you must click on View and then select Show Hidden Files. If you neglect to upload your .htaccess file, your permalinks will not work.
Note: You should not update to a newer version of WordPress at this time as your database may not sync correctly. Complete the WordPress migration before you consider upgrading the version.

Step 3: Create a New WordPress Database and Edit wp-config.php

Create a New Database

To create a new MySQL database:

  1. From your control panel, click the MySQL Databases icon.
  2. Create a new database with a name appropriate for your blog.
  3. Create a database username and password.
  4. Assign the new user to the new database and grant All Privileges.

Editing the wp-config.php File

After creating a new database, you will need to edit the wp-config.php file, which is the WordPress configuration file. This specific configuration file reads directly from a database of your choosing.

To update the WordPress configuration file:

  1. From your control panel, click the File Manager icon.
  2. Navigate to the document root for the domain for which you are updating the WordPress.
  3. Locate the file named wp-config (its normally in the group of files near the bottom).
  4. Click to open the file, and locate the following lines so that they can be updated with the correct information:
    /** The name of the database for WordPress */
    define('DB_NAME', 'cpuser_dbname');

    /** MySQL database username */
    define('DB_USER', 'cpuser_uname');

    /** MySQL database password */
    define('DB_PASSWORD', '******');

    /** MySQL hostname */
    define('DB_HOST', 'localhost');

    • If you did not edit the file on the server via the File Manager with your new database settings, upload it to the root of your blog folder.

The configuration file is now set up with the new database; however, it does not contain any database tables. In order to correct this, you will need to import the information into the database.

Step 4: Importing WordPress to the New Database

You can use either phpMyAdmin or BigDump or SypexDumper to import your database. BigDump SypexDumper is the preferred option if you have a large database (10mbs or more).

Once you have logged into phpMyAdmin:

  1. Click the name of the Database to which you wish to import the information.
  2. Click the Import tab at the top of the page.
  3. In the File to Import section, select the SQL based file from your computer that you wish to import.
  4. Use Partial Import if you intend to skip a set number of code rows.
  5. The Format and Format Specific Options sections can be left to their default values.
  6. Click Go to initiate the import.
Note: Importing via phpMyAdmin is less strenuous on the browser compared to the SQL option (BigDump) since the query may take a long time and can sometimes crash your browser.

2 thoughts on “How to Transfer Your WordPress Blog From One Host to Another Host

  1. I drop a leave a response when I like a article on a site
    or I have something to contribute to the discussion.
    Usually it is a result of the sincerness displayed in the
    article I browsed. And on this article How to Transfer Your WordPress Blog From One Host to Another Host | Joomla responsive templates.
    I was actually moved enough to post a thought 😉 I actually do
    have a few questions for you if you don’t mind. Is it
    just me or does it appear like a few of these remarks come across like they are left by brain
    dead folks? 😛 And, if you are posting at other online sites,
    I’d like to keep up with anything new you have
    to post. Could you list the complete urls of all your social pages like your Facebook
    page, twitter feed, or linkedin profile?

  2. Hello there! I know this is kinda off topic but I’d figured I’d ask.
    Would you be interested in exchanging links or maybe guest
    writing a blog post or vice-versa? My blog covers a lot of
    the same topics as yours and I believe we could greatly benefit from each
    other. If you are interested feel free to shoot me an e-mail.

    I look forward to hearing from you! Awesome blog by the way!

Leave a comment