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
Is Heidi scriptable enuf to connect and dump a DB w/o me ??
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.
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.