![](https://lemm.ee/pictrs/image/7329099e-79e2-4353-a9a2-bdbc4e915818.jpeg)
![](https://lemmy.world/pictrs/image/8286e071-7449-4413-a084-1eb5242e2cf4.png)
1·
3 months agoI created a DB with utf8mb4 with the general_ci collection, but the issue remains. I’ll try to change the SQL script
I created a DB with utf8mb4 with the general_ci collection, but the issue remains. I’ll try to change the SQL script
The app seems great.
@[email protected] I’m getting an error when trying to create the DB tables: Reason:
SQL Error [1273] [HY000]: (conn=517001) Unknown collation: 'utf8mb4_0900_ai_ci'
Does it support MariaDB 10.6.17?
Hijacking this topic, I use this software on Windows, which does incremental backups of the system (including the OS, alongside documents, downloads, etc). It can also be easily restored by booting a custom image from an USB and restore the image created.
Is there anything like this with Linux?
I use and recommend Baikal.
To make it work, I had to remove some things from the script, which didn’t work for me:
START TRANSACTION;
SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;
CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci
(like you suggested)COMMIT;
(In Alter Tables, since as far as I remember, DDL commands don’t need to commit, only the DML ones. So I did the commit manually)If I need to remove the registration, do I have to update the Value column on tarallo_settings table or are there any settings’ menu which I’m not seeing?