MySQL DB import/export command line in Windows How to export / import a database in MySQL through the command line?

MySQL system configuration, WampServer server installed.

OS: Windows

The advice for my local host, not an live hosting...
Use this for export:

mysqldump -u username -p databasename &gt; filename.sql


this is my Sample Export in CMD and i'll save in drive D:\ 

mysqldump -u root -pmypassword pos &gt; d:\pos.sql