Script for export

[expired user #6665]'s profile image [expired user #6665] posted 11 years ago in Import/Export Permalink
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.
ansgar's profile image ansgar posted 11 years ago Permalink
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.

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