Re: backup mysql using crontab

2001-04-02 Thread Lars Heidieker
Pete Harlan wrote: > > Probably because you need to redirect your output into the file AFTER all > > the options. Rewrite your command like this: > > In which shell? In SunOS /bin/sh, or in bash, the shell strips out > the redirection, and the program sees what's left. It doesn't matter > where

Re: backup mysql using crontab

2001-04-02 Thread Pete Harlan
> Probably because you need to redirect your output into the file AFTER all > the options. Rewrite your command like this: In which shell? In SunOS /bin/sh, or in bash, the shell strips out the redirection, and the program sees what's left. It doesn't matter where the redirection is; it can eve

Re: backup mysql using crontab

2001-04-02 Thread John Barton
mysqldump --flush-logs -u root -pmarkloky --add-drop-table shuncheong > /backup/shuncheong.sql You have to put username and password as an argument to mysqldump, before your redirection John Barton Unix Systems Administrator Primary Networks, Inc. [EMAIL PROTECTED] On Tue, 3 Apr 2001, Mark Lo (

Re: backup mysql using crontab

2001-04-02 Thread Steve Werby
"Mark Lo (3)" <[EMAIL PROTECTED]> wrote: >I would like to know how to backup mysql using crontab or cron jog. > > I have add a line in my crontab file : > mysqldump --flush-logs --add-drop-table shuncheong > > /backup/shuncheong.sql -u root -pmarkloky; > > but I got nothing in shuncheong.sql

Re: backup mysql using crontab

2001-04-02 Thread Lindsay Adams
Probably because you need to redirect your output into the file AFTER all the options. Rewrite your command like this: mysqldump --flush-logs --add-drop-table -u root -p markloky shuncheong > /backup/shuncheong.sql See if that works. The way you had it written, you weren't passing the -u and

Re: backup mysql using crontab

2001-04-02 Thread Lars Heidieker
Hi, the cammod looks wiered to me try something like mysqldump --flush-logs --add-drop-table -u root -pmarkloky shuncheong > /backup/shuncheong.sql lars "Mark Lo (3)" wrote: > Hi, > >I would like to know how to backup mysql using crontab or cron jog. > > I have add a line in my crontab fi