There is a script /etc/cron.daily/databasebackup.sh which dumps the databases daily, and uploads them to backblaze.

To force another backup, just execute the script and another copy will be made.

There is a copy of the MySQL database backups locally and on BackBlaze.

To restore a local copy, make a copy of the backup zip:

cp /backup/mysql/all_dbs.zip /tmp/

Decompress the zip:

cd /tmp
unzip all_dbs.zip

Then run this command to perform the restore from the shell or SSH.

mysql -u root beaconte_beacontech < beaconte_beacontech.sql

If restoring a different database, change the database name and file parameter.

The file must be in its raw form and not compressed or it won't work.