starting mariadb server as a systemd service (
systemctl start mariadb-server.service
) fails with error message:
>Incompatible header in messagefile '/usr/share/mysql/english/errmsg.sys'. Probably from another version of MariaDB".
The contents of errmsg.sys
are something like below (sharing only few lines here):
*
¡
Î
^A^K8^Kd^K¶^K^G^Le^L}^L^L°^LÇ^Lø^L^O^Mb^M¥^Mñ^M^N°^NN^O^OÇ^Oô^O7^PN^Pn^P}^P©^Pß^P ^QP^Q^Q¨^QÇ^QZ^Rh^R^Rµ^Rá^R^C^S$^SB^S^S³^SÏ^Sï^S)^T:^TÉ^T=^U~^Uö^U^T^V@^Vd^V^V¿^Væ^V^H^Wj^W©^W^L^Xv^X¤^XÓ^X\^Y^Y¬^YÆ^Yå^YW^Z^ZÕ^Z%^[^[°^[Ö^[+^\e^\è^\,^]L^] /usr/share/mysql/english/errmsg.sys`
and tried to start mariadb service. Still it shows the same error and service failed to start.
Tried to make things work out but not sure if my approach is the right way to solve the issue.
mariadb-server.service
:
[Unit]
Description=MariaDB server
[Service]
Type=simple
ExecStart=/opt/mariadb/10.3.9/bin/mysqld --basedir=/opt/mariadb/10.3.9 --datadir=/var/lib/mysql --lc-messages-dir=/usr/share/mysql/english --plugin-dir=/opt/mariadb/10.3.9/lib/plugin --user=root --log-error=/var/log/mariadb/mariadb.log --pid-file=/var/run/mariadb/mariadb.pid --socket=/var/lib/mysql/mysql.sock
ExecStop=always
Environment=
RestartSec=10**
[Install]
WantedBy=default.target
Asked by CodeDoesn'tLie
(11 rep)
Jan 1, 2019, 05:50 PM
Last activity: Jan 1, 2019, 07:39 PM
Last activity: Jan 1, 2019, 07:39 PM