cheechm Posted September 4, 2008 Share Posted September 4, 2008 What is the best way to do this? One is an offline server, which can access the online server, and the other is an online server. I thought the way to do it is save an update of the database tables (which have been changed) and save it to a file on the webserver, and then everytime a person logs on the offline part of the site, it checks to see if it has the latest database file, and if not updates. Although that will probably get slower as the database grows. What other way could I do it? Thanks Link to comment https://forums.phpfreaks.com/topic/122737-database-syncing/ Share on other sites More sharing options...
cheechm Posted September 4, 2008 Author Share Posted September 4, 2008 Bump Link to comment https://forums.phpfreaks.com/topic/122737-database-syncing/#findComment-634003 Share on other sites More sharing options...
Mchl Posted September 4, 2008 Share Posted September 4, 2008 Replication perhaps? http://dev.mysql.com/doc/refman/5.0/en/replication.html <-- in case it's MySQL you have Link to comment https://forums.phpfreaks.com/topic/122737-database-syncing/#findComment-634012 Share on other sites More sharing options...
cheechm Posted September 5, 2008 Author Share Posted September 5, 2008 What if the offline server can't access internet? And this file which is downloaded needs to be secured. Link to comment https://forums.phpfreaks.com/topic/122737-database-syncing/#findComment-634936 Share on other sites More sharing options...
DarkWater Posted September 5, 2008 Share Posted September 5, 2008 What if the offline server can't access internet? And this file which is downloaded needs to be secured. It has to be able to access the internet if you expect anyone to visit it or do anything useful on it. Link to comment https://forums.phpfreaks.com/topic/122737-database-syncing/#findComment-634937 Share on other sites More sharing options...
cheechm Posted September 5, 2008 Author Share Posted September 5, 2008 Not necessarily. There is an online server, but I want people to be able to take information to the offline server and vice versa. So they can update at home etc... But it must be secure. Link to comment https://forums.phpfreaks.com/topic/122737-database-syncing/#findComment-634940 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.