owncloud 7 or 8 : migrating from sqlite to mysql (or pgsql)

Before Owncloud 6, one used solution was to use sqlite3 to generate an .sql (and then import this .sql in the database configured for Owncloud after using a conversion script in python) [as explained on http://fabianpeter.de/cloud/owncloud-migrating-from-sqlite-to-mysql/)

Now, it’s an option integrated in owncloud (>7.0.0) with this syntax (in your ownCloud root folder with your web user for owncloud (/var/www/owncloud/ and www-data in the case of an installation with Debian packages)):

php occ db:convert-type –all-apps mysql oc_mysql_user 127.0.0.1 new_db_name

What is the database password?
Creating schema in new database
The following tables will not be converted:
oc_clndr_calendars
oc_clndr_objects
oc_clndr_repeat
oc_clndr_share_calendar
oc_clndr_share_event
oc_contacts_addressbooks
oc_contacts_cards
oc_contacts_cards_properties
oc_gallery_sharing
oc_lucene_status
oc_media_albums
oc_media_artists
oc_media_sessions
oc_media_songs
oc_media_users
oc_permissions
oc_pictures_images_cache
oc_queuedtasks

Continue with the conversion (y/n)? [n] y

The step “oc_filecache” may be long 😉

At the end, your config.php is upgraded and you can see :

‘dbtype’ => ‘mysql’,

🙂

More information on :

http://doc.owncloud.org/server/7.0/admin_manual/maintenance/convert_db.html