Category: database / MySQL / Postgress

10.02.2017

„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?
28.01.2017

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) […]

03.08.2016

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‘ […]

01.06.2015

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 […]

03.02.2014

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 […]