Difference between revisions of "SQL database"

Revision as of 14:11, 24 March 2023

Aquarium Control uses MariaDB.

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.

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

The database contains the following tables:

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