MySql - server version: 4.1.7 OS - RedHat Linux AS 4 mysql> use Music;
mysql> SELECT * INTO OUTFILE '/home/shaine/Music.csv' FROM Music_Details; ERROR 1 (HY000): Can't create/write to file '/home/shaine/Music_Details.csv' (Errcode: 13) I faced a problem as mentioned above. really got stucked. how can i solve that problem ? is it a bug ? please help . Thank you, Shaine. Jake Peavy <[EMAIL PROTECTED]> wrote: On 1/4/07, Shain Lee <[EMAIL PROTECTED]> wrote: I wanted to get that info which has stored in relavent fields into a CSV fle . Can somebody help me to do that please ? Can i do it mysql commands it self ? You could do with with SELECT .... INTO OUTFILE as outlined at http://dev.mysql.com/doc/refman/5.0/en/select.html#id3041795 Or you could make use of the new CSV storage engine http://dev.mysql.com/doc/refman/5.0/en/csv-storage-engine.html -- -jp Switzerland isn't really neutral. They just haven't figured out what side Chuck Norris is on yet. --------------------------------- Copy addresses and emails from any email account to Yahoo! Mail - quick, easy and free. Do it now...
