I am currently using Xibo version 3.3.2 installed via Docker on Ubuntu 18.04 for digital signage, and I would like to know how to backup the Xibo database. I have looked through the Xibo administration panel but I cannot seem to find any option to export or backup the database.
My ultimate goal is to recover the database so that I can install it on another machine following the excellent tutorial provided by ciphermenial at this address: Non-docker Installation on Ubuntu Server 22.04.
This new machine will replace the old server and will send the display elements to the players currently in place.
Can anyone please advise me on how to backup the Xibo database for a Docker installation? Are there any command line tools or third-party applications that I can use to perform the backup?
I have had good experience with backing up the shared directory under the xibo-document-root (e.g. /opt/xibo/shared). of course not at stress times so that all db caches were written to HD (to be safe, perhaps stop the docker containers of xibo).
In your docker config files you should have all the info you need to fill in the user, pw, database, etc… I would recommend just creating a nightly or weekly task to dump it to a file somewhere safe.
After being away for two weeks, I finally managed to access the server. I have just stopped all the Docker containers. However, when I checked the /opt/xibo folder, it turned out to be empty. I feel a bit lost at the moment.