In the fist a part of the item I defined why Bob bought the WordPress internet site, the way to switch the area and the putting in of the area on his web hosting server. Part two will take a closer appearance on how to install the WordPress web sites database and configure a few critical WordPress Website settings.

1. Upload the WordPress Database documents

Let’s wreck this part down into three simple steps:

a) Create the WordPress Database and get right of entry to records

b) Modify the WordPress Database content material

b) Upload the WordPress Database (cpanel)

a) Create the WordPress Database and get entry to facts (cpanel)

 

READ MORE :

You could restore the database directly, but for this exercising Bob may even give an explanation for why he created the WordPress database himself. So here comes the complicated element. When you need to get entry to the WordPress internet site, it will first attempt to hook up with the WordPress database. The corresponding get entry to facts is stored within the wp-config.Php report, placed inside the root directory of the brand new domain. You can look it up within the WordPress listing files you purchased. Therefore, you will need to trade the following three variables within the wp-config.Personal home page file:

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

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

/** database username */

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

/** database password */

outline(‘DB_PASSWORD’, ‘xxxxxxxxxx’);

The DB_PASSWORD parameter I got is encrypted and of little need to me, therefore the connection will fail. To get around this problem bob will show you a bit trick; Bob reused an existing user (and password) already assigned to some other WordPress Database.

First he created the WordPress database, akkingb (in cpanel > Databases > MySql Databases) and brought the EXISTING user to the new database(Scroll all the way down to MySQL Users and add the person bob55_ akdbadm to the database he just created, bob55_ akkingb, and assign ALL PRIVILEGES.

Now you most effective wanted adjust DB_NAME parameter, copy the values for DB_USER and ‘DB_PASSWORD from the wp-config.Hypertext Preprocessor record of your EXISTING WordPress Blog, and the relationship will paintings perfectly;-)

So, download or extract the wp-config.Php file for your new WordPress blog, exchange the parameters and add it again.

B) Modify the WordPress Database content material

There is some information in the WordPress Website that you could both alter afterward, if you have controlled to access your new WordPress blog or exchange it without delay in the WordPress Database record. I choose to do the latter, as it’s miles pretty simple and a nice time saver when configuring the WordPress Website.

There are a few common values that are used in diverse places so if you do a locate/update (all) it’s a count number of minutes to get this accomplished. I will let you know what tables are affected, so that you recognize in which to look and trade it manually, however you could in reality do a worldwide exchange too:

wp_options desk – Change values of:

– ‘admin_email’, –> your electronic mail.)

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

wp_users table: Change fee of user_email field for the admin consumer so you may be capable of have the password reset ship for your e-mail

That’s it!:-) The user_email is specifically beneficial in case you do not understand the WordPress internet site’s admin password. Simply request the password to be reset and you may get the password ship to the email you chose;-)

c) Upload the WordPress Database (cpanel)

The vital point here is to name the WordPress database square report effectively. When restoring through the cpanel it’ll use the database in step with the WordPress database sq. Report call. Do NOT upload a database prefix, as this may be assigned routinely, and need to be your web hosting server ID; in Bob’s case, bob55. Hence, Bob named his report akkingb.Square, and the ensuing entire database call could be bog55_ akkingb.

Bob had problems with WordPress Database restores when the file turned into now not zipped in the proper layout. The repair both did not run in any respect or broke at any point. Therefore it’s a good idea to get the unfastened Gzip report compression software. For greater facts go to gzip.Org. The syntax is “C:Program FilesGnuWin32bingzip.Exe” DBname.Sq.” and this will convert the DBname.Square right into a DBname.Square.Gz document.

To repair the WordPress Database, in cpanel, pass the Files > Backup Wizard, pick “Restore” > MySQL Databases, locate your nearby repair file, akkingb.Sq..Gz and click on “Restore”. Now a new browser window will open up and the DB restore must start inside seconds.

You realize that the repair should have terminated efficaciously if you see the complete WordPress Database document in this page. You can confirm the DB advent also through the cpanel > Databases > Php Admin panel. All your databases are indexed on the left hand facet.

We are nearly completed!:-). You must now be capable of see your new blog and input the admin panel yourdomain/wp-admin.

2. Configuring your WordPress Website

Any WordPress Blog configuration is distinct, however following letsl name simply some of the WordPress Website settings..

* WordPress SETTINGS*

General:

Membership: Anyone can sign up
Timezone
Writing:
Remote Publishing: set each values active if you need to apply outside publishing tools
Privacy: I would love my blog to be visible to every body, along with search engines like google (like Google, Bing, Technorati)
Permalinks: you could want to alternate to i.E. /%class%/%postname%/ OR /%postname%.Html, or every other values you operate in your other blogs
All In One search engine optimization Plugin
Use noindex for Categories: false
Use noindex for Archives: true
* WordPress PLUGINS*
Akismet Configuration: Enter YOUR Akismet API Key
Remove or upload some other Plugins
*OTHER setting and configurations*
Copy your robots.Txt to root folder or installation the KB Robots.Txt plugin
Monetizeation like AdSense, Amazon, would require even modifying he corresponding subject files or configuration via plugins.