I'm running Ubuntu 12.04 (32-bit) and have the following script in crontab SHELL=/bin/sh PATH=/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin
40 13 * * * root mysqldump -u root -pxxxxxxxx Database | gzip > /back-up/DB_name_`date '+%d-%m-%Y'`.sql.gz 00 1 * * 0 root mysql -u root -pxxxxxxxx -e 'ANALYZE TABLE tbl_name;' DB_name 10 1 * * 0 root mysql -u root -pxxxxxxxx -e 'OPTIMIZE TABLE tbl_name;' DB_name 20 1 * * 0 root mysql -u root -pxxxxxxxx -e 'CHECK TABLE tbl_name;' DB_name What am I doing wrong? it's not work !! _______________________________________________ ILUGC Mailing List: http://www.ae.iitm.ac.in/mailman/listinfo/ilugc
