Within the first a part of the article, I described why Bob acquired the WordPress web site, easy methods to switch a website, and arrange a website on its internet hosting server. Within the second half, we are going to take a look at easy methods to set up the WordPress website database and configure some vital WordPress website settings.
1. Obtain WordPress database recordsdata.
Let's break this down into three straightforward steps:
a) Create a WordPress database and entry info
b) change the contents of the WordPress database
b) Obtain WordPress database (cpanel)
a) Create a WordPress database and entry info (cpanel)
You may restore the database straight, however for this train, Bob will even clarify why he himself created the WordPress database. So, right here begins the troublesome half. If you wish to entry a WordPress web site, it should first strive to hook up with the WordPress database. The related entry info is saved within the wp-config.php file positioned within the root of the brand new area. You may view it within the WordPress directories you acquired. Subsequently, it's good to change the next three variables within the wp-config.php file:
/ ** Database Identify for WordPress * /
outline (& # 39; DB_NAME & # 39 ;, & # 39; bob55_ akkingb & # 39; );
/ ** database username * /
outline (& # 39; DB_USER & # 39;, & # 39; bob55_ akbbadm & # 39;);
/ ** database password * /
outline (& # 39; DB_PASSWORD & # 39 ;, & # 39; & # XXXXXXXXXX 39; );
The DB_PASSWORD parameter I acquired is encrypted and ineffective for me, so the connection won't be established To get round this drawback, Bob will present you a bit of trick; Bob reused an current person (and password) already assigned to a different WordPress database.
He first created a WordPress database, akkingb (in cpanel> Databases> MySql Databases) and added the EXISTING person to the brand new database (scroll all the way down to MySQL Customers and add the person bob55_ akbbadm to the database he simply created, bob55_ akkingb and assign ALL PRIVILEGES.
Now you solely want to alter the DB_NAME parameter, copy the values for DB_USER and & # 39; DB_PASSWORD out of your weblog's EXISTING WordPress wp-config.php file, and the connection will work positive ;-)
So, obtain or extract the wp-config.php file on your new WordPress weblog, change the settings and add it once more.
b) change the contents of the WordPress database
There may be some info on the WordPress web site that you may edit later once you handle to entry the brand new WordPress weblog, or edit it straight within the WordPress database file. I choose to do the latter, as it's fairly easy and pleasantly saves time when organising a WordPress website.
There are a number of widespread values which can be used somewhere else, so when you do a search / exchange (all), it should take a couple of minutes to do it. I'll let you know which tables are affected in order that you realize the place to look and alter it manually, however you may also simply make a worldwide change:
Desk wp_options - change values:
- & # 39; admin_email & # 39;, -> your e mail tackle.)
- Path prefixes: house / uuuuuuuu / public_html -> house / bob55 / public_html
Wp_users desk: change the worth of the user_email subject for a person with administrator rights in an effort to ship a password reset to your e mail
That's all! :-) User_email is particularly helpful when you don’t know the WordPress website admin password. Simply request a password to reset, and you'll obtain a password to the e-mail tackle you selected ;-)
c) Obtain WordPress database (cpanel)
The vital level right here is the proper naming of the sql file of the WordPress database. When restoring by way of cpanel, it should use the database based on the title of the WordPress database file. Do NOT add a database prefix, as it will likely be assigned mechanically and should be your host server ID; within the case of Bob, bob55 He, Bob referred to as his file akkingb.sql and the ensuing full database title might be lavatory55_ akkingb ,
Bob had issues restoring the WordPress database when the file was not archived within the right format. Restoration both didn't begin in any respect, or broke at any time. Subsequently, it's not unhealthy to get a free Gzip file compression utility. For extra info, go to gzip.org. The syntax is "C: Program FilesGnuWin32bingzip.exe" DBname.sql ", and this converts DBname.sql to DBname.sql.gz.
To revive the WordPress database, in cpanel go to “Information”> “Backup Wizard”, choose “Restore”> “MySQL Databases”, discover the native restoration file, akkingb.sql.gz and click on "Restore". A brand new browser window will now open, and the restoration of the database ought to start in just a few seconds.
You already know that the restoration ought to have accomplished accurately when you see the complete WordPress database file on this web page. You may verify the creation of the database additionally by way of cpanel> Databases> Php admin panel. All of your databases are listed on the left.
We're virtually accomplished! :-). Now you may see your new weblog and enter yourdomain / wp-admin admin panel.
2. Customise your WordPress website
Any WordPress weblog configuration is totally different from the one under, however a few of the following WordPress settings are:
* WordPress SETTINGS *
- Membership: anybody can register
- Distant publishing: set each values to lively if you wish to use exterior publishing instruments
- Privateness: I would love my weblog to be seen to everybody, together with search engines like google and yahoo (similar to Google, Bing, Technorati)
- Everlasting hyperlinks: you could wish to change to /% class% /% postname% / OR /%postname%.html or to every other values that you simply use in different blogs.
- Use noindex for classes: false
- Use noindex for archives: true
- Akismet configuration: enter YOUR Akismet API key
- Take away or add every other plugins
- Copy the robots.txt to the foundation folder or set up the KB Robots.txt plugin.
- Monetization, like AdSense, Amazon, will even require modifying the suitable theme or configuration recordsdata utilizing plugins, ...