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
