Difference between revisions of "SQL database"

Revision as of 14:16, 24 March 2023

Aquarium Control uses MariaDB.

Use the following commands to install MariaDB:

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 sudo mysql -u root aquarium < name_of_backup.sql
keep in mind to create user "aquarium" with matching password when restoring on a new device

Use phpmyadmin to administrate user rights. Installation is done with the following steps:

The database contains the following tables:

@@ Line 3: / Line 3: @@
 == Installation ==
 Use the following commands to install MariaDB:
+* <code>sudo apt-get update</code>
-<code>sudo apt-get update</code>
+* <code>sudo apt-get upgrade</code>
+* <code>sudo apt install mariadb-server</code>
-<code>sudo apt-get upgrade</code>
+* <code>sudo apt-get install libmariadb-dev</code>
+* <code>sudo apt-get install libmariadb-dev-compat</code>
-<code>sudo apt install mariadb-server</code>
+* <code>sudo apt-get install libgsl-dev</code>
-<code>sudo apt-get install libmariadb-dev</code>
-<code>sudo apt-get install libmariadb-dev-compat</code>
-<code>sudo apt-get install libgsl-dev</code>
 The commands are also inside the <code>libinstall</code> script inside the repository of aquarium-ctrl.
@@ Line 26: / Line 20: @@
 * keep in mind to create user "aquarium" with matching password when restoring on a new device
-== Heading text ==
+== Maintaining the database ==
+Use phpmyadmin to administrate user rights.
+Installation is done with the following steps:
+* <code>sudo apt-get install apt</code>
+== Structure of database ==
 The database contains the following tables: