bschultz Posted November 23, 2010 Share Posted November 23, 2010 I have two blogs (about the same topic) that I'd like to migrate into one blog. The one blog is a B2Evolution blog...while I wrote the other one. I have re-ordered the columns (names of...and placement of...)of the old B2evo blog to match the format of the one I wrote. I'm ready to import the data from the B2evo blog...but the column "row_number" is a primary key set to auto increment. The problem is that I already have data in the blog I wrote that will match the row_number of the B2evo blog. How can I merge the contents of these two with the most ease so as to avoid a conflict in the matching row_number's? Quote Link to comment https://forums.phpfreaks.com/topic/219524-migrating-contents-of-one-database-table-to-another/ Share on other sites More sharing options...
Pikachu2000 Posted November 23, 2010 Share Posted November 23, 2010 Don't copy the id. Just do the insert, letting the ids continue from where they currently end in the target table. Quote Link to comment https://forums.phpfreaks.com/topic/219524-migrating-contents-of-one-database-table-to-another/#findComment-1138216 Share on other sites More sharing options...
bschultz Posted November 23, 2010 Author Share Posted November 23, 2010 Once again...I try to make things too complicated! Thanks! Quote Link to comment https://forums.phpfreaks.com/topic/219524-migrating-contents-of-one-database-table-to-another/#findComment-1138218 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.