At 16:03 -0600 10/16/04, C.F. Scheidecker Antunes wrote:
Hello all,
I have a remote server that has a harddrive almost full. Therefore I
need to dump a huge table to my other host.
OK, I've set the permissions so that I can log in to the server as
root from my host. I've try to connect to it and it works.
I have to do the dump to the host because the remote server hard
drive has almost no more space.
I've set the privileges so that I can log on from root from any host
within my network like this:
GRANT ALL ON db_mydb.* TO 'root'@'192.168.0.%' IDENTIFIED by 'algo';
flush privileges;
Then, I try to run the following command to dump the database:
mysqldump -h 192.168.0.2 -u root -palgo --tab="/tmp"
--fields-terminated-by=";" db_parts tbl_config > tbl_config.csv
What I've got in return is:
mysqldump: Got error: 1045: Access denied for user:
'[EMAIL PROTECTED]' (Using password: YES) when executing 'SELECT INTO
OUTFILE'
Apparently the account you're using doesn't have the FILE privilege,
which is a global privilege. (Remember, GRANT ALL ON db_mydb.* grants
database-level privileges, not global privileges.)
If I run this command in the server it works just fine (when I had
space), the problem is that I cannot run it on the other host as I
cannot run it in the server due to its lack of
space to generate the outputfile.
Any ideas to where I am doing it wrong?
Thanks in advance,
C.F.
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
