Data is in /var/lib/mysql
Config files:
... after you change THE REAL ONE
systemctl daemon-reload
... and then for either:
systemctl restart mariadb
Tuning code wget https://raw.githubusercontent.com/BMDan/tuning-primer.sh/main/tuning-primer.sh chmod u+x that then run it
Status:
systemctl status mariadb
See log:
journalctl -u mariadb.service
add
bind-address=127.0.0.1 # to prevent connections from outside of the machine ... and change logging to "local1"
Upgrade from 10.1 to 10.3
Following directions from https://mariadb.com/docs/deploy/upgrade-community-server-cs103-debian9/
create /data/backup/preupgrade_backup mariabackup --backup -uroot --target-dir=/data/backup/preupgrade_backup mariabackup --prepare --target-dir=/data/backup/preupgrade_backup
apt remove
And then.
cswmysql5 startup file, /etc/opt/csw/init.d/cswmysql5: change
MYSQL_VAR=/var/opt/csw/mysql5
to
MYSQL_VAR=/local/mysql
installing Perl 5.8.9, to hook up mysql, to cope with
gcc: language strconst not recognized gcc: language strconst not recognized
edit the Makefile and remove -xstrconst and -mt