frappe@starlord:~/frappe-bench$ bench restore ~/backups/20200718_030011-site1_local-database.sql.gz
MySQL root password:
For key collation_server. Expected value utf8mb4_unicode_ci, found value utf8mb4_general_ci
================================================================================
Creation of your site - site1.local failed because MariaDB is not properly
configured. If using version 10.2.x or earlier, make sure you use the
the Barracuda storage engine.
Please verify the settings above in MariaDB's my.cnf. Restart MariaDB. And
then run `bench new-site site1.local` again.
================================================================================
Database settings do not match expected values; stopping database setup.
frappe@starlord:~/frappe-bench$
Thanks @arokia and @trentmu for your help. I have two questions.
It seems MariaDb now uses a structured set of .cnf files (or at least seems recommended practise). With this system of .cnf files, is my.cnf still the recommended location for these changes?
what do you think would be the best permanent solution? Should I file a PR against “install.py”
MariaDb version:
frappe@starlord:/etc/mysql$ mysql --verbose --version
mysql Ver 15.1 Distrib 10.5.4-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2
frappe@starlord:/etc/mysql$
I saw something similar in ubuntu16 - the DB wouldn’t restart cleanly unless I killed processes. I have a post on ubuntu here - the DB section notes may offer a glimmer of useful info, but I can’t say for sure