=================== Miscellaneous Stuff =================== Just some notes really as much as anything else to check that this is still working. I wonder if I didn't ought to do some sort of 'overview' description of how this whole site works, just to make it easier to get into the way of doing updates! Talking of which, I really do need to sit down and write up the MySQL crisis - what happened, how the recovery worked, learning points, etc. Here is the list of 'links' that I recorded from all of that which may or may not be of use! * import and export databases: https://www.digitalocean.com/community/tutorials/how-to-import-and-export-databases-in-mysql-or-mariadb * users and permissions: https://www.daniloaz.com/en/how-to-create-a-user-in-mysql-mariadb-and-grant-permissions-on-a-specific-database/ * configuring for remote access: https://mariadb.com/kb/en/configuring-mariadb-for-remote-client-access/ https://mariadb.com/kb/en/configuring-mariadb-for-remote-client-access/#granting-user-connections-from-remote-hosts * recover: https://serverfault.com/questions/685535/how-to-recover-mariadb-database-after-a-failed-update https://bobbyiliev.com/blog/start-mysql-mariadb-recovery-mode-due-to-innodb-coruption-on-cpanel * install: https://www.digitalocean.com/community/tutorials/how-to-install-mariadb-on-ubuntu-20-04 * use mysqldump: https://mariadb.com/kb/en/mysqldump/#restoring * repair crashed SD card: https://www.switchdoc.com/2016/01/tutorial-repairing-corrupted-sd-cards-for-the-raspberry-pi-on-mac/ * find default directory for MariaDB: https://mariadb.com/kb/en/default-data-directory-for-mariadb/