I have a Drupal install with 10 content types and 30 views being used as web app. The app uses MySQL as a database.

What I would like to do is to reuse the same app but with SQLite. Is there a way to migrate the theme, content types and views without re-building them from scratch? I am not interested in the content.

  • 1
    What does "migrate the theme" mean? Drupal theme is just a set of files. It has nothing to do with database migration. – ya.teck Apr 22 '15 at 9:58
  • possible duplicate of Export content types using features – kenorb Apr 22 '15 at 10:21
  • I'm voting to close this question as off-topic because the question is about migrating a database to a different database engine. – kiamlaluno Apr 27 '15 at 3:41

You can export all your config using Features module: This module dumps to code several config data as content types and Views (but no content), generating modules that once enabled in another site regenerate dumped config.

One you have your config exported install a new Drupal site over SQL Lite and enable the exported modules with the config.

To 'migrate' the theme you only have to copy the theme folder to the new installed site right folder (usually /sites/all/themes/ or /sites/all/themes/custom/).

  • sites/themes/all is wrong path :) – ya.teck Apr 22 '15 at 10:08
  • Oops, yes, you are right, I've edited my answer. – sanzante Apr 22 '15 at 10:16

If all what you need is just moving your site to SQLite database you can use special converter scripts like mysql2sqlite.sh. Another way is using DBTNG Migrator module.

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