Re: mysql data into CSV file. / (Errcode: 13)
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...
Re: mysql data into CSV file. / (Errcode: 13)
Hi Shain, Shain Lee wrote: 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 ? Error 13 is Permission Denied. The MySQL daemon cannot write to your home directory. Try using /tmp instead or some dir mysqld can write to. regards Nils -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql data into CSV file. / (Errcode: 13)
Thank you , that is working with /tmp/ directory. actually what is the issue behind writing that files into user defined folder , like /home/test/ ? have you find any solution for that ? Thank you, Shaine. Nils Meyer [EMAIL PROTECTED] wrote: Hi Shain, Shain Lee wrote: 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 ? Error 13 is Permission Denied. The MySQL daemon cannot write to your home directory. Try using /tmp instead or some dir mysqld can write to. regards Nils -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] - Yahoo! Messenger - with free PC-PC calling and photo sharing.
Re: mysql data into CSV file. / (Errcode: 13)
There's no issue. That's how it's supposed to work. Read about permissions for directories. It's pretty straight forward with Linux. I learned on the RedHat manuals. Shain Lee [EMAIL PROTECTED] 01/11/2007 09:28 AM To: Nils Meyer [EMAIL PROTECTED] cc: MySql mysql@lists.mysql.com bcc: Subject:Re: mysql data into CSV file. / (Errcode: 13) Thank you , that is working with /tmp/ directory. actually what is the issue behind writing that files into user defined folder , like /home/test/ ? have you find any solution for that ? Thank you, Shaine. Nils Meyer [EMAIL PROTECTED] wrote: Hi Shain, Shain Lee wrote: 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 ? Error 13 is Permission Denied. The MySQL daemon cannot write to your home directory. Try using /tmp instead or some dir mysqld can write to. regards Nils -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] - Yahoo! Messenger - with free PC-PC calling and photo sharing. This message (including any attachments) contains information that may be confidential to Koninklijke Ahold N.V. or its group entities. If you are the intended recipient, you are authorized to use the information only as expressly authorized by Ahold and must strictly adhere to applicable security procedures, including without limitation the following: - You must protect files using the password and level of protection in which the file was provided to you; and - You may transmit files only as necessary for the task you are assigned using secure systems and appropriate encryption means. If you have received the message in error, please advise the sender by reply e-mail, and destroy all copies of the original message (including any attachments). Please direct any questions to the sender of this message.
mysql data into CSV file.
Hi For example , suppose i have a database - Music, and a table in it is mp3. under mp3 there is more fields , like, id, artist, name , mp3_file...etc. 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 ? Thank you, Shaine. Send instant messages to your online friends http://uk.messenger.yahoo.com
Fwd: mysql data into CSV file.
-- Forwarded message -- From: Jake Peavy [EMAIL PROTECTED] Date: Jan 4, 2007 10:48 PM Subject: Re: mysql data into CSV file. To: Shain Lee [EMAIL PROTECTED] 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 (forgot the bloody list...) -- -jp Switzerland isn't really neutral. They just haven't figured out what side Chuck Norris is on yet.
Re: mysql data into CSV file.
Hi, Try using, SELECT * INTO OUTFILE 'tmp/music_mp3.txt' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY ' ' LINES TERMINATED BY ' \n ' FROM mp3; Thanks ViSolve DB Team - Original Message - From: Shain Lee [EMAIL PROTECTED] To: MySql mysql@lists.mysql.com Sent: Friday, January 05, 2007 11:05 AM Subject: mysql data into CSV file. Hi For example , suppose i have a database - Music, and a table in it is mp3. under mp3 there is more fields , like, id, artist, name , mp3_file...etc. 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 ? Thank you, Shaine. Send instant messages to your online friends http://uk.messenger.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]