I'm debating between using Feeds module and Backup and Migrate and I'm not sure which would be the best option here.
Here's the scenario - I've two versions of the same site - both drupal 7, both have the same content types and taxonomy structure. One is live, one is on a development server. Due to some unclear communication a bunch of content edits were added to the live site that need to be merged in to the development site where we've made major improvements with Views and several stylistic changes, so we can't just dump the database and then move it without wiping out all the new content on the live site.
So does anyone have a good idea on how to best move JUST the content tables from the database? I know it will be different from install to install, but if you could help me get an idea of what to look for I can use the backup and migrate module and just exclude every table except those which I need.
Thanks in advance.
node
,node_revision
,field_*
... for yourcontent
and move them. It's best not to get in this situation because it's a PITA.