synchronize local-remote db

[Anon]

Hello all,

in the last two weeks I tried to find a way to synchronize data from a local mysql database with a database on a remote server. The problem is that my provider doesn't allow connects over odbc (only scripts running on that server are allowed to connect to the mysql server). I'm looking for a kind of shake-hand solution where two scripts are working hand in hand and parse data from a local script to the remote one. But maybe I'm thinking to complexe. Therefore I will ask the forum to discuss that topic and get any further ideas.

Thanks
Andreas

[dstockto]

This isn't the safest or most secure way to do this, but perhaps you could write a script on your server that allows a SQL statement to be sent in and then runs it on the server, and then on the local machine have one that goes through your DB and sends SQL statements to the server based on stuff in the local db. You could go the other way too.

Dave