@diafol Really you don't think I tried that. I pretty much looked every where.
The only thing that seemed to work to the way I wanted is to use OUTFILE but I want the file to goto my website directory but I think it's going to the mysql data and I don't have access to it so I can't get the file.
Well, if you were more forthcoming with your question, perhaps we could direct you better.e.g. what have you tried / what failed?
Do you wish to do this via PHP, Linux command line, Windows CL, myPHPAdmin? Need more info.