mikedk Posted November 5, 2014 Share Posted November 5, 2014 (Posted this in the MySQL section, but i think the php section might be the proper place) I have a webshop db where i want to export some things linke order information to another external db on another server etc. Example of things to move: Table1 - orderid - orderdate Table2 - adress - shippingmethod I ONLY want it to export and import things that is not currently there. How can this be done in a php script? Quote Link to comment https://forums.phpfreaks.com/topic/292285-copy-content-from-one-db-to-external-db/ Share on other sites More sharing options...
cyberRobot Posted November 5, 2014 Share Posted November 5, 2014 Sorry I don't have any answers for you. I just wanted to let you (and anyone looking this topic) know that I hid your other topic under the MySQL section. Having duplicate topics can cause confusion among those responding. Especially if both topics get responses. Quote Link to comment https://forums.phpfreaks.com/topic/292285-copy-content-from-one-db-to-external-db/#findComment-1495779 Share on other sites More sharing options...
Barand Posted November 5, 2014 Share Posted November 5, 2014 Depends on the volume exported 1000 or less read from server1 table store in array connect to second server insert from the array more than 1000 read from server1 table write to a csv file connect to second server use LOAD DATA INFILE to insert records Quote Link to comment https://forums.phpfreaks.com/topic/292285-copy-content-from-one-db-to-external-db/#findComment-1495797 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.