1. Download and install the latest version http://www.percona.com/downloads/XtraBackup/LATEST/ #For Debian wget http://www.percona.com/downloads/XtraBackup/LATEST/deb/squeeze/x86_6…

Show process list: SHOW PROCESSLIST; asd  Properties of Transactions: Transactions have the following four standard properties, usually referred to by the acronym ACID: Atomicity:…

mysql> SHOW TABLES LIKE "phpbb_%"; /* list all phpBB tables */ mysql> DROP TABLES LIKE "phpbb_%"; /* DROP THEM? Quite a naive approach.. */ Well, even before executing it I w…

For successful backup the packet size must be the same [mysqld] key_buffer                                      = 160M max_allowed_packet                      = 150M [mysqldump] qu…

Mysql Instances mysqlmanager --passwd >> /etc/mysqlmanager.passwd ## ##/etc/mysql/my.cnf ## [mysql.server] user-manager [manager] port                            =2273 monitoring-i…