Activity

In the fist component of the article I described exactly why Bob purchased the particular WordPress website, the way to transfer the site and the establishing up in the website on his hosting server. Part a couple of will take a new closer look on how to set up the WordPress sites database and change some important Wp Website settings.

1. Upload the WordPress Database files

Why don’t break this portion into 3 simple steps:

a) Make the WordPress Repository and access details

b) Modify the particular WordPress Database content material

b) Upload typically the WordPress Database (cpanel)

a) Create the particular WordPress Database in addition to access information (cpanel)

You could bring back the database straight, but for this specific exercise Bob will also explain the reason why he created the WordPress database himself. So here comes the particular tricky part. When you wish to access the particular WordPress website, it will first consider to connect in order to the WordPress repository. The corresponding access information is stored in the wp-config. php file, situated in the particular root directory involving the modern domain. An individual can look it up in typically the WordPress directory data files you have. Therefore, a person will need in order to change the following a few variables inside typically the wp-config. php file:

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

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

/** database login */

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

/** repository password */

define(‘DB_PASSWORD’, ‘xxxxxxxxxx’);

The DB_PASSWORD parameter I obtained is protected associated with no use to me, as a result the connection will fail. To acquire surrounding this problem frank will highlight a tiny trick; Bob reused an existing user (and password) already assigned to one more WordPress Database.

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

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

So, download or extract the wp-config. php apply for your current new WordPress blog website, change the guidelines and upload that again.

b) Modify the WordPress Repository articles

There is definitely some information throughout the WordPress Internet site that you can either modify afterwards on, when an individual have were able to accessibility your new Blogger blog or change it out directly in typically the WordPress Database data file. I prefer to carry out the latter, as it is quite simple plus a nice time saver when configuring the WordPress Site.

There are a new few generic ideals that are utilized in diverse places so if you do a find/replace (all) really a matter of minutes of doing this. I will tell you what tables will be affected, so an individual know best places to appear and change this manually, but a person can simply do a global modify too:

wp_options stand – Change values of:

– ‘admin_email’, –> the email. )

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

wp_users table: Modification value of user_email field for typically the admin user so you will end up being able to possess the password reset send out to your electronic mail

That’s it!: -) The user_email will be especially helpful in case you do not know the Blogger website’s admin username and password. Simply request typically the password to be reset and you will get the password send to the email a person chose; -)

c) Upload the Wp Database (cpanel)

Typically the important point the following is to name the particular WordPress database sql file correctly. If restoring via typically the cpanel it will use the database in line with the WordPress database sql file name. Do NOT add a repository prefix, as this particular will be assigned automatically, and have to become your hosting hardware ID; in Bob’s case, bob55. Therefore, Bob named his / her file akkingb. sql, along with the resulting total database name may be bog55_ akkingb.

Bob had issues with WordPress Data source restores when typically the file was not really zipped in the appropriate format. The restore either did not manage at all or perhaps broke at any point. Therefore is actually a good idea to get the particular free Gzip data file compression utility. Intended for more information go to gzip. org. The syntax is “C: Program FilesGnuWin32bingzip. exe” DBname. sql” and this will convert typically the DBname. sql in a DBname. sql. gz file.

To recover the WordPress Data source, in cpanel, proceed the Files > Backup Wizard, select “Restore” > MySQL Data source, locate your area restore file, akkingb. sql. gz in addition to click “Restore”. Now a new web browser window will open up and the DECIBLE restore should start within seconds.

You know that typically the restore should have got terminated correctly in the event that you see the whole WordPress Data source file on this kind of page. You could validate the DB design also through the cpanel > Sources > Php Admin panel. Most your databases are generally listed on typically the left hand area.

We are almost completed!: -). You ought to now be capable to see your fresh blog and enter the admin panel yourdomain/wp-admin.

2 . not Setting up your WordPress Website

Any WordPress Blog configuration differs, although following letsl brand just some regarding the WordPress Site settings..

* Blogger SETTINGS*

General:

Account: Anyone can register

Timezone

Writing:

Remote control Publishing: set equally values active when you want to be able to use external posting equipment

Privacy: We would like my personal blog to end up being visible to everyone, including search engines (like Google, Google, Technorati)

Permalinks: a person may want to change to my partner and i. e. /%category%/%postname%/ OR /%postname%. html, or any type of other values you make use of in your some other sites

All Inside One SEO WordPress tool

Use noindex for Categories: false

Work with noindex for Records: true

* Blogger PLUGINS*

Akismet Configuration: Enter YOUR Akismet API Key

Take out or add every other Plugins

*OTHER environment and configurations*

Copy your robots. txt to root file or install typically the KB Robots. txt plugin

Monetizeation such as AdSense, Amazon, requires even editing he corresponding theme files or configuration through plugins,…

That’s it, your WordPress Website has been moved and setup about your hosting storage space: -). To find the existence example, visit kingkoilmattresses. net.

If you happen to skipped the full article about How to Set Up an Existing WordPress Website in your Hosting Server, you can definitely find the Set Upward Existing WordPress Website