How to Setup Existing WordPress Site on Hosting Server

Setting up a new WordPress website on a hosting server is an easy task as all you have to do is to install various files on your server and you are good to go but have you ever in need of, to set up an existing WordPress website on your hosting server? Well people who purchased running WordPress websites might have to experience this, most people think it’s a hectic task to setup an existing WordPress website along with the domain on your own web hosting server. But we are going to discuss an easy way to setup WordPress website along with the domain on new web hosting server.

Well once you have bought a WordPress website the previous website owner will provide you all the information you need. Once you received the whole back-up of the website, it contain two zip folders one include database SQL import file and the other one is WordPress domain directory. After receiving these two files you might have thought that all you have to do is to upload these files on your web hosting server, well it’s not that simple.

First of all you need to check out MySQL database file which look like something like this MYHOSTID_MYDBNAME as you see the prefix of this file is hosting ID which and postfix is the name of your database. Some people try to restore MySQL database using cPanel which use sql file name to import tables to the identical named database or create new one but they failed. Nothing to worry about there is several steps which one has to follow in order to set up purchased WordPress website:

  • Relocate the domain to your domain service provider
  • Set up the acquired domain on your hosting server
  • Install WordPress database files on your server
  • Configure your WordPress website properly on wordpress hosting server.

Things Required to Setup WordPress Website:

  • MySQL database restore file, DBprefix_DBname.sql
  • Entire WordPress website directory
  • Existing WordPress administrator UserID and Password

Relocate the domain to your domain service provider

First of all you need to relocate the purchased domain to your domain service provider; this has to be done by the previous owner of the domain if you both have same domain service provide than all it takes is “Push”. But if you don’t have same domain services provider than you have to create a free account with the domain service provider of previous website owner and then he push the domain in to your account, accept it and pointed the domain to your DNS sever and you are done!

Setting up the acquired domain on your hosting server

Most of the hosting plans offer unlimited add-on domains so log in to your cPanel and create new add-on domain. Well you don’t need to install WordPress blog setup wizard as it’s done by restoring WordPress database and uploading WordPress websites directory files.

Than enter the new domain name address in the browser address bar and you’ll see everything seems to be working fine so far as you can see cgi-bin directory created by default. As you have got access to the root directory bow you can upload WordPress website directory content to the domain directory easily. You can do that using FTP or use cPanel->files->backup wizard.

Now if you reentered the domain name in browser you’ll get the expected “database connection error” as you have not install and configure database yet.

Install WordPress database files on your server

Installation of WordPress database files on your server can be done in three steps:

  • Build the WordPress Database and pull over information
  • Amend WordPress Database content
  • Upload WordPress Database (control panel)
  1. 1.      Build the WP Database and access information

Whenever you want to access WordPress website it’ll connect to the WP database first, this database access the information stored in wp-config.php file that islocated in the root directory of the domain. That’s why you need to change the three variables in the file wp-config.php that are:

  • Name of WordPress database
  • MySQL database user-name
  • MySQL database password

The database password might be encrypted which result in connection fail error, so in order to deal this issue you can use an existing user-name and password by applying few changes.

Create WordPress database named ABCD (cPanel->databases->MySQL databases) and add the existing user to new WP database you have created and assign all the privileges. Now all you have to do is to modify database name and copy the values of database username and password to the existing wp-config.php file and connection will work fine.

Download the wp-config.php file for new WordPress blog, make changes to constraints and upload it.

  1. 2.      Amend WordPress Database content

There are few changes which you have to perform, you can either make these changes from the database directory later on or can amend them while configuring WordPress website.

You have to perform few changes at different places but in order to do so you need to locate the tables that are mentioned above:

  • wp_options table: change the values of admin email and give the new one.
  • wp_users table: change the value of user-email for admin, so that you’ll be able to retrieve password by getting password rest email on your given id.
  1. 3.      Upload the WordPress Database (Control Panel)

First of all you need to carefully define user-name for WordPress database SQL file as cPanel deal with the database in the context of WP database SQL file name and Do Not define database prefix as cPanel automatically assigned hosting server ID to it.

In order to restore WordPress database using cpanel, go to Files -> Backup Wizard, choose “Restore” > MySQL Databases, find your local MySQL restore file and click restore, a new window will pop-up and restoring process will begin, make sure the restoring process is ended completely and whole file is displayed on this page. You can check all MySQL databases from cPanel->databases->PHP Admin panel.

After completing this process you’ll be able to see you new blog and can access the admin panel.

Configure your WordPress website properly

In order to configure WordPress website properly you need to configure various aspects.


  • Membership: Anyone can register
  • Timezone



  • Remote Publishing: change both values to active, if you are willing to use external publishing tools.
  • Privacy: Make your blogs visible to everyone and search engines (Google, Bing, Yahoo)
  • Permalinks: you can define categories or modify postnames.

All In One SEO Plugin:

  • Use noindex for Categories: false
  • Use noindex for Archives: true

OTHER setting and Configurations

Copy robots.txt to root folder or may install the KB Robots.txt plug-in.

Check out additional configurations you need to modify and you are done! Your WordPress website is moved and set up on your hosting server.

Control Panel

A control panel is required to manage web hosting activities of web hosting server, it is a web-based interface provide by web hosting companies to the user to manage their web hosting account. There are several types of web hosting control panels are available and each of them has different functionalities. The most commonly used control panels are:

  • cPanel
  • Plesk

cPanel: cPanel is one of the most commonly used control panel, it is a Linux based control panel which is designed to provide an ease in terms of managing various web hosting activities, it is based on three tier structure which is provide access to administrator, reseller and website owner to manage server according to their needs. The most prominent aspect of cPanel is that is provides Graphical User Interface (GUI) along with command line and API based access which allows web developers or system administrators to automate the process of standard server administration.

As far as application support is concerned it provides support for latest web applications which mainly include PHP, Perl, Apache, MySQL and more. It also offer support for email based servers such as POP2, IMAP and SMTP services. The best feature of cPanel is that it offer one click installation of application which mean one don’t have to upload each file manually, that’s why it is high recommended by web developers.

Plesk: Plesk which is also known as Parallel Plesk, Parallel Plesk Control panel and Plesk server administrator. It is designed to manage web hosting servers based on various operating systems such as Linux, UNIX, Ubuntu, Red Hat Linux and more beside this it also support Windows server edition 2003 and 2008 operating systems. Plesk offers Graphical User Interface (GUI) which allow easy sever management, website setup and effective management of reseller and email accounts.

One major feature of Plesk is that it provide Add-ons for different purposes, using Plesk one can easily install various add-ons with just a click. The most commonly used Plesk add-ons are:

  • Plesk Customer & Business Manager
  • Plesk Site Builder
  • Plesk Expand for multiple server support

As far as application support is concerned it provide complete support for latest web applications and one can easily install any application with just a click.