Re: mysqldump command under windows environment

[gilles bronner]

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.