Hi all.
I am relatively new to mysql and brand new on this list :)
Please help me with this:
I have to backup a database and the simplest way to accomplish this is
SELECT * FROM mytable INTO OUTFILE '/nobody_directory/mytabledump.txt';
The problem is that when I do this, the server response is:
Error 1045: Access denied for user:'[EMAIL PROTECTED]' (Using password:
YES).
The grant for the user maxx is:
Grant usage on *.* to maxx@'%' IDENTIFIED BY scrambledpassword
Grant all privileges on main.* to maxx@'%'.
The server is 3.23.39, protocol version 10, connection UNIX Socket running
on RH Linux 7.0.
The regular SELECT, UPDATE etc. are running correctly, only the dump does
not.
Can you help me with this, or where I should dig into documentation? Thanks
a lot!
Alex Sofronie
[EMAIL PROTECTED]
---------------------------------------------------------------------
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
