MySQL results to text file

csousley

Is it possible to get MySQL to spit the results of a query to a text file? A selective backup I guess you could say.

Thanks

Steveo31

Sure. Have the mysql_query be written using fopen, fwrite, and fclose.

http://www.php.net/fopen
http://www.php.net/fwrite
http://www.php.net/close

csousley

OK, I should have explained better. What I was looking for was something I could run from a terminal with cron or something. Here is what I ended up using. Looks like it works right.

[cy@tuxbox cy]$ echo "select id, user from TABLE" | /usr/local/mysql/bin/mysql -uUSERNAME -pPASSWORD DB_NAME > /tmp/file.txt;

Thanks for the reply

csn

SELECT has "INTO OUTFILE 'file_name' export_options":

http://www.mysql.com/doc/en/SELECT.html

csousley

Well I'm not sure how I missed that... but it's exactly what I was looking for. Cleaner and easier. Thanks

By the way, clever signature, I like it.

csn

You can also do:

mysql -u user -ppassword -e 'select * from table' database > data.txt