thanks badhu......... i will try
On Wed, May 22, 2013 at 9:25 PM, padhu <[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 !! > > > > > > ------------------------------ > > Best way of crontab edit is > > $ sudo crontab -e > > please verify your default editor before run this command. > > Your entry will be made in crontab, if it is right. > > If you are going to add script, then test it before adding to crontab. > > _______________________________________________ > ILUGC Mailing List: > http://www.ae.iitm.ac.in/mailman/listinfo/ilugc > _______________________________________________ ILUGC Mailing List: http://www.ae.iitm.ac.in/mailman/listinfo/ilugc
