[linux-help] Re: Mysql permissions

[bruce bales <bbales@xxxxxxx>]

Tom Hull wrote:

>Another way to do this would be to redirect the output of mysql to whatever
>file you want to capture the data. You might, for instance:
>
>   $ echo 'select * from foo;' | mysql >foo.select
>  
>
This worked.  After I figured out how to put in name and PW.

[bruce@bertha temp]$  echo 'select * from class50.email;' | mysql -u 
bruce -p >email2.dat
Enter password:
[bruce@bertha temp]$

>Another way to dump a table or a whole database would be to use the
>mysqldump program. This produces a file which can be redirected into
>mysql to restore the table/database.
>
[bruce@bertha temp]$ mysqldump -u bruce -p class50 email > /tmp/email.dat
Enter password:
[bruce@bertha temp]$

This also worked, but the output would require considerable editting. 
 There was a bunch of information at the top and each line was prefixed 
with "INSERT INTO email VALUES ."

Now I can do what I was trying to do, but still interested in knowing 
why I can't select to a file.  I am convinced that 'mysql bruce' doesn't 
have write permission to any of the directories I have tried to write 
to.  An interesting exercise.

Thanks to all of you for the help,
bruce

-- This is the linux-help@xxxxxxxxx list.  To unsubscribe,
visit http://www.complete.org/cgi-bin/listargate-aclug.cgi