Exoon Posted May 14, 2012 Share Posted May 14, 2012 Hello, Ive got a fairly successful website and im looking at cloning it, I want to set up a cron to check the main site if there are any new posts and if there are insert it into the DB. Ive got them on 2 separate hosts so i don't want to just read from the DB increase the main site goes down and brings the whole 2nd site down. What would be the easiest way to do it? Not looking for people to give code, Just their suggestions. Cheers Quote Link to comment Share on other sites More sharing options...
requinix Posted May 14, 2012 Share Posted May 14, 2012 What kind of clone? Copy or mirror? How much of it is cloned? Quote Link to comment Share on other sites More sharing options...
Exoon Posted May 15, 2012 Author Share Posted May 15, 2012 Hi, I didn't really describe it well in the first post, Basically i have 2 identical tables, I want to copy all the data from one table on one server over to the other server but i dont want to get duplicates, So i basically want to run a cron to automatically copy all the new posts from DB 1 and put it into DB 2 which are on different servers. Cheers. Quote Link to comment Share on other sites More sharing options...
requinix Posted May 15, 2012 Share Posted May 15, 2012 I got that much, but what is going on beyond what you've described? Does the cloned table need to look exactly the same as the "master" table, or you do only want to import information from it? Could the two tables every look different in the slightest? Oh, and are they on the same database server? Quote Link to comment 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.