Mysql Command Line in Windows - Help

[James Brown]

Hi I am migrating from a windows server to a linux and I want to dump my 750mb database on the Windows box before FTP'ing it to my new Linux server.

Using the mysql command line client to make the dump I am getting syntax errors. I suspect it is to do with my path to the backup destination I have tried a few things. The traditional windows backslash e:\backup.sql does not seem to work here.

If I want to dump the database, using the command line client, to the root of my Windows E drive; what would the command be? the example below doesn't work.

mysqldump --opt -Q -u dbuser -p dbname > e:backup.sql;

Any help here would be much appreciated - thanks