Script for export

User, date	Message
Written by JJCinMAINE 7 months 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 7 months ago 3974 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. Username: Password: Remember me