Migrating from sqlite to mariadb
Posted: Sat Dec 12, 2020 4:36 pm
Hi there,
I am running a s9y 2.1.1 installation with sqlite on a server which is shut down shortly. There are 851 posts with ~5k pictures I would like to keep. I am very happy with serendipity and do not want to move to another plattform. Therefore, I aim to move to a new server with version 2.3.5 (current stable) and mariadb.
Installation etc. was no problem, but ingesting the data was. What I tried:
* Install 2.1.1 with sqlite and use the old DB intending to upgrade to 2.3.5 later. Accessing any page gave the error: "Cannot write to directory .../templates_c/. Please check the permissions."
* Install 2.1.1 with mariadb and import sqlite dump of old db gives the same error.
* Install 2.3.5 with mariadb and just import tables permalinks, entries, references from old db into the fresh db seems to work (e.g. dropping entries and replacing it with the old version). But I loose authors and probably messed up more which I didn't notice yet.
The old db might have inconsistencies and therefore produce the errors above. I still want to preserve the data.
Can you give me a hint how to migrate properly? If there is documentation for this, I must have missed it :-/
Regards
Andreas
I am running a s9y 2.1.1 installation with sqlite on a server which is shut down shortly. There are 851 posts with ~5k pictures I would like to keep. I am very happy with serendipity and do not want to move to another plattform. Therefore, I aim to move to a new server with version 2.3.5 (current stable) and mariadb.
Installation etc. was no problem, but ingesting the data was. What I tried:
* Install 2.1.1 with sqlite and use the old DB intending to upgrade to 2.3.5 later. Accessing any page gave the error: "Cannot write to directory .../templates_c/. Please check the permissions."
* Install 2.1.1 with mariadb and import sqlite dump of old db gives the same error.
* Install 2.3.5 with mariadb and just import tables permalinks, entries, references from old db into the fresh db seems to work (e.g. dropping entries and replacing it with the old version). But I loose authors and probably messed up more which I didn't notice yet.
The old db might have inconsistencies and therefore produce the errors above. I still want to preserve the data.
Can you give me a hint how to migrate properly? If there is documentation for this, I must have missed it :-/
Regards
Andreas