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/
- 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/