<div>
Yes, it is absolutely possible, as long as the server is MySQL 5.0 and the databases are hosted by the same MySQL server instance.
</div>


Yes, it is absolutely possible, as long as the server is MySQL 5.0 and the databases are hosted by the same MySQL server instance.

<div>
Hi<br />
<br />
That sounds great, but how?
</div>


<div>
<div class="content wysiwyg-content">
Hi<br />
<br />
I have got a scheduled task in place that moves information from 1 database (Firebird) to another (MySQL). The issue that i have, is that some information that goes into the MySQL database, also needs to be in ANOTEHR MySQL database, which is stored on the same server.<br />
<br />
Rather than modifying the scheduled task to do 2 updates, is it possible to create a trigger, that would move selected data into the other database.<br />
<br />
E.g. If account = &quot;041&quot; then copy field A, B, C, D into the other database<br />
<br />
Is this possible?<br />
<br />
Thanks very much<br />
<br />
PS - high point score as it would be very valuable to me
</div>
</div>


Hi

I have got a scheduled task in place that moves information from 1 database (Firebird) to another (MySQL). The issue that i have, is that some information that goes into the MySQL database, also needs to be in ANOTEHR MySQL database, which is stored on the same server.

Rather than modifying the scheduled task to do 2 updates, is it possible to create a trigger, that would move selected data into the other database.

E.g. If account = "041" then copy field A, B, C, D into the other database

Is this possible?

Thanks very much

PS - high point score as it would be very valuable to me

Mysql - Copying Info to another database??

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.