IT Wiki - database https://tmade.de/wiki/ 2026-08-05T04:32:07+00:00 IT Wiki https://tmade.de/wiki/ https://tmade.de/wiki/lib/exe/fetch.php?media=wiki:dokuwiki.svg text/html 2017-12-09T00:19:24+00:00 Anonymous (anonymous@undisclosed.example.com) derby_network_server https://tmade.de/wiki/doku.php?id=database:derby_network_server&rev=1512778764&do=diff Derby Network Server text/html 2017-12-09T00:19:24+00:00 Anonymous (anonymous@undisclosed.example.com) mongo_db https://tmade.de/wiki/doku.php?id=database:mongo_db&rev=1512778764&do=diff Mongo DB text/html 2024-07-05T22:37:00+00:00 Anonymous (anonymous@undisclosed.example.com) mysql https://tmade.de/wiki/doku.php?id=database:mysql&rev=1720219020&do=diff Home tmade.de Home Wiki MySQL Configurator: <http://www.mysqlcalculator.com/> <https://tools.percona.com/> <http://www.fromdual.com/de/mysql-configuration-file-sample> Backup Example backupscript to backup each database as a single file: #!/bin/bash MYSQL="/usr/bin/mysql" USERNAME="root" PASSWORD="" DBHOST="localhost" DBEXCLUDE="information_schema" BACKUPDIR="/mysql_backups" LOGFILE=${BACKUPDIR}/`date +%d.%m.%y`.log LOGERR=${BACKUPDIR}/ERROR_`date +%d.%m.%y`.log HOST="`hostname`" MAIL… text/html 2025-07-01T10:39:02+00:00 Anonymous (anonymous@undisclosed.example.com) oracle https://tmade.de/wiki/doku.php?id=database:oracle&rev=1751366342&do=diff Home tmade.de Home Wiki Oracle Maintain su - oracust1 #Authenticate as "oracust1" user expdp parfile=exp_customer.par #Starts dumping sqlplus /nolog @/scripts/drop_ts.sql CUSTOMER #Delete tablespace "CUSTOMER" and all related users sqlplus /nolog @create_ts_cust.sql CUSTOMER SID #Create tablespace, paramter 1(CUSTOMER)= Name of the tablespace, parameter 2 (SID) databaseinstance … text/html 2018-03-31T08:06:19+00:00 Anonymous (anonymous@undisclosed.example.com) postgresql https://tmade.de/wiki/doku.php?id=database:postgresql&rev=1522483579&do=diff Home tmade.de Home Wiki Postgresql Important directories: /var/lib/postgresql/8.4/main /etc/postgresql/8.4/main DUMP To dump a postgresql database you can use the “pg_dumpall” command which dumps ALL databases. Example: su - postgres -c "pg_dumpall > /path/to/backup/`hostname`.`date +%d.%m.%Y_%T`" su - postgres -c "pg_dumpall > /opt/portalu/backup/dumpall_`hostname`_`date +%a`"