0

Probably a dumb question, but could I simply export an SQL file from the database of a Drupal 5 site and import it into a Drupal 6 database in the same table provided I used the same CCK fields for both? I've tried to migrate content in so many different ways and pretty much everything has failed so far... importing csv through the feeds module was my greatest hope and was made to look so easy but I keep getting an HTTP error.

Also is node_revisions the table that contains all of the stories? I tried exporting nodes, but it didn't seem to contain the body field.

1

Instead of trying some convoluted way of exporting and then re-importing the data and maintaining all meta-data - have you tried simply upgrading the site to Drupal 6?

This has been heavily documented on drupal.org

When you do a major drupal upgrade, so long as there is a drupal 6 module for your functionality, there will be update hooks that alter the database to convert it to the new schema.

This includes CCK, revisions etc

  • Yes I have tried... failed miserably :( the drupal 5 site I am dealing with is very poorly coded, and that may have to do with the many hurdles I'm running into... I will try again if all else fails. – Jane May 31 '11 at 2:04
  • The trick is to read the whole upgrade guide, make sure ALL contrib is disabled before updating core, and make sure you are running the latest version of 5.x first. – wiifm May 31 '11 at 5:20
  • OK I guess I have no other choice than to try again... but then what do I do to recover the stories once I've upgraded (if I manage to upgrade)? Thanks! – Jane May 31 '11 at 14:42
  • If you follow the upgrade path, all content will come with you too. – wiifm Jun 1 '11 at 0:03
  • But the idea here is to transfer the nodes to a different site. Not to keep them in the same site after upgrading... – Jane Jun 1 '11 at 1:39

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.