Possibly you need the SELECT ... INTO OUTFILE command (http://www.mysql.com/doc/en/SELECT.html) which has export options (explained on http://www.mysql.com/doc/en/LOAD_DATA.html, because the command is the complement to LOAD DATA INFILE).
|---------+------------------------------> | | Bernd Tannenbaum | | | <[EMAIL PROTECTED]| | | .itenos.de> | | | | | | 21/10/2003 11:42 | | | | |---------+------------------------------> >------------------------------------------------------------------------------------------------------------------------------| | | | To: [EMAIL PROTECTED] | | cc: | | Subject: export to textfile | >------------------------------------------------------------------------------------------------------------------------------| Hello all, Have only a small problem with my mysql and hope that i can get a lil hint from ya how to go on. Currently i`m importing Log-files in the mysql-database with a cronjob (bashscript in Linux). After some processing in the db itself i try now to export the results into a textfile. But i must be blind reading the mysql documentation cause i cannot find a mysqlexport. Hmm, Mysqldump can be used to backup the db, thats not what i need. Then i found "mysql -e" and it rly writes the chosen fields to a textfile but i dont know how to get options to that (like fileds-terminated-by=';' or stuff like that). So did i miss something? Is there a better way to go than "mysql -e"? If not, where can i find a good explanation of the possible options of this, every hint welcome. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]