06
Nov/23MariaDB/MySQL Database Size Sensor In Home Assistant
A quick little tip to get the size of your database into Home Assistant. The example below will get the Home Assistant database size from MySQL. This should also work for MariaDB using the Recorder integration. Assuming the database schema … Continue reading
02
Oct/23DigitalOcean Managed (Clustered) Database With WordPress
Overview I have an existing WordPress site running on DigitalOcean on a self managed instance (Droplet). It was time for an OS upgrade and generally I like to start from scratch rather than doing an in place upgrade. Ideally, I … Continue reading
04
Sep/23MySQL Consider increasing innodb_redo_log_capacity
Overview I started getting the following warnings in the log from MySQL: 2023-03-18T05:12:59.566053Z 0 [Warning] [MY-013865] [InnoDB] Redo log writer is waiting for a new redo log file. Consider increasing innodb_redo_log_capacity. Redo logs are stored transactions that are used to … Continue reading
06
Jun/22MySQL caching_sha2_password: the specified module could not be found.
Upgrading from MySQL 5.x to 8 has caused an error with existing accounts. The fix is to set the authentication to use. More details can be found here. MySQL 8.0.11 error connect to caching_sha2_password the specified module could not be … Continue reading
07
Sep/20Upgrading MySQL Running In Docker (Compose)
Overview I wanted to try and upgrade my MySQL database from 5.7 to 8.0 however I have containerised my database install. What I thought was a immutable container would be a simple burn and switch turned out to be a … Continue reading
07
May/18Cannot load from mysql.proc. The table is probably corrupted
I was trying to update accounts in MySQL and got the following error message: Cannot load from mysql.proc. The table is probably corrupted A little bit scary if my data was corrupted. Turns out there is an upgrade command which … Continue reading
14
Apr/14TTRSS – Your access level is insufficient to run this script
After upgrading from 1.9 to 1.11 I had got the error message “Your access level is insufficient to run this script” when trying to log in. The problem was TTRSS needed to run some upgrade script but if you log … Continue reading
31
Mar/14Move / Change Password RasPBX Database
Overview Migrating Host First export and import the database data into the new database. It goes without saying that the RasPBX should be stopped or any changes between the export and import will not be captured and lost. The root … Continue reading