Re: mysqldump command under windows environment
Posted by: gilles bronner
Date: March 20, 2007 05:19AM

You have to give a user and a password when using mysqldump using the command line or an ini file.

With the command line, you can use something like :

"C:\Program Files\MySQL\MySQL Server 5.0\bin"\mysqldump -uBackup -pBackup %db% >c:\backup\%db%.sql

where %db% is your dbname. In this example, i use a user named Backup with a password Backup. This user need at least 'select' and 'lock tables' privilege on the db.

Hope it help.

Options: ReplyQuote

Written By
Re: mysqldump command under windows environment
March 20, 2007 05:19AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.