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'
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.
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
