CODEWITHSUNDEEP
mysqlmysql-workbench
JonBrave
JonBrave

Reputation: 4280

What parameters does MySQL Workbench pass to mysqldump?

I need to write a script to automate MySQL backup of a database. So to determine what I will need, I go into MySQL Workbench, select the Schema, select Data Export, set a couple of controls (at the moment: Export to Self-Contained File & Include Create Schema) and Start Export.

Export Progress shows me command-line:

Running: mysqldump --defaults-file="/tmp/tmpTbhnzh/extraparams.cnf"  --user=*** --host=*** --protocol=tcp --port=3306 --default-character-set=utf8 --skip-triggers "<schema-name>"

I need to know what is in that temporary "defaults file" if I'm to replicate whatever it is that MySQL Workbench passes to mysqldump. But the backup completes so quickly and deletes the file that I can't even copy it, of course!

Is there a way I can know just what arguments Workbench is passing to mysqldump so I can know I'm generating a good, robust script? (To be clear: I'm sure I can look up the mysqldump documentation to find arguments corresponding to whatever UI items I fill in explicitly, but I'm wondering what other "goodies" MySQL Workbench might know about and put in the parameters file.)

Upvotes: 1

Views: 2015

Answers (1)

Pete
Pete

Reputation: 1309

A bit of digging about in the python scripts (there's one called wb_admin_export.py) and the answer is....not very exciting... it's your password.

It also includes ignore-tables if there are any to ignore.

Upvotes: 4

Related Questions