How to export a mysql database using Command Prompt?

Starx

Ok,

First check if your DOS recognizes mysql command. If not go to command and type in

set path=c:wampbinmysqlmysql5.1.36bin

(I just made a guess, since you are using WAMP)

Then use this command to export your database

mysqldump -u youruser -p userpassword yourdatabase > wantedsqlfile.sql

This exports the database to the path you are currently in, while executing this command

Here is some detail instruction regarding both import and export

http://www.thegeekstuff.com/2008/09/backup-and-restore-mysql-database-using-mysqldump/#more-184