Questions & Answers (F.A.Q) - How do I transfer my WordPress blog to Host Color?

Questions & Answers (F.A.Q)


Account Management > Questions & Answers (F.A.Q) > XXVI. WordPress F.A.Q. > How do I transfer my WordPress blog to Host Color?

How do I transfer my WordPress blog to Host Color?

If you are moving your WordPress based site from a hosting provider where you used to use cPanel, please make full backup copy of you website. We will help you restore it. This will save you time and you will not need to follow steps described below. Alternatively:

Please backup your WordPress database through phpMyAdmin

Make a backup of your WP database using phpMyAdmin. Login into phpMyAdmin (cPanel -> MySQL -> phpMyAdmin), click on the database name which contains your WordPress blog and then click on "Export" in the main navigation area.

Complete the following steps in the export screen:

  • Click on "Select all" and "SQL" from the "Export" menu
  • Select "Add Drop Table?, "Add Auto_Increment value? and "Enclosure table and field names with blackquotes" from the "Structure" menu
  • Select "Complete inserts" and "Use hexadecimal for binary files" from "Data"
  • Leave all the other values at their defaults

Click on "Save as file" and this will initiate a download a file named wordpress.sql to your computer. Now you have a local back up copy of your database.

If you do not have phpMyAdmin installed on your web hosting account, use mySQLDump from a SSH terminal.


Download or Upload all Wordpress files with FTP

Please download all files from your previous hosting account and upload them to your new Host Color account.  Please do not forget the files from your WodPress "themes" and "plugins" folder. Don't miss to download any folders that were referenced outside of your WordPress blog folder. These might be an image folder or any other folder located outside of your "blog" one. You need to upload all folders on your new account in HostColor.com to avoid having any broken links to images or other media files.

There are plenty of nice and free FTP programs to use. You can try Fire FTP (Windows), Filezilla (Window & Mac versions), Cyberduck (Mac),

Some FTP clients do not display the .htaccess files. If you use one like that, ensure that your .htaccess file is included in your download - click on "View" and then enable "Show Hidden Files". Please note that if you do not upload your .htaccess file, your WordPress blog permalinks will not work!

Please note that you should not take this opportunity to update to a newer version of Wordpress. Your database may not sync' as a result. Complete your migration before you consider upgrading.

Edit wp-config.php and create a new WordPress database

Please go to your cPanel control panel and click the "MySQL Databases" icon. Create a new database, give it a name that works for your blog and create a database username and password. Then assign a new user to the new database and grant "All Privileges".

No edit wp-config.php to include the database settings of your new database.

/** 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*');

Now the file has your new database settings. Please upload it to the root of your WordPress blog folder. Now you have to put the database tables in your database.

Import WordPress blog to your new Database

Use phpMyAdmin to import your database. Please login to to phpMyAdmin, choose between 2 methods to complete the import: 1) Click on "SQL" and run a query; 2) Use the "Import" link to upload wordpress.sql file into the database. It is a good idea to use the latter, as the query may take longer and could crash your Internet browser.

The WordPress blog works, but CSS style not. Links send to the old host?

This might be because WordPress blog stores your domain name as a piece of data in its database. How to fix this issue?

1. Go to your-domain-name.com/wp-admin/ and login.

2. In the left hand menu, click "Settings".

3. Click "General".

4. Next enter the correct domain and path into the WordPress address (URL).

5. Enter the correct domain and path 
(usually the exact same) into the the Blog web address (URL)

6. Scroll down and click the "Save Changes" button.

7. Return to your blog and check whether the issue has been fixed!

If it is not, please create support ticket and Host Color will help you.


Also Read

Language: