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  

No comments

'; (function() { var dsq = document.createElement('script'); dsq.type = 'text/javascript'; dsq.async = true; dsq.src = '//' + disqus_shortname + '.disqus.com/embed.js'; (document.getElementsByTagName('head')[0] || document.getElementsByTagName('body')[0]).appendChild(dsq); })();

Ads