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
> 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
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 (
"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
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
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