distal-attribute
distal-attribute
distal-attribute
distal-attribute

Script for export

User, date Message
Written by JJCinMAINE
2 years ago
Category: Import/Export
1 posts since Thu, 01 Nov 12
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.
Written by ansgar
2 years ago
5023 posts since Fri, 07 Apr 06
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.