<div>
Do you have a system that can query all MySQL servers?<br />
You could script this using perl from a system that can query each server as well as have a local server.<br />
You could also have the data replicated among the servers.
</div>


Do you have a system that can query all MySQL servers?
You could script this using perl from a system that can query each server as well as have a local server.
You could also have the data replicated among the servers.

<div>
All my servers are local. How would I do this in perl?
</div>


All my servers are local. How would I do this in perl?

<div>
<div class="content wysiwyg-content">
I have 3 different MySQL servers all containing different information. &nbsp;There are some custom reports we would like to generate daily which we currently spend about an hour a day doing manually. &nbsp; If we had all the tables needed all located in the same database we could fully automate what we need to do saving us an hour of day of time. &nbsp;<br />
<br />
The plan is to have cron dump the database tables from all 3 servers and scp them to a new server we are going to use just for reporting. &nbsp;Can someone show me the best way dump just certain database tables then merge all the tables into a new database?
</div>
</div>


I have 3 different MySQL servers all containing different information.  There are some custom reports we would like to generate daily which we currently spend about an hour a day doing manually.   If we had all the tables needed all located in the same database we could fully automate what we need to do saving us an hour of day of time.  

The plan is to have cron dump the database tables from all 3 servers and scp them to a new server we are going to use just for reporting.  Can someone show me the best way dump just certain database tables then merge all the tables into a new database?

3 different MySQL databases into 1

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.

MySQL Server

Linux is a UNIX-like open source operating system with hundreds of distinct distributions, including: Fedora, openSUSE, Ubuntu, Debian, Slackware, Gentoo, CentOS, and Arch Linux. Linux is generally associated with web and database servers, but has become popular in many niche industries and applications.