search

sabre-io / Baikal

Baïkal is a Calendar+Contacts server
https://sabre.io/baikal/
GNU General Public License v3.0
2.5k stars 289 forks source link

What the setup for MySQL should be? #1100

Closed WeT-Klb closed 2 years ago

WeT-Klb commented 2 years ago

I am using Baikal on a QNAP-NAS TS-251. The MySQL-Database is a mix of InnoDB and MyISAM. Also the different tables are a mix of different Collation like utf8mb4_general_ci, utf8_unicode_ci, utf8_bin. Are there any suggestion to change it to a homogene system? Baikal

ByteHamster commented 2 years ago

The pma_* tables with different encoding are not created by Baikal. They are from phpMyAdmin.

WeT-Klb commented 2 years ago

Is it safe to delete that pma-folder (on the left side of screenshot) inside the baikal-SQL-database?

ByteHamster commented 2 years ago

I'm not sure. My guess would be that phpmyadmin then either re-creates them or stops working. For Baikal, these tables are irrelevant.

WeT-Klb commented 2 years ago

Ok - i tried and took the risk - everything works after i deleted those phpMyAdmin-related entries. phpMyAdmin has it´s own database and Baikal works like a charme, too. I still don´t have any idea why those entries took place inside Baikal´s database - but i guess maybe i did something wrong long time before.

But still one thing: All tables are utf8mb4_general_ci but "calendars" is the only one with utf8_unicode_ci. Is this ok or should it be the same like all other tables utf9mb4_general_ci?

ByteHamster commented 2 years ago

That's indeed inconsistent in the default Baikal database. I will change the code, so it creates a utf9mb4_general_ci encoded table in the future. Not sure what phpmyadmin does when changing the encoding.

WeT-Klb commented 2 years ago

Well - i changed everything to utf8mb through phpMyAdmin - and still everything works well.