JakeD2 Posted February 24, 2010 Share Posted February 24, 2010 Hello. Is it possible to create a PHP script that would forward everything from one MySQL database to another database (in another host)? I mean when I already have my website running in x host, I'd want to create a script that would every day automatically forward data to y host or upload SQL dump file to y host. I'm only interested in doing that with 1 simple table that is built fairly simple. It consists of daily error reports. Any hints or examples of how to build this kind of script are appreciated! Thank you. Quote Link to comment https://forums.phpfreaks.com/topic/193268-forwarding-data-to-other-server/ Share on other sites More sharing options...
fenway Posted February 24, 2010 Share Posted February 24, 2010 Why not just copy over the log? Or use replication? Quote Link to comment https://forums.phpfreaks.com/topic/193268-forwarding-data-to-other-server/#findComment-1017692 Share on other sites More sharing options...
JakeD2 Posted February 25, 2010 Author Share Posted February 25, 2010 Great! Thank you. Replication method worked perfectly. Can close this thread. Quote Link to comment https://forums.phpfreaks.com/topic/193268-forwarding-data-to-other-server/#findComment-1018146 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.