patternsqlCritical
MySQL DB import/export command line in Windows
Viewed 0 times
linemysqlexportwindowscommandimport
Problem
How do I import and export a local instance of a MySQL database via command-line interface?
My operating system is Windows and WampServer server is installed.
My operating system is Windows and WampServer server is installed.
Solution
Use this for export:
this is my Sample Export in CMD and i'll save in drive D:\
mysqldump -u username -p databasename > filename.sqlthis is my Sample Export in CMD and i'll save in drive D:\
mysqldump -u root -pmypassword pos > d:\pos.sqlCode Snippets
mysqldump -u username -p databasename > filename.sqlmysqldump -u root -pmypassword pos > d:\pos.sqlContext
StackExchange Database Administrators Q#25599, answer score: 51
Revisions (0)
No revisions yet.