SQL database - Revision history

Uwe at 13:29, 24 March 2023

2023-03-24T13:29:28Z

← Older revision		Revision as of 15:29, 24 March 2023
Line 18:		Line 18:
	* 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>)		* 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>		* Restoring data from backup works with <code>sudo mysql -u root aquarium < name_of_backup.sql</code>
	* keep in mind to create user "aquarium" with matching password when restoring on a new device
			== 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 ==		== Maintaining the database ==
Line 24:		Line 29:
	Installation is done with the following steps:		Installation is done with the following steps:
	* <code>sudo apt install phpmyadmin</code>		* <code>sudo apt install phpmyadmin</code>
	Choose the Apache web server for configuration. This will automatically trigger the installation of Apache.		* Choose the Apache web server for configuration. This will automatically trigger the installation of Apache.

	== Structure of database ==		== Structure of database ==
	The database contains the following tables:		The database contains the following tables:

Uwe at 13:19, 24 March 2023

2023-03-24T13:19:43Z

← Older revision		Revision as of 15:19, 24 March 2023
Line 24:		Line 24:
	Installation is done with the following steps:		Installation is done with the following steps:
	* <code>sudo apt install phpmyadmin</code>		* <code>sudo apt install phpmyadmin</code>
			Choose the Apache web server for configuration. This will automatically trigger the installation of Apache.

	== Structure of database ==		== Structure of database ==
	The database contains the following tables:		The database contains the following tables:

Uwe at 13:18, 24 March 2023

2023-03-24T13:18:53Z

← Older revision		Revision as of 15:18, 24 March 2023
Line 23:		Line 23:
	Use phpmyadmin to administrate user rights.		Use phpmyadmin to administrate user rights.
	Installation is done with the following steps:		Installation is done with the following steps:
	* <code>sudo apt~~-get~~ install ~~php~~</code>		* <code>sudo apt install phpmyadmin</code>

	== Structure of database ==		== Structure of database ==
	The database contains the following tables:		The database contains the following tables:

Uwe at 13:17, 24 March 2023

2023-03-24T13:17:11Z

← Older revision		Revision as of 15:17, 24 March 2023
Line 23:		Line 23:
	Use phpmyadmin to administrate user rights.		Use phpmyadmin to administrate user rights.
	Installation is done with the following steps:		Installation is done with the following steps:
	* <code>sudo apt-get install ~~apt~~</code>		* <code>sudo apt-get install php</code>

	== Structure of database ==		== Structure of database ==
	The database contains the following tables:		The database contains the following tables:

Uwe at 13:16, 24 March 2023

2023-03-24T13:16:58Z

← Older revision		Revision as of 15:16, 24 March 2023
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 26:		Line 20:
	* keep in mind to create user "aquarium" with matching password when restoring on a new device		* 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:		The database contains the following tables:

Uwe at 13:12, 24 March 2023

2023-03-24T13:12:19Z

← Older revision		Revision as of 15:12, 24 March 2023
Line 23:		Line 23:
	* Transfer of data to alternative storage		* 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>)		* 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>		* Restoring data from backup works with <code>sudo mysql -u root aquarium < name_of_backup.sql</code>
	* keep in mind to create user "aquarium" with matching password when restoring on a new device		* keep in mind to create user "aquarium" with matching password when restoring on a new device

	== Heading text ==		== Heading text ==
	The database contains the following tables:		The database contains the following tables:

Uwe: /* Backup */

2023-03-24T13:11:37Z

Backup

← Older revision		Revision as of 15:11, 24 March 2023
Line 22:		Line 22:
	* Export of database with <code>sudo mysqldump -u root aquarium > name_of_backup.sql</code>		* 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
			* 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>		* 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		* keep in mind to create user "aquarium" with matching password when restoring on a new device

Uwe at 13:05, 24 March 2023

2023-03-24T13:05:06Z

← Older revision		Revision as of 15:05, 24 March 2023
Line 20:		Line 20:
	== 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		* 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		* keep in mind to create user "aquarium" with matching password when restoring on a new device

	== Heading text ==		== Heading text ==
	The database contains the following tables:		The database contains the following tables:

Uwe at 13:04, 24 March 2023

2023-03-24T13:04:38Z

← Older revision		Revision as of 15:04, 24 March 2023
Line 20:		Line 20:
	== 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
			* Transfer of data to alternative storage
			* Restoring data from backup works with <code>mysql aquarium < name_of_backup.sql
			* keep in mind to create user "aquarium" with matching password when restoring on a new device

	== Heading text ==		== Heading text ==
	The database contains the following tables:		The database contains the following tables:

Uwe at 10:35, 24 March 2023

2023-03-24T10:35:31Z

← Older revision		Revision as of 12:35, 24 March 2023
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 ==