MySQL DB import/export command line in Windows

exportimportMySQLmysqldump

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…

Best Answer

Use this for export:

mysqldump -u username -p databasename > filename.sql

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

mysqldump -u root -pmypassword pos > d:\pos.sql