En el MASTER y en el SLAVE: SELECT * FROM `BASEDATOS`.`asu_log` ORDER by interno DESC LIMIT 10; SHOW MASTER STATUS; SHOW MASTER STATUS\G SHOW SLAVE STATUS\G VOLVER A SINCONIZAR CON MASTER: PARAMOS SLAVE: STOP SLAVE; CHANGE MASTER TO MASTER_LOG_FILE=’mysql-bin.007585′, MASTER_LOG_POS=253; mysql-bin.007585 y 253 se obitienen de SHOW MASTER STATUS START SLAVE;
Si en los backups de PLESK obtienes este ERROR: WARNING: (mysql object ‘DATABASE’) Not all the data was backed up into /var/lib/psa/dumps/clients/CLIENT/domains/DOMAIN/databases/DATABASE_2_35 successfully. mysqldump: Got error: 23: Out of resources when opening file ‘./DATABASE/jos_qlue404_links.MYD’ (Errcode: 24) when using LOCK TABLES Editamos el fichero /etc/my.cnf y añadimos la linea: [mysqld] open_files_limit = 5000