rubing Posted July 15, 2008 Share Posted July 15, 2008 How do I synchronize between a local and remote table. Remote tables would be on partner sites who agree to use my service. Quote Link to comment https://forums.phpfreaks.com/topic/114887-sync-remote-to-local-table/ Share on other sites More sharing options...
fenway Posted July 15, 2008 Share Posted July 15, 2008 You mean like replication? Quote Link to comment https://forums.phpfreaks.com/topic/114887-sync-remote-to-local-table/#findComment-590839 Share on other sites More sharing options...
rubing Posted July 15, 2008 Author Share Posted July 15, 2008 I guess. Is it easy to implement between tables on different servers? Quote Link to comment https://forums.phpfreaks.com/topic/114887-sync-remote-to-local-table/#findComment-591117 Share on other sites More sharing options...
rubing Posted July 16, 2008 Author Share Posted July 16, 2008 How difficult would it be to transfer my data as a backup (e.g.): mysqldump --host=remote_ip_address Would the remote site's firewall prohibit this? Quote Link to comment https://forums.phpfreaks.com/topic/114887-sync-remote-to-local-table/#findComment-591142 Share on other sites More sharing options...
fenway Posted July 16, 2008 Share Posted July 16, 2008 The mysql site has plenty of dev articles on this subject. As for remote IPs, yes, you have to make sure you can connect non-localhost on the given port. Quote Link to comment https://forums.phpfreaks.com/topic/114887-sync-remote-to-local-table/#findComment-591415 Share on other sites More sharing options...
rubing Posted July 16, 2008 Author Share Posted July 16, 2008 Afiliate sites will not give me that access. I guess I'll just set them up with a php script that accepts my POST variables. And then report back a success message to my server. Do you know how php can obtain this success message? I've seen it on phpMyadmin. Or would I just check to see that there were no errrors? thx again fenway! Quote Link to comment https://forums.phpfreaks.com/topic/114887-sync-remote-to-local-table/#findComment-591582 Share on other sites More sharing options...
fenway Posted July 16, 2008 Share Posted July 16, 2008 No idea about the php stuff. Quote Link to comment https://forums.phpfreaks.com/topic/114887-sync-remote-to-local-table/#findComment-591773 Share on other sites More sharing options...
lampstax Posted July 18, 2008 Share Posted July 18, 2008 What about federated tables ? Its meant for this kind of stuff. Quote Link to comment https://forums.phpfreaks.com/topic/114887-sync-remote-to-local-table/#findComment-593328 Share on other sites More sharing options...
fenway Posted July 23, 2008 Share Posted July 23, 2008 What about federated tables ? Its meant for this kind of stuff. Yeah, but they're leaving federated in/out of certain production builds, so you have to be careful. Quote Link to comment https://forums.phpfreaks.com/topic/114887-sync-remote-to-local-table/#findComment-597923 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.