View Full Version : Table synchronizing question

02-05-2007, 07:18 PM
Hi, i took on a project that might be too much for me too handle atm. but i'm trying to make it work.

Here's what i'm trying to do now.

I have an an offline and an online table set. The online one should be synchronized when the administrating user presses the save form button.
The tables have subtables.

Is there a clean way to do this?

02-05-2007, 07:51 PM
There are a number of ways to do this.

One is to use a ready made application that will synchronize data between databases. Another one is to create an application yourself....which may be difficult...depending on what you are trying to achieve....etc.

Have a look at webyog...I believe it offers database synchronization between remote and local mysql databases. I think the community edition is available for free....

Also, you should have a look at PHP Classes from http://www.phpclasses.org

here is a class that performs schema synchronizations

Good luck.