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.