MySQL DELETE FROM - removing entries from a table bases on some value or values.

A simple DELETE FROM reminder;

Restore lost or broken configurations files in Debian

If we've deleted or messed up a configuration file, then we can restore by doing the following;

Read my.cnf file

If we want to read an option group within a my.cnf config file for MySQL, then we can do so as follows;

my_print_defaults --config-file=/etc/mysql/my.cnf mysqld2

in the above example, we will read from the file /etc/mysql/my.cnf all values under the group mysql2

If we use the --config-file only, then only this file will be read.

 

The following works quite well;

my_print_defaults mysqld1

this will read from all configuration files (assuming they are included), where mysqld1 is the group

Running Multiple MySQL Instances on One Machine

WIP

Resources;

https://dev.mysql.com/doc/refman/8.0/en/multiple-servers.html

https://mariadb.com/kb/en/running-multiple-mariadb-server-processes/#systemd

https://www.percona.com/blog/2014/08/26/mysqld_multi-how-to-run-multiple-instances-of-mysql/

Master-Slave

https://www.toptal.com/mysql/mysql-master-slave-replication-tutorial this one rocks

https://www.digitalocean.com/community/tutorials/how-to-set-up-master-slave-replication-in-mysql

See also https://stackoverflow.com/a/2896718

and my previous post here

For an overview of Replication specific Filters, see here https://mydbops.wordpress.com/2021/09/24/replication-filters-in-mysql-an-overview/

 

See here for copies of my 3 cnf files from a working configuration on a Slackware box. 

See also here for a wrapper type script called sql and here for script to automate the configuration of setting up mysql instances, username's, passwords, master, slave replication etc.

Master-Master

https://www.digitalocean.com/community/tutorials/how-to-set-up-mysql-master-master-replication

MySQL table is marked as crashed and last (automatic?) repair failed

 

Problem building meslink

I had trouble building mesllink using Netbeans but note that it did build correctly from the original source on the box, from the command line by running make.

This is similar to a problem I had with mesdb detailed here. (worth reading first).