There's a problem with VBB as it will crash with a session table overflow. Basically I need to run a script to dump the table every few days. Anyone can advise on a way to empty table "session". If I get the sql query syntax I can automate it.
TRUNCATE TABLE "table_name" this is the way how it works with an oracle database, it deletes all data from a table so ya can make the table empty from its data only
Yup, works for (My)SQL same way. Is that what you need, or only part of the table's content (like "everything but todays sessions")?
Use a truncate statement and set it up as a Cron job, like this: http://community.contractwebdevelopment.com/cron-job-mysql Or you could manually run the truncate statement such as TRUNCATE TABLE <tablename>. Truncate will just clear the rows, the column definitions will remain. Maybe you could also do it with a trigger?
