Category: database / MySQL / Postgress


docker exec -it -u postgres example-db psql; # login interactively SELECT * FROM pg_stat_activity WHERE datname = ‚example‘; # check open connections to database example # (there shall be none, otherwise you can not drop the database) SELECT pg_terminate_backend ( […]

Simple Self Made DDoS test of your site

„autobench – Automates the benchmarking of web servers using httperf. autobench is used to to automate web server benchmarking. It runs httperf against the specified host or hosts, ramping up the number of requested connections, and logging the results in […]

Was macht eigentlich ORACLE?

Jeder kennt Steve Jobs (now dead) – aber wer kennt schon „Larry“ Ellison? 😀 Oracle hat 2010 die Firma „Sun Microsystem aufgekauft“ und damit OpenSource Technologie wie Java, VirtualBox und MySQL eingekauft. Lawrence Joseph „Larry“ Ellison (born August 17, 1944) […]


sudo bash; # become root #create directories mkdir -p /backup/mysql # backup every database manually separately mysqldump -u root DATABASE_NAME > /backup/DATABASE_NAME.sql; # backup every database separately automatically (easier to restore) for db in $(mysql -u root -e ’show databases‘ […]


tested on Linux debian7 3.2.0-4-amd64 #1 SMP Debian 3.2.46-1+deb7u1 x86_64 GNU/Linux in any case you need to stop current mysql operation: /etc/init.d/mysql stop; # stop mysql service # if that did not help try: killall mysqld; now you have two […]


login to mysql to see what databases are there. mysql -u root -p mysql> show databases; +———————-+ | Database | +———————-+ | information_schema | | DatabaseXY | | DatabaseXYZ | | mysql | | phpmyadmin | +———————-+ 7 rows in […]