FastDomain Web Hosting Help

How To Migrate a WordPress Site - Import / Export WordPress Database

Summary

This article will explain how to migrate your WordPress site without using Marketplace.



Transfer your Files

  1. Connect to your current hosting account using FTP
    Note: If you are unsure how to connect using FTP please see our article Filezilla which explains how to setup Filezilla, a popular FTP program.
  2. Locate the directory that contains your WordPress site Files. This could be your public_html or a subfolder inside of the public_html
    Note: Typically you will need all of the files and folders beginning with "wp-".
  3. Using your FTP client, download these files to your computer
  4. Now you need to upload those files to your new hosting account. You can use FTP to upload these files.
  5. Navigate to your public_html folder or the subfolder where you want WordPress installed
  6. Upload the files from your computer to this new location

Export the WordPress Database

  1. On your current hosting account, open the wp-config.php file. Located in this file is the name of the database that you need to export
  2. Most cPanel based hosting accounts should provide a copy of PHPMyAdmin to access your database. You can use this to export the database as a .sql file.

    Export the Database

    Note: If you don't have access to PHPMyAdmin, you can use a plugin to export a backup of your database

Create a New Database

You are now going to create a new database for the WordPress install.

  1. In your cPanel: Navigate to the Database category and click MySQL Databases
  2. Create a new database by typing in a name for it. This will be something like username_wp1, with 'wp1' being the name given to the database.

    Create a Database




  3. Now create a user for the database. You will provide a password for the user, which is important to remember for a later step in configuring WordPress
    Create Database User


  4. Once you have created the user, you will need to assign it to the database. When you do this, give the user All Privileges

    Database Privileges


Import into New Database

Now that you have a database created, you are going to Import the .sql file you downloaded into it

  1. In your cPanel: Navigate to the database category and click PHPMyAdmin
  2. Choose your newly created database, from the left hand side of the page.

    Database Import


  3. Along the top of the screen, click the Import tab

    Database Import Button


  4. Click the Browse button, and locate the file on your computer.
  5. Once you select the file, click Go to start the import.

Update your WordPress Configuration File

Now you need to make sure that your WordPress install is connected to the correct database. To do this,

  1. Open your File Manager and edit the wp-config.php file

    WP Config File


  2. You will need to type in the new database information: database name, database user, and the password.

    Configuration Settings


  3. Once you have updated those, click Save Changes

  1. Log into your WordPress Dashboard, using the username and password from the copy of WordPress you brought over
  2. Under Settings, click Permalinks

    Permalinks Settings


  3. You don't have to make any actual changes, just click the Save Changes button.

Doing this will update all the page and post URLs. If you have custom themes or plugins/widgets with old URLs, you will have to update those manually since there are not any plugins that are able to modify those as well.

View your Site

Once you have completed these steps, view your site in your browser to make sure everything looks correct and is functioning properly.



Was this resource helpful?

Did this resolve your issue?


Please add any other comments or suggestions about this content:





Recommended Help Content

If you have a WordPress blog hosted on WordPress.com, you can easily export it and import it to WordPress that is installed on your hosting account with fastdomain. Login to the WordPress Data
Getting Started Article 498,872 views tags: blog export file import wordpress

How to Migrate a self hosted copy of WordPress
Knowledgebase Article 577,467 views tags: migrate wordpress

How to export your database in phpMyAdmin..
Knowledgebase Article 139,981 views tags: database export myphpadmin

Related Help Content

This article explains how to find the database in use by a WordPress site.
Knowledgebase Article 151,870 views tags: database find wordpress

This article explains how to install WordPress when Mojo is unable to create the database automatically.
Knowledgebase Article 73,039 views tags: MOJO automatic database install wordpress

This article will explain how to change the Site URL or Home URL setting in WordPress. This may be useful if you have moved your WordPress site or are planning to move your WordPress site.
Knowledgebase Article 117,259 views tags: home site url wordpress wordpresstools

How to change the name of your WordPress site without WP Tools
Knowledgebase Article 35,847 views tags: change domain update wordpress

How to move WordPress from one folder to another folder on the same server.
Knowledgebase Article 101,074 views tags: migrate move velvet wordpress

How do I import a backup of my database (.sql file) using phpMyAdmin?
Knowledgebase Article 592,882 views tags: database mysql phpmyadmin

Instructions on how to migrate over via WordPress
Knowledgebase Article 102,965 views tags: transfer wordpress

I need to Export or Import a MySQL database
Knowledgebase Article 334,068 views tags: mysql phpmyadmin ssh