MariaDB database backup before KODI-Headless update

[Vaseer]

Hello

 

I have movie database in MariaDB Docker and I would like to make backup of my database, but I don't know how to do in properly.

Can you please give me instructions how to make backup and how to restore database.

 

BTW: Is there any limitations to make new topic/reply in Child Boards > Docker Containers?

In that section I don't have option to make new topic/reply.

 

Thanks

[jonp]

You should be able to reply in the Docker Containers subforum now. New topics in there are reserved for container authors only but anyone can reply. I messed up last night when I was applying permissions and temporarily locked anyone from posting replies in there.

 

[mossiemosforth]

It depends on how you want to back up the database.

 

For a file level backup you should be able to browse to the unraid share that your MariaDB config directory is mapped to and simply make a copy of it.

 

For an actual database backup you will need an SQL client tool to connect to MariaDB. Personally i use HeidiSQL, its free and simplistic to use. Simply place the IP of your unraid server and port 3306 into it and connect, from there you will be able to use the GUI to backup/restore your kodi databases to a file on your client machine.

 

Hope that helps m;)

[Squid]

There's also a BackupSQL docker application.  Never used it, but its there....

[CHBMB]

There's also a BackupSQL docker application.  Never used it, but its there....

 

Could never get that to work myself...

[steini84]

Just use mysqldump http://www.thegeekstuff.com/2008/09/backup-and-restore-mysql-database-using-mysqldump/

[CHBMB]

Sparklyballs' MariaDBWebsql docker had a built in web interface.  I use it (but forgot) and it works really well, and it was just a drop in replacement for the regular MariaDB container.

[ikosa]

you can use that script:

http://lime-technology.com/forum/index.php?topic=40386.msg389479#msg389479

[METDeath]

If you're using a docker, just copy the appdata/mariadb folder with the docker stopped. This has saved me a few times with various docker/config changes.