MySQL Forums
Forum List  »  Newbie

mysqldump between 2 servers from a 3rd
Posted by: Dennis Putnam
Date: January 27, 2015 02:39PM

I am trying to create a recovery script that will be run on a monitoring server. The script uses mysqldump to copy databases from server A to server B:

mysqldump -u user --password=passwd --all-databases -h servera.domain.com | mysql -u user --password=passwd -h serverb.domain.com

Shouldn't this work? When I try it from the monitor server I get errors about general_log does not exist. Which it doesn't, nor should it as far as I am concerned. I don't know what that is nor did I create it. I've researched the error but none of the solutions seem applicable in this case. I should add that if I leave off either -h option and use servera or serverb to run the command, it works.

Options: ReplyQuote


Subject
Written By
Posted
mysqldump between 2 servers from a 3rd
January 27, 2015 02:39PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.