[Owncloud] switching from sqlite to mysql

[Reinoud van Leeuwen]

Thanks! I'll take a look at it.

Reinoud

On 15 jan. 2014, at 22:41, Frank Karlitschek <frank at owncloud.org> wrote:

> 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 <otto at 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 <reinoud.v at n.leeuwen.net>:
>>> 
>>> On 15 jan. 2014, at 21:56, Diederik de Haas <didi.debian at 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 at kde.org
>>> https://mail.kde.org/mailman/listinfo/owncloud
>> 
>> 
>> 
>> -- 
>> Otto Kekäläinen
>> +358 44 566 2204
>> http://seravo.fi/
>> _______________________________________________
>> Owncloud mailing list
>> Owncloud at kde.org
>> https://mail.kde.org/mailman/listinfo/owncloud
> 
> _______________________________________________
> Owncloud mailing list
> Owncloud at kde.org
> https://mail.kde.org/mailman/listinfo/owncloud
>