hi,
i am trying to do a daily backup of some mysql databases, so i made a text file, mysqulbackup, that looks like this:
#!/bin/sh
mysqldump -uroot -ppwd --opt db1 > /sqldata/db1.sql
with the appropriate names substituted for root, pwd, db1.
then i made another text file, cronstuff.txt, that looks like this:
0 * * * * /mysqldata/mysqlbackup [return]
[return]
(i am trying to test it by doing the backup every minute)
So then i telnet into my account and run crontab /cronstuff.txt, which i think sets up my crontab correctly ... when i type crontab -l, i see a file with the correct command in there.
but i wait, and no db1.sql is created in sqldata.
can anyone tell me what i might be doing wrong?
-ben
i am trying to do a daily backup of some mysql databases, so i made a text file, mysqulbackup, that looks like this:
#!/bin/sh
mysqldump -uroot -ppwd --opt db1 > /sqldata/db1.sql
with the appropriate names substituted for root, pwd, db1.
then i made another text file, cronstuff.txt, that looks like this:
0 * * * * /mysqldata/mysqlbackup [return]
[return]
(i am trying to test it by doing the backup every minute)
So then i telnet into my account and run crontab /cronstuff.txt, which i think sets up my crontab correctly ... when i type crontab -l, i see a file with the correct command in there.
but i wait, and no db1.sql is created in sqldata.
can anyone tell me what i might be doing wrong?
-ben