Reputation: 8292
About an hour ago I ran the following:
mysqldbexport.exe --server=root:mypword@localhost --export=DATA --bulk-insert mydbname
Since that time I've been feeling like an idiot while scouring the internet, and the hard drive...trying to figure out where the results are.
Upvotes: 1
Views: 4474
Reputation: 11
To export database by using Mysql workbench version: 6.2.3:
mysqldbexport --server=username:password@localhost --export=DATA --bulk-insert testSchema --output-file=D:/tmp/dump.sql
Upvotes: 1
Reputation: 8292
Well, I never did find the documentation...but, did run across a statement that says:
"If table definitions are included in the export, they are written to stdout as usual."
So, I modified my above command to print to a file...which worked.
mysqldbexport.exe --server=root:mypword@localhost --export=DATA --bulk-insert mydbname >>c:\temp\mysqlexport.txt
Upvotes: 3