clear a mysql table

From: Date: Sat, 25 Oct 2008 15:02:38 +0000
Subject: clear a mysql table
Groups: php.general 
Request: Send a blank email to php-general+get-282422@lists.php.net to get a copy of this message
I need to clear a table (cache) from a database based on the database size. Our web site uses cached pages. Our webhost only allow us 100 MB storage. Usually the database is just 10 MB, but when a search engine crawls our calendar, then the storage is quickly 108 MB. The system reports then mathematically correct: Space left on database -8MB !!! I plan therefore a web page, which is triggered by cron every hour and will just clear the table. Can I use just: mysql_query("DELETE FROM cash") or die(mysql_error()); or do I need to loop through all records? or is there a better solution? How can I get the database size? bye R.

« previous php.general (#282422) next »