Dnia sobota, 21 grudnia 2024 22:59:05 czas środkowoeuropejski standardowy Dietz Pröpper pisze: > Howdy, > > Frank Mehnert: > > I tried the migration from MySQL to Sqlite3 and failed: > > > > I upgraded everything to current unstable. > > I started `akonadi-db-migrator --newengine sqlite`. > > The assistant started and executed all steps, then tried to finish and > > aborted with a core dump. MySQL is still running. > > Same here. As a side note, I also installed akonadi-backend-sqlite, but still > a core dump. > > Regards, > Dietz >
Hi, It looks like migration is working now (at least for me, on Debian testing): `yaros@DebYan:~$ akonadi-db-migrator --newengine sqlite` `Stopping Akonadi service...` `Backup file /home/yaros/.config/akonadi/akonadiserverrc.bkp already exists. Overwrite? [(y)es/(N)o] y` `akonadi.collectionattributetable OK` `akonadi.collectionmimetyperelation OK` `akonadi.collectionpimitemrelation OK` `akonadi.collectiontable OK` `akonadi.flagtable OK` `akonadi.mimetypetable OK` `akonadi.parttable OK` `akonadi.parttypetable OK` `akonadi.pimitemflagrelation OK` `akonadi.pimitemtable OK` `akonadi.pimitemtagrelation OK` `akonadi.relationtable OK` `akonadi.relationtypetable OK` `akonadi.resourcetable OK` `akonadi.schemaversiontable OK` `akonadi.tagattributetable OK` `akonadi.tagremoteidresourcerelationtable OK` `akonadi.tagtable OK` `akonadi.tagtypetable OK` `Reading datadir from the MariaDB server failed. Got the following error when executing the 'mysql' command line client` `ERROR 1049 (42000): Unknown database 'mysql'` `FATAL ERROR: Upgrade failed` `org.kde.pim.akonadiserver: Running DB initializer` `org.kde.pim.akonadiserver: DB initializer done` `org.kde.pim.akonadiserver: Running DB initializer` `org.kde.pim.akonadiserver: DB initializer done` `Running fsck on the source database` `Database fsck completed` `Migrating table SchemaVersionTable (1/17)...` `100%...` `Optimizing table SchemaVersionTable...` `Migrating table ResourceTable (2/17)...` `10%...` `20%...` `30%...` `40%...` `50%...` `60%...` `70%...` `80%...` `90%...` `100%...` `Optimizing table ResourceTable...` `Migrating table CollectionTable (3/17)...` `0%...` `10%...` `20%...` `30%...` `40%...` `50%...` `60%...` `70%...` `80%...` `90%...` `100%...` `Optimizing table CollectionTable...` `Migrating table MimeTypeTable (4/17)...` `20%...` `40%...` `60%...` `80%...` `100%...` `Optimizing table MimeTypeTable...` `Migrating table PimItemTable (5/17)...` `0%...` `10%...` `20%...` `30%...` `40%...` `50%...` `60%...` `70%...` `80%...` `90%...` `100%...` `Optimizing table PimItemTable...` `Migrating table FlagTable (6/17)...` `40%...` `50%...` `90%...` `100%...` `Optimizing table FlagTable...` `Migrating table PartTypeTable (7/17)...` `80%...` `90%...` `100%...` `Optimizing table PartTypeTable...` `Migrating table PartTable (8/17)...` `0%...` `10%...` `20%...` `30%...` `40%...` `50%...` `60%...` `70%...` `80%...` `90%...` `100%...` `Optimizing table PartTable...` `Migrating table CollectionAttributeTable (9/17)...` `0%...` `10%...` `20%...` `30%...` `40%...` `50%...` `60%...` `70%...` `80%...` `90%...` `100%...` `Optimizing table CollectionAttributeTable...` `Migrating table TagTypeTable (10/17)...` `100%...` `Optimizing table TagTypeTable...` `Migrating table TagTable (11/17)...` `100%...` `Optimizing table TagTable...` `Migrating table TagAttributeTable (12/17)...` `Optimizing table TagAttributeTable...` `Migrating table TagRemoteIdResourceRelationTable (13/17)...` `Optimizing table TagRemoteIdResourceRelationTable...` `Migrating table PimItemFlagRelation (14/17)...` `0%...` `10%...` `20%...` `30%...` `40%...` `50%...` `60%...` `70%...` `80%...` `90%...` `100%...` `Optimizing table PimItemFlagRelation...` `Migrating table PimItemTagRelation (15/17)...` `100%...` `Optimizing table PimItemTagRelation...` `Migrating table CollectionMimeTypeRelation (16/17)...` `0%...` `10%...` `20%...` `30%...` `40%...` `50%...` `60%...` `70%...` `80%...` `90%...` `100%...` `Optimizing table CollectionMimeTypeRelation...` `Migrating table CollectionPimItemRelation (17/17)...` `Optimizing table CollectionPimItemRelation...` `Backing up original database...` `Starting Akonadi service...` `Migration completed successfully.`
