How to backup individual databases?

Configuration
1

Hi,

I’m currently using hte automated snapshot addon that submits the snapshot to my Google Drive.

I’m looking to backup an individual database, specifically the one used by BookStack as I don’t want to lose my data.

I upgraded Home Assistant via HACS a few weeks back and it broke so much stuff. I literally had to uninstall and reinstall MariaDB and everything returned to normal (luckily I didn’t have much in the DB).

Is there an easy way to export/backup databases? MariaDB doesn’t seem to have a front end or Web UI?

Thanks!

2

Hello,
I’m in the same spot I think.
Need to back up bookstack and restore in another system. It’s getting big and I need to take it out of homeassitant.

The MariaDB part you can do the backup installing the phpMyadmin addon, and then make a SQL dump from there.
I’m trying to figure out how to back up the files from bookstack. Wich I guess are deep in the HA supervisor container

3

Hi,

I use MySQL and for DB backups I have them automated via AutoMYSQLBackUP.
I understand it also works with MariaDB.

Here is a link that will explain it in more detail including the installation and configuration.
https://www.tecmint.com/mysql-mariadb-postgresql-database-backup-using-automysqlbackup-autopostgresqlbackup/

These dumps are then backed up off-site.

Hope that helps?

4

I’ve been backing up my bookstack database via the following:

mysqldump bookstack > bookstack_10_10_21.backup.sql

Then I just use scp to move it somewhere else.

Of course, using a snapshot also seems to work and I’ve used it succesfully when rebuilding HA.

1 Like