[jchaclan]

Hello...
I'm kind of new in MySQL, I've worked with MySQL in little proyects;

basicaly at college, but now, I have a big proyect and I have some

questions that I can't answer by myself.

I'm working with PHP and MySQL. There are two offices that are storing

data on the DB placed at the main office. The problem is...
What should I do if the internet Goes Down? The office that is accessing

remotely the DB should keep working and storing data even if there is no

internet connection.....

I thought of having a DB on each office and storing on both DBs at the

same time and if I can't connect remotely with the other office I'll only

store locally. When the internet connection comes back then I'll update

the other DB.

Now my Real Problem is.....
How can I know, when the internet connection is back again?
How can I tell to MySQL to automatically Update the other data base?

Is there somebody who can help me to solve my problems or have another

Idea to solve it?

The people should keep storing data in both offices the hole day...

Thanks...

JP CHACLAN

[GG Dart]

do you want both offices in the end to have their data in one database, or in 2 databases on your main server?

[jchaclan]

Originally Posted by GG Dart

do you want both offices in the end to have their data in one database, or in 2 databases on your main server?

The answer to your question is...

At the end... I want both offices to have their data in one database, place at the main office... the problem here is what to do to ensure that the data from the other office is going to be store in the DB....

Thanks...