andrewmoir Posted June 5, 2007 Share Posted June 5, 2007 Dear all, I trust you can point me in the right direction. My laboratory collects our data into a simple flat file database (MySQL). Reports are generated from the database. I wish to replicate the data onto our hosted (ISP's) web server so that customers can also view reports. so local network MYSQL -> ISP (hosted) MYSQL. No data has to travel the other way. Note the database file size is 30 mb. Is there an automatic way that any changes to the local database can be transferred to the hosted database? One way I thought about was to flag any row that has any sort of change made to it with a value (e.g. 1) and then build a little vb app to transfer all data from the database that has been flagged with a 1 (then set all transferred rows to 0). regards Andy Unfortunately our clients cannot come down our ADSL to view data. Link to comment https://forums.phpfreaks.com/topic/54269-incremental-updates-from-local-mysql-to-isp-mysql-server/ Share on other sites More sharing options...
fenway Posted June 6, 2007 Share Posted June 6, 2007 You can just compare uids if you trust them enough. Link to comment https://forums.phpfreaks.com/topic/54269-incremental-updates-from-local-mysql-to-isp-mysql-server/#findComment-269116 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.