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 Answer 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, 2011 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, 2011 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, 2011 at 14:42
  • If you follow the upgrade path, all content will come with you too.
    – wiifm
    Jun 1, 2011 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, 2011 at 1:39

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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