MySQL

Data is in /var/lib/mysql

Config files:

• THIS IS THE REAL ONE: /etc/mysql/conf.d/mysql.cnf
• /etc/mysql/my.cnf <-- all this does is include everything in /etc/mysql/conf.d/
• /etc/systemd/system/mariadb.service.d/local.conf is automatically generated?
• the defaults, I think, are in /etc/alternatives/my.cnf

... 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

• is in daniel/major-MySQLTuner-perl-5aa880a/

Status:

 systemctl status mariadb

See log:

 journalctl -u mariadb.service

2023-01-27

add

 bind-address=127.0.0.1 # to prevent connections from outside of the machine
 ... and change logging to "local1" 

2021-05-30

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

• "mariadb-*"
• galeria-3
• libmariadbclient-dev
• libmariadbclient-dev-compat
• libmariadbclient18

And then.

• "mariadb_repo_setup" failed
• install mariadb-server mariadb-backup
• set the root password.
• apt install libdbd-mysql-perl

2010-03

cswmysql5 startup file, /etc/opt/csw/init.d/cswmysql5: change

 MYSQL_VAR=/var/opt/csw/mysql5

to

 MYSQL_VAR=/local/mysql

2008-12

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