SQL database

Aquarium Control uses MariaDB.

Installation

Use the following commands to install MariaDB:

sudo apt-get update

sudo apt-get upgrade

sudo apt install mariadb-server

sudo apt-get install libmariadb-dev

sudo apt-get install libmariadb-dev-compat

sudo apt-get install libgsl-dev

The commands are also inside the libinstall script inside the repository of aquarium-ctrl.

Backup

Manual backup works as following:

• Export of database with sudo mysqldump -u root aquarium > name_of_backup.sql
• Transfer of data to alternative storage
• Before restoring, create the database aquarium on the new device (log in with sudo mysql -u root and execute create database aquarium;)
• Restoring data from backup works with mysql aquarium < name_of_backup.sql
• keep in mind to create user "aquarium" with matching password when restoring on a new device

Heading text

The database contains the following tables: