Table synchronizing question

[jeanpaul1979]

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?

[ess]

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....
http://www.webyog.com/en/downloads.php

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

here is a class that performs schema synchronizations
http://www.phpclasses.org/browse/package/2354.html

Good luck.
Ess