WordPress Maintenance: Tips for WordPress Website Maintenance

In the fist part of the thing I defined why Bob bought the WordPress website, the way to switch the area and the setting up of the area on his web hosting server. Part will take a closer look on a way to deploy the WordPress websites database and configure a few vital WordPress Website settings.

1. Upload the WordPress Database files

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

a) Create the WordPress Database and get entry to information

b) Modify the WordPress Database content material

b) Upload the WordPress Database (cpanel)

a) Create the WordPress Database and get admission to facts (cpanel)

You could restore the database at once, but for this workout Bob will even explain why he created the WordPress database himself. So here comes the complex component. When you want to get admission to the WordPress website, it’ll first try to connect to the WordPress database. The corresponding get right of entry to information is saved in the wp-config.Personal home page record, located inside the root listing of the brand new domain. You can look it up inside the WordPress listing files you got. Therefore, you may need to alternate the subsequent three variables inside the wp-config.Hypertext Preprocessor report:

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

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

/** database username */

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

/** database password */

outline(‘DB_PASSWORD’, ‘xxxxxxxxxx’);

The DB_PASSWORD parameter I were given is encrypted and of little need to me, consequently the relationship will fail. To get round this problem bob will show you a touch trick; Bob reused an present person (and password) already assigned to another WordPress Database.

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

Now you handiest wished alter DB_NAME parameter, 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 paintings flawlessly;-)

So, down load or extract the wp-config.Personal home page document on your new WordPress blog, trade the parameters and upload it once more.

B) Modify the WordPress Database content

There is a few facts in the WordPress Website that you can both alter later on, if you have controlled to access your new WordPress weblog or trade it without delay in the WordPress Database record. I choose to do the latter, as it’s far pretty simple and a nice time saver while configuring the WordPress Website.

There are some frequent values which are used in various locations so in case you do a locate/replace (all) it is a depend of minutes to get this performed. I will tell you what tables are affected, so that you understand where to appearance and alternate it manually, however you may really do a worldwide exchange too:

wp_options table – Change values of:

– ‘admin_email’, –> your e mail.)

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

wp_users desk: Change cost of user_email discipline for the admin person so you’ll be capable of have the password reset ship in your electronic mail

That’s it!:-) The user_email is in particular beneficial in case you do no longer know the WordPress website’s admin password. Simply request the password to be reset and you will get the password send to the e-mail you chose;-)

c) Upload the WordPress Database (cpanel)

The essential point here is to call the WordPress database sq. Document efficaciously. When restoring via the cpanel it will use the database according to the WordPress database square record call. Do NOT upload a database prefix, as this can be assigned robotically, and should be your hosting server ID; in Bob’s case, bob55. Hence, Bob named his document akkingb.Sq., and the ensuing entire database name will be bog55_ akkingb.

Bob had issues with WordPress Database restores whilst the record changed into now not zipped in the proper layout. The repair either did no longer run at all or broke at any factor. Therefore it is a good idea to get the loose Gzip document compression software. For extra statistics visit gzip.Org. The syntax is “C:Program FilesGnuWin32bingzip.Exe” DBname.Sq.” and this could convert the DBname.Sq. Right into a DBname.Square.Gz document.

To repair the WordPress Database, in cpanel, go the Files > Backup Custom Wordpress Website Wizard, select “Restore” > MySQL Databases, find your neighborhood repair record, akkingb.Square.Gz and click “Restore”. Now a brand new browser window will open up and the DB repair need to begin within seconds.

You recognise that the restore need to have terminated efficiently if you see the complete WordPress Database report in this page. You can confirm the DB introduction also through the cpanel > Databases > Php Admin panel. All your databases are indexed on the left hand aspect.

We are almost completed!:-). 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 one of a kind, but following letsl name simply some of the WordPress Website settings..