Backing Up MySQL/MariaDB Database

[Hallucyn8]

Firstly apologies if this is covered already somewhere but I did a search and couldn’t find anything.

I’m in the process of migrating to a shared MariaDB database and want to know if the built in backup option under My OSMC will backup the shared databases as it does for the standard databases?

If it doesn’t is there an accepted best practice/method for taking a back up of the MariaDB database?

At the moment I have My OSMC set to automatically backup before an update so ideally would want something that ties in with this.

Thanks in advance for any help or support.

[fzinken]

@Hallucyn8

I’m in the process of migrating to a shared MariaDB database and want to know if the built in backup option under My OSMC will backup the shared databases as it does for the standard databases

It doesn’t

@Hallucyn8

If it doesn’t is there an accepted best practice/method for taking a back up of the MariaDB database

You could either use mysqldump on the command line or install something like phpmyadmin and do it via browser

[sam_nazarko]

We don’t backup the MySQL database presently but this is something we will likely add on the future.

[Hallucyn8]

Presumably using phpmyadmin is just a case of selecting the DB and using the Export function? And if I ever needed to restore it just drop the existing DB and use the Import function to import the file that was exported?

[Hallucyn8]

Thanks @sam_nazarko, will look forward to seeing this at a later date

[fzinken]

@Hallucyn8

Presumably using phpmyadmin is just a case of selecting the DB and using the Export function? And if I ever needed to restore it just drop the existing DB and use the Import function to import the file that was exported?

Correct, just export as SQL