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

vliefooghe’s picture

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

wget http://www.redmine.org/attachments/download/6239/sqlite3-to-mysql.py
chmod a+x sqlite3-to-mysql.py
cat dump.mycloud.sql | python sqlite3-to-mysql.py > owncloud.sql

Full article here (in french) : http://www.vincentliefooghe.net/node/83

www.hebinweb.com : Drupal hosting for small companies and ngo
www.vincentliefooghe.net : my personal blog on Drupal & Identity management

drupalshrek’s picture

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
Please fill in my Learning a foreign language questionnaire if you have a moment.