Hi Bernd If you are just interested in dumping the data in CSV (or whatever) format you can do it like so:
SELECT * INTO OUTFILE 'arb_file.csv' FIELDS TERMINATED BY ',' LINE TERMINATED BY '\n' FROM arb_table WHERE arb_conditions There are quite a few options available, so I suggest you check the MySQL manual, to see them all. HTH. Rory McKinley Nebula Solutions +27 82 857 2391 [EMAIL PROTECTED] "There are 10 kinds of people in this world, those who understand binary and those who don't" (Unknown) ----- Original Message ----- From: "Bernd Tannenbaum" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, October 21, 2003 12:42 PM 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. Hope for a lil help, Bernd -- One OS to rule them all, one OS to find them. One OS to bring them all, and in the darkness bind them In the land of Redmond, where the shadows lie. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
