remote mysql server import of Databases?

hostmedic

Well-Known Member
Apr 30, 2003
543
0
166
Washington Court House, Ohio, United States
cPanel Access Level
DataCenter Provider
When setting this up - will it automatically copy all of the databases or do we need to do this one by one?

?

We are looking to take all mysql databases onto a monster db server cluster (3 db servers using htproxy.

Anyhow - my concern is if we will need to copy each database manually
between the 11 servers we have at least 500 databases

I guess we could script them - but ouch ...
 

jayh38

Well-Known Member
Mar 3, 2006
1,212
0
166
You would need to move them over manually to the new remote location.