Eric Dahlvang
Eric Dahlvang

Reputation: 8292

Where does mysqldbexport put files on windows?

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

Answers (2)

Mahbubul Haq Sarker
Mahbubul Haq Sarker

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

Eric Dahlvang
Eric Dahlvang

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

Related Questions