Export and Import MYSQL database in Window

Share:
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  

1 comment:

  1. This comment has been removed by a blog administrator.

    ReplyDelete

Ads