In the first part of the item, I defined why Bob bought the WordPress internet site, switched the area, and put it in the area on his web hosting server. Part two will take a closer look at installing 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 :
- WordPress SEO Plugins Revealed
- How to Wash, Wax, and Polish Your Car
- How to Sell Your Property Online With Digital Marketing Tools
- How to Choose Between On-Premises and Cloud Customer Relationship Management Software
- How to Profit From Mobile Marketing For Your Business
You could restore the database directly, but Bob may even explain why he created the WordPress database himself for this exercise. 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 entry to facts is stored within the wp-config.Php report, placed inside the brand new domain’s root directory. 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, asking (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_ asking, and assign ALL PRIVILEGES.
You most effectively wanted to adjust the DB_NAME parameter and 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 include 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 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.
A few common values 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 to recognize how to look and trade them 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/uu uu uu/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 if you do not understand the WordPress internet site’s admin password. 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 asking.Square and the ensuing entire database call could be bog55_ asking.
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.” 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 on 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 seeing your new blog and input the admin panel your domain/wp-admin.
2. Configuring your WordPress Website
Any WordPress Blog configuration is distinct; however, let’s name simply some of the WordPress Website settings…
* WordPress SETTINGS*
General:
Membership: Anyone can sign up
Timezone
Writing:
Remote Publishing: set each value active if you need to apply outside publishing tools
Privacy: I would love my blog to be visible to everybody, 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 value 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 the root folder or installation the KB Robots.Txt plugin
Monetization like AdSense, Amazon, would require even modifying the corresponding subject files or configuration via plugins.