Yes, the mysql process is writing the file so mysql must have permissions to write there. Try writing /tmp/myfile.txt or create a directory with write permissions for the group or user that mysql is running as. Best of Luck Ken ----- Original Message ----- From: "George Eric R Contr AFSPC/CVYZ" <[EMAIL PROTECTED]> To: "mysql" <[EMAIL PROTECTED]> Sent: Tuesday, October 02, 2001 2:55 PM Subject: RE: How to Dump only Data
> I just tried this, but I get the result: > > mysql> SELECT * FROM ga_perf INTO OUTFILE "/home/georgee/ga_perf.out"; > ERROR 1: Can't create/write to file '/home/georgee/ga_perf.out' (Errcode: > 13) > > my username (georgee) is fully priveledged, and /home/georgee is my home > directory, so I certainly have permission there. There is no existing file > with the name I provided. > > I double checked the user table of the mysql database: > > mysql> select host, file_priv from user where user='georgee'; > host file_priv > % Y > localhost Y > > I am running the mysql client on the same system that the server is on, so > the restriction on running SELECT INTO OUTFILE from a remote host shouldn't > be an issue. > > Any ideas? I'm pretty green on this whole SQL business, so it's probably > something obvious! > Thanks > Eric > > -----Original Message----- > From: Ken Menzel [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, October 02, 2001 11:08 AM > To: fi-claudemir; mysql > Subject: Re: How to Dump only Data > > > Hi Claudemir, > Perhaps you are really looking for SELECT INTO OUTFILE syntax? > http://www.mysql.com/doc/S/E/SELECT.html > Ken > ----- Original Message ----- > From: "fi-claudemir" <[EMAIL PROTECTED]> > To: "mysql" <[EMAIL PROTECTED]> > Sent: Tuesday, October 02, 2001 12:55 PM > Subject: How to Dump only Data > > > > Hi > > > > How to Dump only the data from a Table. > > I took a look at the mysqldump options, but I didn't find something > that > > works fine ! > > > > Regards > > Claudemir F. Martins > > > > > > -------------------------------------------------------------------- > - > > Before posting, please check: > > http://www.mysql.com/manual.php (the manual) > > http://lists.mysql.com/ (the list archive) > > > > To request this thread, e-mail <[EMAIL PROTECTED]> > > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > > Trouble unsubscribing? Try: > http://lists.mysql.com/php/unsubscribe.php > > > > > > > -------------------------------------------------------------------- - > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > -------------------------------------------------------------------- - > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
