I am trying to export a database which is protected by a SSH key and a private network, meaning I can’t login to the host itself to run mysqldump locally and somehow the ssh -i "key" doesn’t work for me to run it remotely too.
The only option I see is to connect via Workbench and dumpt it from there, but when I try to dump, I get a PROCESS privelage error. As I researched it can be circumvented by using a –no-tablespaces flag on mysqldump.exe, so I am looking for a way to add it so that Workbench would call mysqldump.exe with that flag.
I found that MySQL can read configuration files my.cnf and my.ini, but I don’t know what to write in them for a –no-tablespaces alternative.
2
Answers
The "MySQL Programs / Using MySQL Programs / Specifying Program Options / Using Option Files" page includes:
In the syntax section, you can see a
[mysqldump]
header.So check if adding the header+option to your
my.cnf
ormy.ini
would be enough:Abandon Workbench (since it seems to be in the way).
From a commandline prompt, use
mysqldump
directly.Try ssl from the other machine (with the suitable flag to reverse the direction). If neither direction works, elaborate on what complaint it provides.
What version of MySQL?