I need to import blogs from a drupal database to another drupal database. Both the old and new drupal content types have different fields. I would like to get some hints about the sql queries or drupal api functions to be used and the process to be used to get data from old database.I have access only to the mysql database and not ftp/admin side.

1 Answer 1


Try using the feeds module and export to a CSV file then import the data under the new respective fields. You may need to add extra fields to the new content type to prevent data loss

  • I have modified my question
    – user7282
    Jul 5, 2012 at 12:33
  • I have access only to database
    – user7282
    Jul 10, 2012 at 7:52
  • so you cannot get the feeds module installed?
    – frazras
    Jul 10, 2012 at 17:20
  • I dont have admin access, so new module cant be installed
    – user7282
    Jul 11, 2012 at 9:33
  • The only other option I can think of is to dump the current database on to a local drupal install that you can admin, install feeds, update your content, uninstall feeds, dump the local database then import your new local SQL dump into the restricted site
    – frazras
    Jul 11, 2012 at 11:31

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.