Date: 02/06/06 (MySQL Communtiy)    Keywords: php, mysql, sql, web

Howdy,

Suppose I want a way to easily backup a SQL table. (I use MySQL but that shouldn't matter.) I would like to be able to have a link on my website that, when I click on it, lets me download a TXT file with all of the data in tab separated values, so I can easily load it into excel.

Somebody suggested using select into outfile 'filename', but I must admit that the mySQL manual baffles me and I have a hard time getting any help from it. So, how would I use it in this regard?

Thanks much!

(crossposted to php community)

Source: http://community.livejournal.com/mysql/84826.html