Script for export
I am not an SQL programmer, but I do program in other languages. What I am looking for is a script, of sorts, to allow me to connect to a database (I already have a connection setup in HeidiSQL), select a file, export that file to a designated target (c:\MAKESQL), with file name.txt. What would that script look like if being execute from a Windows command line, if even possible. I have three files that I want to export.
HeidiSQL is not scriptable in such a way. You can however, have a look at the readme file (Help > readme). The section "Command line switches" contains a handful of usable options.
If you want to fully automate an export you should definitely use mysqldump.exe, from the MySQL server programs.
If you want to fully automate an export you should definitely use mysqldump.exe, from the MySQL server programs.
Please login to leave a reply, or register at first.