"mirroring" a mysql table

[Anon]

hello everyone,

i'm not sure if somebody saw something i need. i'm searching for a php script or a class that automatically duplicate all mysql-querys that i send to the server.

the reason is, that i want to have the same database online (isp) and offline (intranet). i think it will be possible to create something like a log-table and a script that checks this table to update the local database. the other way the same, an script online which get information by mail or uploaded file to update the "online" database.

i read something about mysql-configuration which do this, but i think i have not enough rights on the isp-server to do it that way.

if somebody know a "simple" effective solution, please let me know.

tobi

[saloon12yrd]

Why don't you look up the manual? Its all in there...

Dominique

[Anon]

smart answer look up where.........

[Anon]

hi dominique,

i wrote that i can't configure the mysql-server because of missing rights on the ISP server, so i search an other solution than the one direct from mysql.

i think you mean the mysql-manual, or?

tobi

[saloon12yrd]

Yeah I meant that but I see now that I misunderstood. Two options come to mind: Take a deep dive into the sources of phpMyAdmin, the database dump functions got quite good in the 2.2.x branch. You'll probably find what you need to dump the database. After you have that it should be quite easy to send this dump to your other server by the same script. The receiving server should watch an "incoming" directory for this file and if it exists it inserts the content into the local database. You might want to think about LOCK files at this point...

The other option needs rudimentary shell access on both servers - then you can use the mysqldump function to get the dump, .netrc and ftp to send it (use scp instead if you like).

Firewalling etc. should not be a big concern since you're able to create an ip2ip tunnel.

Hope this helps a little more...

Dominique