Hi,
Try taking the space out from "-p passwd"
Regards
Quentin
-----Original Message-----
From: Don [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, 31 January 2001 09:45
To: msql list
Subject: Nightly Backup of my database
Hi list,
I'm trying to backup up database in /etc/cron.daily. I've played with
mysql dump with the following syntax:
mysqldump --opt -p my_dbf.db > my_dbf.backup
mysqldump --opt -p "my_password" my_dbf.db > my_dbf.backup
mysqldump --opt -p my_dbf.db > my_dbf.backup < pswd
(pswd contains the password)
In each case, I still get prompted for the password. How can I automate
this so that is accepts the password that I include. I guess what I am
looking for is the proper syntax or a neat trick.
Thanks,
Don
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail
<[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
The information contained in this email is privileged and confidential
and intended for the addressee only. If you are not the intended
recipient, you are asked to respect that confidentiality and not
disclose, copy or make use of its contents. If received in error
you are asked to destroy this email and contact the sender immediately.
Your assistance is appreciated.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
