Export and Import MYSQL database in Window

Run cmd command
Type c: or d: on command prompt. This will be based on your WAMP server installations.
Assuming you have installed Wamp on C: drive.

 C:>cd wamp  
 C:\wamp>cd bin  
 C:\wamp\bin>cd mysql  
 C:\wamp\bin\mysql>cd mysql15.5.8  
 C:\wamp\bin\mysql\mysql15.5.8>cd bin  
 C:\wamp\bin\mysql\mysql15.5.8\bin>mysql.exe -u root  


To backup:

 mysqldump -u user -p database > backup.sql  

To import:

 mysql -u user -p database < backup.sql  

Nikunj K

Phasellus facilisis convallis metus, ut imperdiet augue auctor nec. Duis at velit id augue lobortis porta. Sed varius, enim accumsan aliquam tincidunt, tortor urna vulputate quam, eget finibus urna est in augue.