Tag Archives | Database Content

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

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

In the fist part of the article I described why Bob purchased the WordPress website, how to transfer the domain and the setting up of the domain on his hosting server. Part two will take a closer look on how to install the WordPress websites database and configure some important WordPress Website settings.

1. Upload the WordPress Database files

Let’s break this part down into 3 simple steps:

a) Create the WordPress Database and access information

b) Modify the WordPress Database content

b) Upload the WordPress Database (cpanel)

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

You could restore the database directly, but for this exercise Bob will also explain why he created the WordPress database himself. So here comes the tricky part. When you want to access the WordPress website, it will first try to connect to the WordPress database. The corresponding access information is stored in the wp-config.php file, located in the root directory of the new domain. You can look it up in the WordPress directory files you got. Therefore, you will need to change the following three variables inside the wp-config.php file:

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

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

/** database username */

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

/** database password */

define(‘DB_PASSWORD’, ‘xxxxxxxxxx’);

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

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

Now you only needed modify DB_NAME parameter, copy the values for DB_USER and ‘DB_PASSWORD from the wp-config.php file of your EXISTING WordPress Blog, and the connection will work perfectly;-)

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

b) Modify the WordPress Database content

There is some information in the WordPress Website that you can either modify later on, when you have managed to access your new WordPress blog or change it directly in the WordPress Database file. I prefer to do the latter, as it is quite simple and a nice time saver when configuring the WordPress Website.

There are a few generic values that are used in diverse places so if you do a find/replace (all) it’s a matter of minutes to get this done. I will tell you what tables are affected, so you know where to look and change it manually, but you can simply do a global change too:

wp_options table – Change values of:

– ‘admin_email’, –> your email.)

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

wp_users table: Change value of user_email field for the admin user so you will be able to have the password reset send to your email

That’s it!:-) The user_email is especially helpful if you do not know the WordPress website’s admin password. Simply request the password to be reset and you will get the password send to the email you chose;-)

c) Upload the WordPress Database (cpanel)

The important point here is to name the WordPress database sql file correctly. When restoring via the cpanel it will use the database according to the WordPress database sql file name. Do NOT add a database prefix, as this will be assigned automatically, and should be your hosting server ID; in Bob’s case, bob55. Hence, Bob named his file akkingb.sql, and the resulting complete database name will be bog55_ akkingb.

Bob had problems with WordPress Database restores when the file was not zipped in the correct format. The restore either did not run at all or broke at any point. Therefore it’s a good idea to get the free Gzip file compression utility. For more information go to gzip.org. The syntax is “”C:Program FilesGnuWin32bingzip.exe”” DBname.sql”” and this will convert the DBname.sql into a DBname.sql.gz file.

To restore the WordPress Database, in cpanel, go the Files > Backup Wizard, select “”Restore”” > MySQL Databases, locate your local restore file, akkingb.sql.gz and click “”Restore””. Now a new browser window will open up and the DB restore should start within seconds.

You know that the restore should have terminated correctly if you see the whole WordPress Database file on this page. You can verify the DB creation also through the cpanel > Databases > Php Admin panel. All your databases are listed on the left hand side.

We are almost done!:-). You should now be able to see your new blog and enter the admin panel yourdomain/wp-admin.

2. Configuring your WordPress Website

Any WordPress Blog configuration is different, but following letsl name just some of the WordPress Website settings..

* WordPress SETTINGS*

General:

Membership: Anyone can register
Timezone
Writing:

Remote Publishing: set both values active if you want to use external publishing tools
Privacy: I would like my blog to be visible to everyone, including search engines (like Google, Bing, Technorati)
Permalinks: you may want to change to i.e. /%category%/%postname%/ OR /%postname%.html, or any other values you use in your other blogs
All In One SEO Plugin

Use noindex for Categories: false
Use noindex 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 install the KB Robots.txt plugin
Monetizeation like AdSense, Amazon, will require even editing he corresponding theme files or configuration through plugins,…
That’s it, your WordPress Website has been moved and setup on your hosting server:-). To see the life example, go to kingkoilmattresses.net.

0