Category: database / MySQL / Postgress

10.02.2017

This is a basic but yet very powerful way to stress-test your site. WordPress, Blogspot but also TYPO3 without HipHop and PHP7 (check out this benchmark) seem to be quiet good targets for this attack. I basically managed to bring […]

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