How to backup and restore a MySQL database from the command line
Backing Up To backup a MySQL database from the command line, use the mysqldump command and pip the output to a file. For example: mysqldump
Databases
How to log queries in real time using MariaDB/MySQL
Background You have some sticky queries but you can’t see what’s happening. On certain website actions pages are just slow and you fully suspect the
How to upgrade for MariaDB 5.5 to 10.1 and then to 10.3
You might encounter a situation (e.g. on AWS) where you have a new CentOS 7 server, but an old version of MariaDB 5.5 on the
MySQL stops working: InnoDB: Fatal error: cannot allocate memory for the buffer pool
Background A MySQL server stop working. You’re confused as this is a new Virtualmin installation and everything went smooth. You start troubleshooting: # service mariadb
How to reset / recover a MySQL root password
Update February 2022 Resetting MySQL password remains a nightmare due to all the differences between MySQL 7 and 8, and MariaDB. If you’re running the
How do you rename a MySQL table?
rename table t1 to t2; Reference: https://blog.marceloaltmann.com/en-how-to-rename-table-in-mysql-pt-como-renomear-tabelas-no-mysql/
How to cluster / set up MySQL for redundancy
MySQL has two good methods for replication, the one called Master-Master Replication, and the other called Group Replication. Group replication is more powerful and is
Help! I’m getting access denied trying to access a remote / local MySQL database
Sometimes when you try to access MySQL, you will get an access denied message. There could be a multitude of reasons but if you are
What literals exist for time series when you’re using InfluxDB?
u or µ microseconds ms milliseconds s seconds m minutes h hours d days w weeks Reference: https://docs.influxdata.com/influxdb/v1.7/query_language/data_exploration/#duration-literal
How to upgrade MariaDB from 10.1 to 10.3 Ubuntu Bionic (18.04) LTS Server
Background This article explains how to upgrade the default MariaDB 10.1 installation provided with Linux Mint 19 Tara or Tessa to MariaDB 10.3. One reason