dumping database to another server..

knelson

hello-

I'm attempting to dump an entire MySQL database to an identical server for backup and devlelopment purposes using the following:

mysqldump db_name | mysql -h otherserver.com db_name

On the target server:

-there is a database created with the same name as the one on the source server
-there is an entry in the host table with full privileges for "%"
-there is an entry in the user table with the source IP as the host, and full privileges

I still get "host not allowed to connect" messages, however, when I try to do the mysql dump?

Am I missing any entries in the tables on the target server?

thanks. knelson.

ultraslacker

Did you reload the grant tables on the target?

knelson

i have flushed privs and restarted the daemon a couple of times.

goa103

Are you allowed to use the mysqldump program? Some hosts doesn't allow it

theeper

I had a similar problem once before. It turned out to be a DNS issue. The new system could not properly reverse map the IP I was connecting from, and therefore would not allow the connection. Since I didn't have access to the DNS machines, I disabled Name Resolving in the my.cnf file. I added a line like this "skip-name-resolve" and it works perfectly.

I do not know if this is related to your issue, but you may look into it. I am also not sure about possible problems with skipping name resolution this way. Anyone know anything about this ?