In the fist component of the content I described the reason why Bob purchased typically the WordPress website, how to transfer the domain name and the establishing up in the site on his hosting server. Part two will take a new closer look about how to install the WordPress websites database and set up some important Blogger Website settings.

1. Upload the Blogger Database files

Why don’t break this portion down into 3 easy steps:

a) Create the WordPress Database and access data

b) Modify typically the WordPress Database information

b) Upload the particular WordPress Database (cpanel)

a) Create typically the WordPress Database and even access information (cpanel)

You could restore the database directly, but for this specific exercise Bob will certainly also explain the reason why he created the Wp database himself. So here comes the tricky part. When you need to access typically the WordPress website, this will first try out to connect to the WordPress repository. The related access info is stored throughout the wp-config. php file, located in typically the root directory regarding the brand new domain. A person can look it up in the WordPress directory documents you have. Therefore, a person will need in order to replace the following 3 variables inside typically the wp-config. php record:

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

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

/** database username */

define(‘DB_USER’, ‘bob55_ akdbadm’);

/** databases password */

define(‘DB_PASSWORD’, ‘xxxxxxxxxx’);

The DB_PASSWORD parameter I got is protected and of no make use of to me, as a result the connection may fail. To get around this problem frank will highlight a small trick; Bob used again an existing customer (and password) previously assigned to another WordPress Database.

First he created typically the WordPress database, akkingb (in cpanel > Databases > MySql Databases) and added typically the EXISTING user for the new database(Scroll right down to MySQL Users and add the user bob55_ akdbadm to the database he simply created, bob55_ akkingb, and assign ALMOST ALL PRIVILEGES.

You now only needed modify DB_NAME parameter, copy the particular values for DB_USER and ‘DB_PASSWORD from the wp-config. php file of your own EXISTING WordPress Blog, as well as the connection will certainly work perfectly; -)

So, download or extract the wp-config. php file for your new WordPress blog site, change the variables and upload this again.

b) Improve the WordPress Database written content

There is definitely some information throughout the WordPress Site that you can easily either modify later on, when a person have was able to entry your new WordPress blog or change it out directly in typically the WordPress Database record. I favor to carry out the latter, as it is quite simple and a nice moment saver when configuring the WordPress Website.

There are a new few generic ideals that are applied in diverse places if you do the find/replace (all) really a matter associated with minutes to start this. My partner and i will tell you what tables usually are affected, so you know where you can appear and change that manually, but you can simply carry out a global transform too:

wp_options table – Change ideals of:

– ‘admin_email’, –> the email. )

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

wp_users table: Transformation value of user_email field for typically the admin user so you will become able to hold the password reset send out to your e-mail

That’s it!: -) The user_email is usually especially helpful in the event that you do certainly not know the Blogger website’s admin password. Simply request the password to end up being reset and an individual will get the password send in order to the email an individual chose; -)

c) Upload the WordPress Database (cpanel)

Typically the important point this is to name the particular WordPress database sql file correctly. If restoring via the particular cpanel it will eventually employ the database based on the WordPress database sql file name. Usually do not add a data source prefix, as this kind of will be designated automatically, and should become your hosting hardware ID; in Bob’s case, bob55. Hence, Bob named their file akkingb. sql, plus the resulting complete database name will certainly be bog55_ akkingb.

Bob had difficulties with WordPress Data source restores when typically the file was not really zipped in the perfect format. The bring back either did not work at all or perhaps broke at any point. Therefore is actually a good concept to get the particular free Gzip file compression utility. With regard to more information go to gzip. org. The syntax is „C: Program FilesGnuWin32bingzip. exe“ DBname. sql“ and also this will convert the DBname. sql in a DBname. sql. gz file.

To regain the WordPress Database, in cpanel, move the Files > Backup Sorcerer, select „Restore“ > MySQL Sources, locate your local restore file, akkingb. sql. gz and even click „Restore“. Right now a new web browser window will open up and the DECIBLE restore should start off within seconds.

You know that the particular restore should possess terminated correctly if you see typically the whole WordPress Database file on this particular page. You could validate the DB generation also through the cpanel > Data source > Php Admin panel. Just about all your databases are generally listed on typically the left hand area.

We are almost done!: -). You need to now be capable of see your new blog and get into the admin screen yourdomain/wp-admin.

2 . Configuring your WordPress Internet site

Any WordPress Website configuration is different, although following letsl name just some of the WordPress Internet site settings..

* Live journal SETTINGS*

General:

Membership rights: Anyone can enroll

Timezone

Writing:

Remote Publishing: set both values active when you want in order to use external posting tools

Privacy: I actually would like our blog to be visible to everyone, including search motors (like Google, Google, Technorati)

Permalinks: an individual may want in order to change to i. e. /%category%/%postname%/ OR EVEN /%postname%. html, or some kind of other values you make use of in your some other weblogs

All Inside One SEO WordPress tool

Use noindex regarding Categories: false

Use noindex for Records: true

* WordPress PLUGINS*

Akismet Setup: Enter YOUR Akismet API Key

Remove or add every other Plugins

*OTHER environment and configurations*

Duplicate your robots. txt to root file or install the particular KB Robots. txt plugin

Monetizeation like AdSense, Amazon, requires even editing they corresponding theme documents or configuration by way of plugins,…

That’s this, your WordPress Internet site has been moved and setup upon your hosting machine: -). To find the life example, go to kingkoilmattresses. net.

Just in case you skipped the full write-up about How to be able to Set Up an Existing WordPress Website on Your Hosting Server, you can definitely find the Set Upward Existing WordPress Web site [http://product-reviews-group.info/internet-business/wordpress/how-to-set-up-an-existing-wordpress-website-your-hosting-server/]