How to backup a MariaDB or MySQL database using MySQLDump

HomeLab
1

After my video last week on what I am self hosting:

I had a few people ask about my database backup script. I am going to do an upcoming video on it, but because I need to add the code somewhere, so I made a write up on www.spacerex.co! Write up here:

Let me know what you think & if this still needs a video!

2

Hi Will,

Presumably you use Mariaa.db as a general database for many applications.

Could you give:

  • a run down of how you do this

  • what applications you are targeting to the DB

  • how you configure the applications to use the DB

Using a single DB definitely interests me - just not sure how to do it.

Also - where do you host the DB? Synology?

Do you have any pointers to tutorials?

Cheers

Steve

3

also interested in this topic - I’m just starting into the NAS world having received my DS923+ a couple of days ago.

I definitely want to use a single db for all the applications that I’m considering running with docker, so definitely a tutorial around this would be greatly appreciated * winking at @Will * :smiley: