synchronize offline data with online data

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
valen53
Forum Contributor
Posts: 137
Joined: Tue Aug 27, 2002 9:29 am

synchronize offline data with online data

Post by valen53 »

Hi,

i have a system in local hosting. but currently i have a branch at other place. i need them to keyin customer detail.
Currently i don't want put my system online. so i just create a small application to let them online keyin. after that i download the data and copy to my offline system. after process, i need to upload data to the online system.

But this way is quite troublesome, except make system online, any solution can provide to me?

Thanks

Ps:/ english is not very well.
User avatar
Mordred
DevNet Resident
Posts: 1579
Joined: Sun Sep 03, 2006 5:19 am
Location: Sofia, Bulgaria

Post by Mordred »

What about just copying the data back to the online version? Export SQL data from your local system, import in the online system.
Of course, backup first, and be sure to understand the difference the autoincrement values make when importing. Try the process on a second local copy first maybe.
Post Reply