Is Heidi scriptable enuf to connect and dump a DB w/o me ??

[expired user #4803]'s profile image [expired user #4803] posted 9 years ago in General Permalink
Subject says it all. Would like to fire a script on a cron job to backup certain DB's nightly.

Thanks in advance for any help.

Gil Blais
jfalch's profile image jfalch posted 9 years ago Permalink
use mysqldump.
[expired user #4803]'s profile image [expired user #4803] posted 9 years ago Permalink
I develop on a Windoze machine and my hosting service is Unix. They say that I can't get to mysqldump.exe ?? The puzzle is that I can get to mysql.exe though. I don't quite believe them, but...
jfalch's profile image jfalch posted 9 years ago Permalink
mysqldump.exe is part of the mysql server package - download here and look into the bin\ directory, you can throw away the other stuff.

if you use heidisql to access your hosting services' database and your session manager setting "connection type" is "MySQL (TCP/IP)", you can directly use mysqldump (with the appropriate parameters -h -u -p and -B).
if the connection type is "MySQL (SSH tunnel)", you have to manually call plink.exe to build the tunnel before starting mysqldump.

Please login to leave a reply, or register at first.