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.


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 '12 at 12:33
  • I have access only to database – user7282 Jul 10 '12 at 7:52
  • so you cannot get the feeds module installed? – frazras Jul 10 '12 at 17:20
  • I dont have admin access, so new module cant be installed – user7282 Jul 11 '12 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 '12 at 11:31

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.