Synchronising

[mickallen]

I'm looking for advice as to what is the best way to keep two databases synchronised.
I'm wanting to add records on a local database then when finished put the changes to a remote database held on my hosting companies web server.

Thanks in advance for any advice

 

[Cagliostro]

what do you think about triggers? John Fill

ivfmd@mail.md

 

[rycamor]

I think triggers are great; you just can't get them in MySQL.

However, mysql does support replication, which is actually a better fit for what mickallen needs. Read the documentation at

http://www.mysql.com/doc/R/e/Replication_Implementation.html

"the wonderful thing about triggers, is triggers are wonderful fun..." (oops, I mean tiggers ;-))