How to Set Up a Purchased WordPress Website on Your Hosting Server – Part 2 of 2

At the fist component of the article I described why Bob purchased the WordPress web site, how to transfer the domain and the setup of the domain name on his hosting server. Part two will require a good look on how best to put in the WordPress internet sites database and then configure several important WordPress Website settings.

1. Upload the WordPress Database documents

Let’s split down this part into 3 easy steps:

A) Create the WordPress Database and get information

B) Modify the WordPress Database content

You might restore the database directly, however also for this exercise Bob will even explain why he generated the WordPress database himself. So this comes the tricky part. When you would like to get the WordPress web site, it’ll first attempt to connect into the WordPress database. The corresponding access information is stored from the wp config. Php document, located in the main directory of this new domain names. You can look it up from the WordPress directory files you got. For this reason, you will have to improve the following three factors in the wpconfig. Php file:HOW CAN I INCREASE ORGANIC TRAFFIC TO MY WEBSITE FOR FREE

/** The name of this database for WordPress */

Define(‘DB_NAME’, ‘bob55_ akkingb’);

/ /** database username */

/** database password */

Define(‘DB_PASSWORD’, ‘ ‘xxx xxx xxxx’);

The DB_PASSWORD parameter I got is encoded and not good to me personally, therefore the connection will neglect. To go around this problem bob will reveal you just a tiny trick; Bob re used an present user (and password) already delegated to another WordPress Database.

First he generated the WordPress database, then akkingb (from cpanel > Databases > MySql Databases) and added the EXISTING user into the new database(Scroll down to MySQL Users and add the person bob55_ akdbadm into the database he simply created, bob55_ akkingb, and delegate ALL PRIVILEGES.

You only had modify DB_NAME parameter, copy the worth for DB_USER and ‘DB_PASSWORD from the wpconfig. Php record of your EXISTING WordPress Blog, and also the connection will continue to work perfectly;yet)

So, extract or download the wp-config. Php apply for the new WordPress site, change the parameters and then upload it again.

b) Modify the WordPress Database content

There’s some information in the WordPress Website that you can either alter in the future, once you have managed to access your new WordPress site or change it directly from the WordPress Database file. I like to do the latter, because it’s quite simple and also a great time saver when configuring the WordPress Website.

There certainly are a number of generic values that are used in diverse places therefore if you do a find/replace (all) it is really a few minutes to achieve this. I will Let You Know What tables have been changed, so that you know where to look and change it manually, however you can just do a global shift also:

Wp_options dining table – Change values of:

– ‘admin_email’, –> your email.)

– Path prefixes: home/uuuuuuuu/public_html –> house/bob55/public_html

Wp_users dining table: Change value of user_email field for the admin user so that you will be able to own the password reset send to your own email

That is it! :–RRB- The user_email is especially helpful should you not know the WordPress website’s admin password. Simply ask the password to be reset and you will get the password send to the email you selected;-)

c) Upload the WordPress Database (cpanel)

The important thing here would be to mention the WordPress database sql file correctly. When assigning via the cpanel it may make use of the database according to your WordPress database sql file name. Do NOT add a database prefix, as this will undoubtedly be assigned automatically, and should function as hosting server ID; at Bob’s case, bob55. Ergo, Bob termed his file akkingb.sql, and also the subsequent complete database name will likely be bog55_ akkingb.

Bob had issues with WordPress Database restores if the file wasn’t zipped in the appropriate format. The animate either did not run at all or broke at any point. Hence it is a fantastic idea to get the free Gzip file compression utility. To learn more go to

Now a brand new browser window will start and also the DB animate should start within minutes.

You are aware that the restore must have arisen right in the event that you see the complete WordPress Database document with this page. It’s possible to confirm the DB creation also through the cpanel > Databases > Php Admin panel. All your databases are all listed on the lefthand side.

We’re nearly done! :–RRB-. You should now be able to view your new blog and also enter the admin panel yourdomain/wp-admin.

2. Configuring your WordPress Website

Any WordPress Blog configuration differs, however after letsl name merely some of the WordPress Website preferences. .

* WordPress SETTINGS*


Membership: Anyone may enroll


Remote Publishing: place both worth active in the event that you’d like to use outside printing tools
Privacy: I would like my site to be visible to everyone, including search engines (like Google, Bing, Technorati)
Permalinks: you could choose to shift to i.e. /%category%/ percentpostname%/ OR /%postname%. Html, or some additional values that you used in your other blogs

All In One SEO Plugin

Use noindex for Categories: fictitious
Use no-index for Archives: true

* WordPress PLUGINS*

Akismet Configuration: Enter YOUR Akismet API Key
Remove or add any other Plugins

*OTHER setting and configurations*

Copy your robots.txt to root folder or put in the KB Robots.txt plugin
Monetizeation such as AdSense, Amazon, may need even editing or corresponding motif files or configuration through plugins, including…

Leave a Comment

Your email address will not be published. Required fields are marked *