Two (or more) databases

[nighthawk]

I need to have two databases with identical structure on two different servers. Is there a way to automaticaly sinchonize them?

[rse]

How accurately do you need them synchronised - like daily, or every query?

If you only need it sync'd for backup purposes then you could just write a PHP script to export the DB to a text file then FTP it to the other server.

If you need it sync'd per DB query then the best way I guess would be to write in two queries in your code updating them both at the same time.

If you need help with the cron option, i can probably write you a script to do it.