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
