madness69 Posted January 19, 2011 Share Posted January 19, 2011 Hi guys, nice being a part of the forum, my question is, i have a network of differente websites, each of these websites work in the same services. All there backend, databases are the same, having there same tables, etc. Only thing that changes in them is the CSS for differente design of course. What i need it to do is when one of the websites insert a new product the other sites receives the same product of this website. All these site have the same capability, when site A insert a new product site B and C receives the same product in there databases, when site C insert new product site A and B receives the same product and forward. How can i achieve this accomplishment, maybe i should put this question in the mysql section but maybe here can help me. Be well Quote Link to comment https://forums.phpfreaks.com/topic/224987-syncronyse-differente-databases/ Share on other sites More sharing options...
webbhelp Posted January 19, 2011 Share Posted January 19, 2011 I haven't done this before but I will try to help you anyway because I think you will be happy to get a answer anyway =) I would try: First I would connect to the first database and insert it... Then I would use: mysql_close(); And then I would create a new connection Then I would insert it there. I think that is the only way, but I am not sure! Try =) Quote Link to comment https://forums.phpfreaks.com/topic/224987-syncronyse-differente-databases/#findComment-1162057 Share on other sites More sharing options...
madness69 Posted January 19, 2011 Author Share Posted January 19, 2011 Yes, im experimenting, no better way than try, i will try your advice, is the first time i try something like that and proud in doing it, it looks a good challenge, im reading about triggers, it looks interesting. Thanks for the reply Quote Link to comment https://forums.phpfreaks.com/topic/224987-syncronyse-differente-databases/#findComment-1162060 Share on other sites More sharing options...
coupe-r Posted January 19, 2011 Share Posted January 19, 2011 Have you looked up Database Mirroring? You need to set up a Replication Server. Check this out. http://www.astahost.com/info.php/Mirror-Mysql-Database-Mysql-Server_t5155.html Not sure if this would help you Quote Link to comment https://forums.phpfreaks.com/topic/224987-syncronyse-differente-databases/#findComment-1162068 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.