Support for Drupal 7 is ending on 5 January 2025—it’s time to migrate to Drupal 10! Learn about the many benefits of Drupal 10 and find migration tools in our resource center.
By harings_rob on
Hi,
For one site I made use of sqlite, wich is working fine.
But it has some limitations and is slower then expected. I'd like to convert the sqlite database to mysql.
I tried various modules:
https://www.drupal.org/project/dbtng_migrator
https://www.drupal.org/project/backup_migrate
I also tried to convert the sqlite file with software but this also is not working.
Can anyone point me in the right direction?
Thanks.
Comments
I add the same issue (convert
I add the same issue (convert from sqlite to mysql) on an owncloud installation.
The idea was to dump sqlite database to a dump file, convert this file to mysql format and then import this file.
sqlite3 owncloud.db .dump > dump.mycloud.sql
Then you need to download a python script that converts sqlite to mysql dump format
Full article here (in french) : http://www.vincentliefooghe.net/node/83
Migrate module
The gold standard of migration modules is:
https://www.drupal.org/project/migrate
It is so powerful it will even be used in Drupal 8 core for migrating Drupal 6 and 7 websites.
It is, though, somewhat complex. Like Drupal, power comes with complexity.
drupalshrek