Dumping MySQL data directly to client desktop

[bostonmacosx]

I've seen a lot of threads in here about dumping MySQL data into a text file on the server. I was wondering if it is possible to dump the data so that a users browser will download the data to a text file withough having to actually write a file on the server.

So basically I store the data from the database in a variable and then output this directly to the client end.

Thanks
Robert

[Drakla]

header("Content-Type: text/plain");
header('Content-Disposition: attachment; filename=hellodarlin.txt');

passthru("/path/to/mysql/bin/mysqldump -u username -h host -ppassword -e yourdatabasename");