On Tue, May 21, 2013 at 1:51 PM, Saravanan Devasagayam <[email protected]> wrote: > 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
Crontabs are hard to get right. So use logger(1) to test whether cron is doing its job. Then use these commands. -Girish -- Gayatri Hitech http://gayatri-hitech.com _______________________________________________ ILUGC Mailing List: http://www.ae.iitm.ac.in/mailman/listinfo/ilugc
