We are working on providing a DB migration script. Here is a pull request that is still work in progress: https://github.com/owncloud/core/pull/6457 Any help with coding and testing is highly appreciate.
Frank On 15.01.2014, at 16:17, Otto Kekäläinen <o...@seravo.fi> wrote: > I tried this migration a few days ago (look at the mailing list > history with author my name), and I after manually fixing many many > things I eventually gave up. At the moment there is no working > migration script. > > Today I reinstalled one OwnCloud installation with MySQL and simply > re-created the users and moved the files. A bit of work, but at the > moment the best option. Hopefully an official migration script would > be made at some point. Even better if SQLite was not default, not even > for home users.. > > 2014/1/15 Reinoud van Leeuwen <reinou...@n.leeuwen.net>: >> >> On 15 jan. 2014, at 21:56, Diederik de Haas <didi.deb...@cknow.org> wrote: >> >>> On Wednesday 15 January 2014 21:39:19 Reinoud van Leeuwen wrote: >>>> I have another problem: it seems that in my SQLite installation a table >>>> oc_fscache is present, which is missing in the Mysql Dump... >>> >>> Just create that table, or leave it out all together. It is meant to cache >>> things, so if it's not present, it will be created (and filled). >>> I've cleared that table many times during testing, so afaik it's safe to >>> leave >>> it out. >> >> Next thing I stumble upon is: >> >> ERROR 1062 (23000) at line 5269: Duplicate entry >> 'calendar/appinfo/remote.php-core' for key 'PRIMARY' >> >> Makes sense since the create table statement is >> >> CREATE TABLE `oc_appconfig` ( >> `appid` varchar(32) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', >> `configkey` varchar(64) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', >> `configvalue` longtext COLLATE utf8_unicode_ci, >> PRIMARY KEY (`appid`,`configkey`), >> >> and in the dump are lines: >> >> INSERT INTO `oc_appconfig` >> VALUES('calendar/appinfo/remote.php','core','remote_calendar'); >> INSERT INTO `oc_appconfig` >> VALUES('calendar/appinfo/remote.php','core','remote_caldav'); >> >> >> So, someone might know how to fix this particular problem, but my point is >> that from a application maintainer perspective I do not feel really good >> having to hack like this in SQL dumps to get this working. And it sounds >> like the database is different on SQLite, otherwise this would not have been >> present in the database at all.. >> Or is this the result from buggy updates? >> >> Reinoud >> _______________________________________________ >> Owncloud mailing list >> Owncloud@kde.org >> https://mail.kde.org/mailman/listinfo/owncloud > > > > -- > Otto Kekäläinen > +358 44 566 2204 > http://seravo.fi/ > _______________________________________________ > Owncloud mailing list > Owncloud@kde.org > https://mail.kde.org/mailman/listinfo/owncloud _______________________________________________ Owncloud mailing list Owncloud@kde.org https://mail.kde.org/mailman/listinfo/owncloud