• moving-wordpress-websites-ftp-client

Move Your WordPress Website To Another Domain Or Server

September 7, 2015

by Marcel Westerhoff - Owner and Director K-Dushi Marketing B.V.


How To Move Your WordPress Website?

I'm confronted with this situation quite often. The reasons to move a WordPress website are:

  • Someone owns a WordPress website and change to a different web hosting provider (domain stays the same).
  • Someone developed a WordPress website on a temporary domain and want to put it live on the actual proper domain.
  • The WordPress website needs to be duplicated for whatever possible reason.
In this blog post I will explain how to do this in a few steps.


Assumptions

  • In this article I describe moving a WordPress website assuming that the domain name also needs to change. If this is not the case you can ignore the steps regarding changing the domain name.
  • From the screenshots I use in this post you can see that I need to make use of the DirectAdmin control panel. Possibly you're making use of a different control panel like cPanel or Plesk. Don't worry, you can also find the displayed options in these control panels.
  • In case the website will be hosted on the same current server and only the domain name will be changed, this article will quite easily show how to do this.
  • Don't have many experience with FTP? Go to the website of FileZilla and download this free software. It's easy to use and runs on both Windows and Mac PCs.

What do you need?

Make sure you have the following information available:

  • FTP login information from both the old and the new server. You can get this information from your provider.
  • Control panel login information from both the old and new provider.
  • Database login information from the current database. If you don't remember this information check the config.php file in the root directory of the website to move.

STEP 1: Download files

Open your FTP client (in my case FileZilla), connect to the server where the website is located that you need to move and go to the folder where the website file are located. In most cases this is the public_html or www folder. Your screen should more or less look like this screenshot:

moving-wordpress-websites-ftp-client

Download all folders and file, excluding cgi-bin, to a folder (e.g. WordPress old) to your PC by dragging the files and folders to the destination folder.


STEP 2: Export database

While you're downloading the files (this can take a while depending on the amount of files and their size) you can already export the database. Go and login on your control panel. In the screenshot below you see the main screen of DirectAdmin. In case you're making use of another control panel follow similar directions. At the end you need to end up in the phpMyAdmin screen in which you'll find the database tables.

Choose 'MySQL management' after logging into your control panel (see screenshot below).

moving-wordpress-websites-direct-admin

Click on the link 'phpMyAdmin' in your next screen (see next screenshot).

moving-wordpress-websites-phpmyadmin

A pop-up will appear in which you need to login with your database user name and password (see screenshot below).

moving-wordpress-websites-phpmyadmin-login-phpmyadmin

Once you're in phpMyAdmin you need to select the database that you need to export in the left hand column before clicking on 'Export' in the top navigation (see next screenshot below).

moving-wordpress-websites-phpmyadmin-export-phpmyadmin

You're now looking at a screen similar to this screenshot:

moving-wordpress-websites-phpmyadmin-export-options-phpmyadmin

Now make sure you:

  1. Choose 'Custom - display all possible options'.
  2. Select all tables.
  3. Select 'Save output to a file'.
  4. Choose 'SQL' format.
  5. Check 'Display comments'.
  6. Choose 'structure and data'.
  7. Check 'Add DROP TABLE / VIEW / PROCEDURE / FUNCTION / EVENT / TRIGGER statements'.
  8. Check 'CREATE TABLE options:' and both 'IF NOT EXISTS' and 'AUTO_INCREMENT' options.
  9. Check ' Enclose table and column names with backquotes'.
  10. Choose 'both of the above'.
  11. Check both 'Dump binary columns in hexadecimal notation' and 'Dump TIMESTAMP columns in UTC'.
  12. Finally click 'Go' and your database will be downloaded as a .sql file.

STEP3: Uploading files and folders

When downloading the files and folders from step 1 is finished you can login to the new server via FTP. Go to the folder in which the website needs to be placed (normally public_html or www. If you're not sure contact your provider). When there's already an index.html or index.php file located in this folder rename it to for example index_old.html or index_old.php. The same applies to a possible .htaccess file.

In case you already hosted a website on this domain remove it first (if desired make a backup by downloading the files and folders to your PC).

Now upload the files and folders of your website to the new domain by dragging it to the destination folder.


STEP 4: Database import

To make your WordPress work you also need to import your database to the new server. Login to the control panel of the new server and click on 'MySQL Management'. Then choose 'Create new Database' (see screenshot below).

moving-wordpress-websites-new-database

Give your database a name, create or select a user, create a password and click 'Create' (see next screenshot). Note down this information as you'll need it in some of the next steps.

moving-wordpress-websites-create-new-database

Login to phpMyAdmin of the new server like you did in step 2. Choose the database you just created and click 'Import' (see screenshot below).

Move WordPress Website To Another Server

In the next screen:

  1. Select the database .sql file that you've downloaded in step 3.
  2. Check 'Allow the interruption of an import in case the script detects it is close to the PHP timeout limit.
  3. Select 'SQL'.
  4. Check 'Do not use AUTO_INCREMENT for zero values'.
  5. Click 'Go' to import your database.
Move WordPress Website To Another Domain

If you successfully imported your database you'll find the tables of the database in the left hand column.


STEP 5: Changing domain name

The database contains some data that needs to be changed regarding your new domain name. All the data that needs to be changed can be found back in the table 'wp_options'. Click on this table in the left column. Now all the rows in this table appear in the main column. On the very top you'll find the row 'siteurl'. Click on 'Edit' and change the url to the new domain in the text area field (see next screenshot). Finally click on 'Go' and the data will be saved. Normally there are at least two items that needs to be changed, siteurl and home. However there could be more items that needs to be changed. I therefor advise to scroll through all rows to check them on the old domain name.

k-Dushi Marketing Agency Bonaire

STEP 6: Changing database information in config.php

When all files are uploaded on the new server it's time for the final step, changing the database information in the config.php file. Go via FTP to the root of your new website and look for the config.php file. In this file you'll find the follow information:


// ** MySQL settings - You can get this info from your web host ** //
/** The name of the database for WordPress */
define('DB_NAME', 'kadushim1_test2');

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

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

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

/** Database Charset to use in creating database tables. */
define('DB_CHARSET', 'utf8');

/** The Database Collate type. Don't change this if in doubt. */
define('DB_COLLATE', '');


Enter your new database name, database username and password. Usually the hostname is localhost. Other options exist, when you're not sure contact your hosting provider for the correct information. The above information I entered in accordance with the screenshot from step 4.

That's it! You now probably successfully moved your WordPress website to another domain or server.


Feel free to contact me for any questions or comments.

Marcel Westerhoff
Owner and Director k-Dushi Marketing B.V.

Marcel Westerhoff k-Dushi Marketing

Born in the Netherlands on August 31st 1982, graduated at Stenden University (formerly CHN) in International Hospitality Management in 2005. After being graduated for 2 years, and living and working in the Netherlands, Marcel decided to move to the island of Bonaire, Dutch Caribbean.

In June 2012 Marcel decided to start up his own business k-Dushi Marketing B.V. (before KaDushi Marketing E.Z.) after working for nearly 4 years as Marketing & Sales Manager for Sapias Holding. During these 4 years Marcel got to know both the diving industry and tourism industry managing the marketing activities for Buddy Dive Resort Bonaire, Buddy Dive Liveaboards Galapagos, Belmar Oceanfront Apartments Bonaire, Caribbean Club Bonaire, and M.C. Seaman II Naturalist Liveaboard Galapagos.

Till today Marcel is enjoying working as the only person in his business which makes it able for companies to deal with just one person regarding all their marketing activities. This advantage creates a high service level in combination with customization.

"It would be a pleasure to do business with you!"

Take a Look at
Some of Our Work

Wide range of successful digital and print projects.

All
Web Design
Graphic Design
Branding
Logo Design
  • Website design Bonaire Holiday Home
  • Buitenhuis De Veenhorst
  • Branding Bonaire
  • web design Mangazina di Rei
  • graphic design k-Dushi Marketing
  • website design Bonaire
  • Bonaire graphic design
k-Dushi Graphic Design Bonaire

I have been extremely impressed with k-Dushi. It is a pleasure working
with
highly creative and inovative team.

Harrie Schoffelen, Owner/Director, Tafkah / VIT Sound Rental - Bonaire, Dutch Caribbean

k-Dushi Marketing Web Design Bonaire

I've worked with k-Dushi since their startup. The service they provide is great, the products they deliver very satisfying! Thank you!

Gijs Hoogerkamp, Owner, Receptenbundel.nl / Gratis.nl - Netherlands

Marketing Company Bonaire

For the past three years, k-Dushi Marketing has handled my web site design and updates, social media campaigns, along with my entire brochure and flyer needs. They are both creative and efficient. We get wonderful result from all that they do for us. Thank you k-Dushi Marketing for helping me grow my business and become more successful. We love k-Dushi!

Diane Thiele, President, Quest Dive Adventures - Atlanta, Georgia USA

(+599) 787-3310

info@k-dushi.com

Kaya Turkesa 15A
Bonaire, Dutch Caribbean


Please make an appointment before visiting us. Thank you!