#!SQL
SELECT MAX(log_id) AS num FROM log;

ALTER TABLE log DISABLE KEYS ;

ALTER TABLE log enable KEYS ;

ALTER TABLE file_tracker disable keys ;

ALTER TABLE file_tracker enable keys ;

SELECT MAX(log_id) AS num FROM log;
OPTIMIZE TABLE browser,country, file_tracker,file_type,ip_addr,log,op_sys,referer_domain, referer_page,referer_qs,robot,search_engine, search_keyword,search_keyword_log,search_string,session,url;

-- DetlevLengsfeld 2006-07-01 08:45:39

Linux/MySql/ErrorFixes (last modified 2008-11-04 07:00:04)