Ipb 2.2:Manually Delete Unnecessary Spider Logs

From IpbWiki

Manually Delete Unnecessary Spider Logs

Your database holds megabytes and megabytes of unnecessary spider logs that have no value nor use. Every time a search engine crwaler visits your site, the crawler is logged. Crawlers visit sites multiple times a day, and there are millions of search engines the crawl the Web every minute.

For faster page loading, faster database modifications, and database query completion, you can manually delete all the spider logs that are just taking up space in the database.

This table is usually the biggest in a popular forum's database. Biggest and most useless. Delete the logs now!

In this tutorial, you will learn how to permanently remove all spider logs from your database. You are required to have access to your database in order for this tutorial to work for you.

Control Panel Log into your hosting control panel software (cPanel is at port :2082)

MySQL Databases Click on MySQL Databases and then on phpMyAdmin at the bottom of the next page.

Select Database Click on the name of your forum's database

SQL Tab Click on the SQL tab at the top of the database table page.

Enter Command Copy and paste the following command into your SQL box:

Click GO Click on GO on the bottom right outside the SQL field.

Enjoy Faster Browsing If your ibf_spider_logs table was loaded and heavy, you and your members are going to experience faster browsing and faster posting/searching. Remember to do this every once in a while!

© 2007 by John of Platinum Zone. Find many more IPB tutorials at Platinum Zone