MySQL

Data is in /var/lib/mysql

Config is in

 /etc/mysql/conf.d/mysql.cnf

Tuning code

• wget https://github.com/major/MySQLTuner-perl/tarball/master
• tar xf master
• cd major-MySQLTuner-perl-993bc18/

 ./mysqltuner.pl 

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

Status:

 systemctl status mariadb

See log:

 journalctl -u mariadb.service

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