[perleo]

I want to run a script file from the mysql prompt and put it in cron

But i dunno if my script file is correct., can someone tell me if it is

USE syslog;
################
#syslog records#
################
INSERT INTO syslog_archiveTB SELECT * FROM syslog_recentTB;

TRUNCATE TABLE syslog_recentTB;

INSERT INTO syslog_recentTB SELECT * FROM syslogTB;

TRUNCATE TABLE syslogTB;

OPTIMIZE TABLE syslogTB;
OPTIKIZE TABLE syslog_recentTB;
OPTIMIZE TABLE syslog_archiveTB;

#################
#network records#
#################
INSERT INTO network_archiveTB SELECT * FROM network_recentTB;

TRUNCATE TABLE network_recentTB;

INSERT INTO network_recentTB SELECT * FROM networkTB;

TRUNCATE TABLE networkTB;

OPTIMIZE TABLE networkTB;
OPTIMIZE TABLE network_recentTB;
OPTIMIZE TABLE network_archiveTB;