In the first part of the article, I described why Bob purchased the WordPress website, how to transfer the domain, and set up the domain on his hosting server. Part two will take a closer look at how to install the WordPress websites database and configure some important WordPress Website settings.
Upload the WordPress Database files
- Let’s break this part down into 3 simple steps:
- Create the WordPress Database and access information
- Modify the WordPress Database content
- Upload the WordPress Database (Cpanel)
Create the WordPress Database and access information (Cpanel)
You could restore the database directly, but Bob will also explain why he created the WordPress database himself for this exercise. So here comes the tricky part. When you want to access the WordPress website, it will first 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_ asking);
- /** 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, asking (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.
RELATED ARTICLES :
- How Intel’s Latest Server Chip Will Speed Up every day Internet Services & Future Technologies
- How to Get Qualified Bloggers to Review Your Book
- Android O to Feature Paste as Plain Text, Individual Notification Channels for Chrome Websites
- How to Find WordPress Plugins that Complement Your business
- How to Seamlessly Integrate Your SEO and CRO Efforts
Now you only needed to 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 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 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 do a global change too:
- wp_options table – Change values of:
- – ‘admin_email’, –> your email.)
- – Path prefixes: home/uu uu uu/public_html –> home/bob55/public_html
- wp_users table: Change the value of user_email field for the admin user so you will be able to have the password reset sent to your email
That’s it!:-) The user_email is especially helpful if you do not know the WordPress website’s admin password. Request the password to be reset, and you will get the password to 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,” which will convert the DBname.sql into a DBname.sql.gz file.
To restore the WordPress Database, in Cpanel, go to 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 see your new blog and enter the admin panel your domain/wp-admin.