A stored procedure for assisting with database backups

You can use the following stored procedure to quickly clean up your MySQL database for when you want to do a backup. Just call it using the following SQL command: "call cleanforexport();"


CREATE PROCEDURE cleanforexport()
begin
delete from mt_log where log_category = 'straight_search';
delete from mt_log where log_message like 'news callback%';
delete from mt_session where session_id like 'blog::%';
delete from mt_comment where comment_junk_status < 0;
delete from mt_tbping where tbping_junk_status < 0;
delete from mt_asset where asset_label like 'Thumbnail%';
delete from mt_asset_meta where asset_meta_asset_id not in (select asset_id from mt_asset);
end

If you are using phpMyAdmin, the make sure that you set the delimiter field to use something other than ";" as the delimiter. // is a good example of an alternative.