Difference between revisions of "SQL database"
From aquarium-doc
Jump to navigationJump to search
| (7 intermediate revisions by the same user not shown) | |||
| 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 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. | The commands are also inside the <code>libinstall</code> script inside the repository of aquarium-ctrl. | ||
| Line 20: | Line 14: | ||
== Backup == | == Backup == | ||
Manual backup works as following: | Manual backup works as following: | ||
* Export of database with <code>sudo mysqldump -u root aquarium > name_of_backup.sql | * Export of database with <code>sudo mysqldump -u root aquarium > name_of_backup.sql</code> | ||
* Transfer of data to alternative storage | * Transfer of data to alternative storage | ||
* Restoring data from backup works with <code>mysql aquarium < name_of_backup.sql | * 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>sudo mysql -u root aquarium < name_of_backup.sql</code> | |||
== Create user == | |||
Create user "aquarium" with matching password when restoring on a new device: | |||
* log in with <code>sudo mysql -u root</code> | |||
* execute <code>create user aquarium identified by 'password';</code> | |||
* execute <code>grant all privileges on aquarium.* to aquarium with grant option;</code> | |||
== Maintaining the database == | |||
Use phpmyadmin to administrate user rights. | |||
Installation is done with the following steps: | |||
* <code>sudo apt install phpmyadmin</code> | |||
* Choose the Apache web server for configuration. This will automatically trigger the installation of Apache. | |||
== | == Structure of database == | ||
The database contains the following tables: | The database contains the following tables: | ||
Latest revision as of 14:29, 24 March 2023
Aquarium Control uses MariaDB.
Installation
Use the following commands to install MariaDB:
sudo apt-get updatesudo apt-get upgradesudo apt install mariadb-serversudo apt-get install libmariadb-devsudo apt-get install libmariadb-dev-compatsudo 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
aquariumon the new device (log in withsudo mysql -u rootand executecreate database aquarium;) - Restoring data from backup works with
sudo mysql -u root aquarium < name_of_backup.sql
Create user
Create user "aquarium" with matching password when restoring on a new device:
- log in with
sudo mysql -u root - execute
create user aquarium identified by 'password'; - execute
grant all privileges on aquarium.* to aquarium with grant option;
Maintaining the database
Use phpmyadmin to administrate user rights. Installation is done with the following steps:
sudo apt install phpmyadmin- Choose the Apache web server for configuration. This will automatically trigger the installation of Apache.
Structure of database
The database contains the following tables:
