+34 911 599 883

+34 911 895 172

MySql

Comprobar que el servidor esclavo slave de mysql de Kmaleon está funcionando correctamente

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;

Comprobar que el servidor esclavo slave de mysql de Kmaleon está funcionando correctamente Leer más »

Error Plesk: 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

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

Error Plesk: 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 Leer más »