How to transfer your WordPress website to your iManila Hosting Account

Overview

This tutorial explains how to migrate a hosted WordPress® installation to iManila server. This is useful, for example, if you develop your website on a locally-hosted server and wish to deploy your work to a public-facing server. This also applies if you are trying to transfer your WordPress website to your iManila hosting account.

Warning:

Step 3 – Create a MySQL® database.

Create a MySQL database to which to import the WordPress database in cPanel’s MySQL Databases interface (cPanel >> Home >> Databases >> MySQL® Databases).

Step 4 – Import the WordPress database to cPanel & WHM.

Import your WordPress database backup file to cPanel & WHM. To do this, perform the following steps:

1. Navigate to cPanel’s phpMyAdmin interface (cPanel >> Home >> Databases >> phpMyAdmin).
2. Click Databases in the toolbar and then click the database that you created in the previous step.
3. Click Import in the toolbar. A new interface will appear.
4. Click Choose File and select the database backup file that you created in Step 1.
5. Click Go. The system will import your WordPress database.

Step 5 – Change the website URL.

It is important to change your website URL specially if you are using a different domain with your current hosting provider. You must change the website URL in your database so that the database connects with your WordPress site. To do this, perform the following steps in cPanel’s phpMyAdmin interface ( cPanel >> Home >> Databases >> phpMyAdmin ):

1. Locate the wp_options table and click Browse.
2. Under the option_name column, locate the siteurl entry and click Edit.
3. In the option_value column, enter your website’s new URL in the text box and click Go.
4. Locate the home entry and click Edit.
5. In the option_value column, enter your website’s new URL in the text box and click Go.

Step 6 – Configure the WordPress database settings.

You must configure your WordPress database settings to use the information for the database that you created in step 3. To do this, perform the following steps:

1. Navigate to cPanel’s FileManager interface (cPanel >> Home >> Files >> File Manager).
2. Open the public_html directory and locate the wp-config.php file.
3. Right-click the wp-config.php file and click Edit. A pop-up window will appear.
4. Click Edit in the pop-up window. The editor will appear in a new browser tab.

5. Edit the DB_NAME, DB_USER, and DB_PASSWORD lines to match the information for the database that you created in step 3. This will resemble the following example:

Step 7 – Update links and images.

Your website may contain broken links and broken images after you migrate your website. To update the links and images to use your new website’s URL, perform the following steps:

1. Navigate to cPanel’s phpMyAdmin interface (cPanel >> Home >> Databases >> phpMyAdmin).
2. Click Databases in the toolbar and then click the database that you created in step 3.
3. Click SQL in the toolbar.

4. In the text box, enter an SQL query to update your URLs. For example:

   UPDATE wp_posts SET post_content = REPLACE(post_content, 'localexample.com/, www.mrfrog.com/')

5. Click Go to run the query.

Step 8 – Save the changes in WordPress interface.

After you updates your links and images, save the changes in the WordPress dashboard to update the URL. To do this, perform the following steps:

1. Log in to the WordPress dashboard.
2. Navigate to the General interface (Main >> Settings >> General.)
3. Click Save at the bottom of the interface.
4. Navigate to the Permalink interface (Main >> Settings >> Permalink).
5. Click Save at the bottom of the interface.

Step 9 – Update your domain’s DNS record.

Migrating your website to a new hosting provider or server means a new IP address. Update your website’s A DNS record to point your domain to your iManila hosting account.

1. Login to your cPanel.
2. Navigate to Domains > Zone Editor
3. Select Manage beside your domain name.
4. Then update your A DNS record, pointing to your iManila Hosting account IP address. The IP address can be found in the right-side pane of your cPanel Homepage > GENERAL INFORMATION.