[Ilugc] pls help to me....
- From: knura9@xxxxxxxxx (Arun Khan)
- Date: Tue, 21 May 2013 15:53:17 +0530
On Tue, May 21, 2013 at 1:51 PM, Saravanan Devasagayam
<saravanansagayam at gmail.com> 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 !!
What you are doing wrong:
1. You posted a similar query earlier and did not reveal much in
that discussion.
ref: <
http://www.ae.iitm.ac.in/pipermail/ilugc/2013-May/076486.html>
2. In the above discussion you did not read the replies to your
questions very carefully [a]
3. People asked you to post specifics in that discussion but you did not.
[a] Read my response posted earlier
<
http://www.ae.iitm.ac.in/pipermail/ilugc/2013-May/076497.html>
Notice I mention the '%' character in crontab entries. You also have
'%' char entries in your crontab they need to be escaped like so \%.
(man 5 crontab)
Had you shared the crontab entries in your first discussion and also
read the replies more carefully, your problem would have been solved
much sooner.
--
Arun Khan
Sent from my non-iphone/non-android device
(???? ????/???? ???)
Other related posts: