mysqldump between 2 servers from a 3rd
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.
Subject
Written By
Posted
mysqldump between 2 servers from a 3rd
January 27, 2015 02:39PM
February 04, 2015 07:16AM
February 04, 2015 12:24PM
February 06, 2015 06:58AM
February 06, 2015 08:08AM
February 06, 2015 11:45AM
February 06, 2015 11:53AM
February 06, 2015 12:02PM
February 06, 2015 12:08PM
February 06, 2015 12:36PM
February 06, 2015 12:42PM
February 06, 2015 03:52PM
February 06, 2015 04:36PM
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.