Difference between revisions of "SQL database"

From aquarium-doc
Jump to navigationJump to search
Line 3: Line 3:
== Installation ==
== Installation ==
Use the following commands to install MariaDB:
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-get upgrade</code>
<code>sudo apt install mariadb-server</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.


== Backup ==
== Backup ==

Revision as of 11:35, 24 March 2023

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:

Heading text

The database contains the following tables: