<div>
It depends on how you need to handle your data. What is the purpose of this scenario?<br />
Usually one would go for a binary log and apply it to the second server (master/slave setup).
</div>


It depends on how you need to handle your data. What is the purpose of this scenario?
Usually one would go for a binary log and apply it to the second server (master/slave setup).

<div>
Do you have direct access to the mysql servers?<br />
I.e. you would have an application/script running locally that will connect to each mysql server and perform the select/if exists update else insert into the other.<br />
You can configure the frequency within your local system as well as add the logic to speedup the process by not retrieving unchanged data unnecessarily.
</div>


Do you have direct access to the mysql servers?
I.e. you would have an application/script running locally that will connect to each mysql server and perform the select/if exists update else insert into the other.
You can configure the frequency within your local system as well as add the logic to speedup the process by not retrieving unchanged data unnecessarily.

<div>
Both servers are on shared hosting plans, so &nbsp;I don't know if I have the kind of access you're talking about. &nbsp;I was hoping there would be a msysql script that could auto-run.
</div>


Both servers are on shared hosting plans, so  I don't know if I have the kind of access you're talking about.  I was hoping there would be a msysql script that could auto-run.

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
I have two servers, hosted by different companies. &nbsp;Both running MySQL. &nbsp;I was wondering if there's a script that could run automatically that would transfer all of the data in the DB from one server over to the other. &nbsp;Preferable something that ran automatically, like every 4 hours. &nbsp;The table structure would be the same on both servers.<br />
<br />
Thanks
</div>
</div>


Hi,

I have two servers, hosted by different companies.  Both running MySQL.  I was wondering if there's a script that could run automatically that would transfer all of the data in the DB from one server over to the other.  Preferable something that ran automatically, like every 4 hours.  The table structure would be the same on both servers.

Thanks

Replicate data from one MySQL DB to another

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.