How to dump MySQL database on WAMP
In order to make a backup or a server transfer, you may need to dump a MySQL database into a sql file. If you try to do it through PHPMyAdmin, you may get a timeout error or an out of memory in PHP when using big databases. In WAMP server this is properly done through a program called mysqldump you will find on WAMP server binary folder. Nevertheless the best way to proceed is invoking the mysqldump application from command line of Windows, like this:
C:\wamp\bin\mysql\mysql5.5.8\bin\mysqldump -uroot -p dbname > c:\path\dbname.sql
A root password will be asked in the prompt. Probably this password is still void after WAMP install. In that case press Return key and your sql dump file will be ready soon. Mine took several minutes because I was dumping a 3 Gb database. With big databases be patient.