Tutorials

[How-To Guide] Repair And Optimize WordPress Database

As a webmaster, it’s a nice thing to optimize blog’s database because optimizing a database improve the loading time of blog which indirectly improve’s the performance of database. Already many of them using WordPress plugins to optimize database but in this article I offer you a step-by-step guide to optimize database without using a WordPress plugin because already WordPress built-in Repair and Optimize functionality is available at the admin back-end.

Well you can check out this functionality by visiting

http://www.educationguide4u.com/wp-admin/maint/repair.php

(replace http://www.educationguide4u.com/ with your real blog/site url).

Step1: Login to your wp-admin section by visiting http://www.educationguide4u.com/wp-login.php

Step2: Now simply type http://www.educationguide4u.com/wp-admin/maint/repair.php in a new tab of your browser. After typing this URL and hitting enter button, it ask you to add a piece of code to WordPress wp-config.php file as shown below:

Step3: Add this code to WordPress wp-config.php file

define(‘WP_ALLOW_REPAIR’,true);

Step4: After adding this code just simply reload/refresh page and it will look like this:

Step5: Now you can see a page with two options (screen-shot of step4) first one is “Repair Database” and second one is “Repair and Optimize Database”. Click on any of the option.

Step5.1: If you click on “Repair Database” option, WordPress will automatically look for some common database problems and repair them automatically by executing SQL queries in WordPress database tables.

Step5.2: If you click on “Repair and Optimize Database” option, WordPress also attempt to optimize the database. this improves the performance in some situations.

Caution:

Repairing and Optimizing database option can take long time and database can be locked while optimizing.

Hope this will improve your WordPress blog’s performance and let us know in the comments section if you face any problems while optimizing and repairing your WordPress Database.

Note:

Please backup your WordPress Database before making any action on database.

[How-TO Guide] Checking MySQL Installation Works On PC Or Not?

Already in earlier articles I have provided you a step-by-step guide on installing and configuring MySQL offline on your PC. Now in this article I provide you a step-by-step guide on checking MySQL Installation whether it works correctly on your PC or not. The easiest way to check out MySQL Installation and confirm that it’s working properly is to use the MySQL Command Line Client.

Step1: Click on “Start Menu” and select “All Programs”.

Step2: Now click on “MySQL” and select “MySQL Server 5.1”

Step2: Now enter the MySQL password

Step3: The MySQL client displays the mysql> prompt on successful login.

Step4: Now run simple SQL command for example: Run “show databases;” and hit enter key on your keyboard. This simple command instructs MySQL to display the names of installed databases and they are 3.

Congratulations, you have successfully install MySQL and it is working correctly on your PC.

Do let us know in the comments section if you face any error while checking out your MySQL installation works correctly or not on your PC?

[How-to Guide] Configuring MySQL Offline On Your PC

Already in earlier article I had provided you a step-by-step guide on installing MySQL Offline on your PC. Now in this article I guide on configuring MySQL on your PC because without configuring it you can’t use it on your PC.

Follow the step-by-step guide to configure MySQL on PC.

Step1: Click on “Next” button to get started.

Step2: After clicking on “Next” button, you’ve to select “Detailed configuration” and click on “Next” button.

Step3: Now select “Developer Machine” and click on “Next” button

Step4: After clicking on “Next” button you’ve to choose Database, select “Multifunctional Database” as u don’t know what you’re doing and click on “Next” button.

Step5: Now don’t mess up the things and simply click on “Next” Button

Step6: Now select “Decision Support” and click on “Next” Button

Step7: Now select “Enable Strict Mode” for networking options and click on “Next” button.

Step8: Click on “Include Bin Directory In Windows Path” option and “Next” button to go ahead.

Step9: Now set the “Password” and click on “Next” button.

Step10: Now click on “Execute” button to execute the things.

Step11: Hit down the “Finish” button. Congratulations, you have successfully configured MySQL Offline on your PC.

You have successfully configured MySQL on your PC. Wait for next article which guides you to check out the MySQL installation works properly or not on your PC.

Do let us know in the comments section if you face any problem in configuring MySQL on your PC?

[How-To Guide] Install MySQL Offline On Your PC

MySQL, no doubt one of the most popular and widely used database/server which integrated with PHP scripts. MySQL is simple to use, which allows you to create and test web application without affecting the data on your live websites. This article guides on installing MySQL locally on your PC.

Follow the step-by-step guide and you will be able to install MySQL locally on your PC in few minutes.

Step1: Download MySQL installer from here

Step2: After Downloading the installer click on to start the set-up process as shown below:

Step3: After clicking on the next button, you will be ask to select the “Type of Set-up”. You have to choose only one out of three options available (I have chosen Typical Option).

Step4: Now simply click on “Install” button and this will install the “MySQL” on your PC.

Step5: After clicking on “Install” button, it will start installing it on your PC and take some time, (as shown below).

Step6: As soon as the installation process finishes,you will see a screen (as shown below). Now click on “Next” button to go ahead.

Step7: After clicking on “Next” button and it takes you next screen where you have to click on “Next”button again, as shown below:

Step8: After clicking on “Next” button, you’ll see the last screen which shows “Wizard Completed”. Congratulations – MySQL installed on your computer.