Good links: =========== http://www.howtoforge.com/how-to-repair-mysql-replication MySQL recover from Backup .sql data ====================================== mysql -u root -p dbName backup-dbNameDump.sql ———– Very useful in slave ————————————————————– slave-skip-errors=126,1062 126 = the ambiguous ‘unknown error on master’ typically caused by tables in dis-repair on master. 1062 = duplicate entry (happens all the time on high capacity db in master-master setup)
Category: MySQL
Mysql Tips and tricks mostly used in Linux
MYSQL tools debian packages
maatkit and innotop maatkit as package is dependant to a perl module present in system maatkit as tar.gz can be installed independantly by a normal user