You are here

Datenbanken

Error message

  • Unable to create CTools CSS cache directory. Check the permissions on your files directory.
  • Unable to create CTools CSS cache directory. Check the permissions on your files directory.

Modellierungswerkzeug für UML, SysML, BPMN etc.

* Enterprise Architect (EA) - https://www.sparxsystems.de

Oracle

* https://www.oracle.com/de/linux/
* https://www.oracle.com/technetwork/developer-tools/sql-developer/downloa...
* https://docs.oracle.com/en/database/oracle/oracle-database/index.html

MySQL

$ mysqldump [OPTIONS] datenbank [tabellen]
$ mysqldump [OPTIONS] --databases [OPTIONS] datenbank1 [datenbank2 datenbank3...]
$ mysqldump [OPTIONS] --all-databases [OPTIONS]
$ mysqldump --opt datenbank > datensicherung.sql
SQL-Dump einspielen:
$ mysql datenbank
$ mysql -e "source /pfad-zur-datensicherung/datensicherung.sql" datenbank
/var/lib/mysql/mysql

* http://dev.mysql.com/doc/refman/5.1/de/resetting-permissions.html

Datenbanken in Prolog

* https://www.philipphauer.de/info/info/datenbanken-in-prolog/

Dokumentation

* https://modern-sql.com/de/feature/listagg
* https://www.akadia.com/services/ora_treewalking_with_sql.html