  | |  | script to back up mysql dababase | script to back up mysql dababase 2005-05-16 - By Leuy Eeelyu
Back Hi.. i want to create a script to backup mysql database everyday. And I tested using the following command, secret is the password for root for mysql server
mysqldump -h localhost -u us2049 -p secret db3 > backup.db3
but after I typed the command, it still prompts me for the password
linux# mysqldump -h localhost -u us2049 -p secret db3 > backup.db3 Enter password:
And I got to type in the password "secret", why it never capture the password in the first command? If I really need to fill in Enter password in the second command? how to make it in a scripts to type in password after "Enter password:"
__ ____ ____ ____ ____ ____ ______ Do you Yahoo!? Yahoo! Small Business - Try our new resources site! http://smallbusiness.yahoo.com/resources/
-- Taroon-list mailing list Taroon-list@(protected) http://www.redhat.com/mailman/listinfo/taroon-list
Earn $52 per hosting referral at Lunarpages.
|
|
 |