Skip navigation links

MySQL Forums :: Database Administration & Monitoring :: mysqldump command under windows environment


Advanced Search

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


Subject Written By Posted
mysqldump command under windows environment Sudhakara TP 03/20/2007 03:02AM
Re: mysqldump command under windows environment Felix Geerinckx 03/20/2007 04:34AM
Re: mysqldump command under windows environment gilles bronner 03/20/2007 05:19AM
Re: mysqldump command under windows environment Arun B 04/17/2007 08:26AM
Re: mysqldump command under windows environment Sreekanth P 08/27/2008 04:23AM


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.