WordPress

[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.

WebGuide4U: Back In Action And Ready To Shine On Web

It’s been quite three months passed since I stopped blogging because I’m working on few things which don’t belong to my interest. The work was not related to my blogging business and in return I wasted my valuable time on those things.

Why I’M Not Consistent?

In June 2010, I have completed my graduation (i.e. became Engineer in Electronics And Communication) and applied for a job in some companies. But at the same time I was keen to work in blogging field. I faced several problems as one graduate feels after getting out from his college. I felt ill too and it took two months for complete recovery.

After all these hassles in my life, I went back home and I convinced my parents for blogging (really it is one of the hardest thing, I’ve done in my life). I told them that whatever I’m doing is right for me and I can do this thing for my whole life. Now all the things are cleared and I am working full-time now.

In these past three months, I learned few lessons. I sat one say and analyzed all the mistakes I’ve done, also I tried to analyze all the drawbacks inside me. I asked my friends and my college seniors regarding my drawbacks and thanks to them to give me fair advice.

I want to thank all the people who helped me in my bad time specially My Parents, Honey Sir, Himanshu Sir, Raju Sir and all my friends.

Now I’ll work full time and try my best to provide the best and informative tutorials on WordPress, WebHosting, Web and Graphics Designing on WebGuide4U.

What I will do now?

From now onwards I will focus only on the areas of my expertise and organize all the things in a nice manner to accomplish all my dreams.

Subscribe to our feeds so that you can’t miss any of the updates from WebGuide4U

WordPress 3.0.1 Released To Fix 50+ Bugs

WordPress 3.0 thelonious already out there with lots of features and an awesome default theme twenty ten. WordPress 3.0 allows you to enjoy the feature of WordPress Mu into WordPress itself. WordPress 3.0 already hits 11 million downloads and now it’s time to upgrade the WordPress again as WordPress 3.0.1 hits the web to fix the bugs left in WordPress 3.0. WordPress 3.0.1 will address 50+ different bugs, including a privacy issue with trashed posts and Capital P dangit bug (automatically changes small “p” into capital “P” ) which results in lots of broken images.

After a long wait finally WordPress team released an updated version of WordPress 3.0 to fix almost 50+ bugs (as shown in the screenshot).

Now its time to update your WordPress blog again but before updating it make up a backup of your WordPress Blog.

If you are still facing problems in upgrading any of the feature of WordPress 3.0 then feel free to contact us via comments section.

[WordPress News] WordPress 3.2 Support PHP 5 And MySql 5.0.15

WordPress one of the most popular blogging platform and the easiest one to get started without any prior knowledge of web designing languages or any database information. We already talked to much about WordPress 3.0 from its installation to enabling many features like

How to Upgrade your WordPress Blog to WordPress 3.0

URL Shortener Feature Under Your Own Domain Name

How to Guide on Integrating Multi-Site Options in WordPress 3.0

How to Guide on Enabling WordPress MU in WordPress 3.0

How to Guide on Adding Multiple Blogs in WordPress 3.0

How to Guide on Adding New WordPress Themes in WordPress 3.0

As i know that many of them faces certain issues while enabling these features and most of them are unhappy with certain features of WordPress 3.0.

Today WordPress.org announced that in WordPress version 3.2 (which will be coming in 2011) you will require PHP 5.2 and MySQL 5.0.15 as already WordPress 3.1 hasn’t come till yet. WordPress 3.0 will be using PHP 4 and runs on MySQL 4 and WordPress 3.1 will be the last version using this because from this version they are ending their support from it.

According to the stats, only 11 % of WordPress installs are running on PHP version below 5.2 and less than 6% of WordPress users running MySQL 4.

Now you need a new host which will support PHP version 5 and MySQL database version 5.0.15 so that you can easily upgrade your WordPress blog to WordPress 3.2.

To help you out in finding the new host you might be interested in reading these articles:

How to Guide On Choosing A Good Web Host

Pros and Cons of Shared Hosting

VPS Hosting Is It Good or Not

Recommended WordPress Hosting

Advantages and Disadvantages of Dedicated Hosting

And if you are looking to get some discount on any hosting then check out these to get the huge discount on purchasing a new account with any of them:

20% Discount On Any Hosting Plan of Hostgator WordPress Hosting

Free Domain Name And $50 Discount On Dreamhost WordPress Webhosting

If you are still looking to get started to make your online venture then you need a Good Domain Name hope these articles will help you out:

Tips On Choosing SEO Friendly Domain Name

Tools To Pick Up Good Domain Name

Finally in the comments section do let us know what you thought about it. Is it Good to have newer version of PHP and MySQL in WordPress??

[How-to Guide] Add New WordPress Themes In WordPress 3.0

Already in the previous tutorial I had provided you the step by step guide on installing the wordpress on Hostgator and now in this tutorial I will guide on installing WordPress theme. You might be amazed by listening this but wordpress 3.0 has come out with different layout now it’s not a single click installation of theme.

In earlier versions of WordPress, you can easily add new themes by login into your wp-admin panel. After login to your admin panel go to Appearance> Add New Themes like this shown in screenshot:

And after clicking on this you will easily add new themes in your wp-admin panel and will change it when you want to change the layout of your blog.

But in WordPress 3.0 you won’t add new themes like this. Why? When you log-in into your wp-admin panel you will not able to see the Add New Themes Option directly as you can see in the older versions of WordPress. Now the question arises, how you add new themes in your WordPress and how you will change the layout of your blog? Need not worry; this article will come as a rescue for you to help out in adding new themes in WordPress 3.0. As already, I had covered some of the tutorials and how-to guides on WordPress 3.0. Some of them are being listed below to help you out WordPress 3.0:

Go to Appearance, click on Themes. After clicking on themes, on the top of page you will two navigation menus like this:

Now click on Install themes, you will see a page like as shown in screenshot:

Now you can easily add the new theme and change the layout of your blog.

This tutorial will help you out in adding new themes, even though if you feel any difficulty in adding new themes then let me through comments section or use our contact form.

In the meanwhile do let us know your thoughts on WordPress 3.0