Fixed MySQL replication slave got Last_SQL_Errno: 1062

If you don’t want REDO the complete procedure, a good fix would be to use

STOP SLAVE;    
SET GLOBAL sql_slave_skip_counter=1;
START SLAVE;

If there are too many such errors, a good idea would be to automate it using a bash script.

Reference : Ut xD(2017), https://serverfault.com/questions/336888/what-causes-the-mysql-error-1062-duplicate-entry-when-starting-slave, Last visit at Jan 2022

Removing epoxy packaging from chips

source : https://www.youtube.com/watch?v=mT1FStxAVz4&list=WL&index=1

  1. Using machine remove the top packet
  2. In Room temperature put a drop or two of fuming nitric acid into the milled packet and waited for a while
  3. Put the IC on the hot plate, like ceramic container. Around 100 degree C for speed up reaction.
  4. keep put a drop acid on the ICs top when acid evaporation.
  5. Use Acetone clean the Chips.

Manuel SQL backup for ISPConfig by command line

Version 3.1.x

The following command will start cron job backup in advance.

command: cron_debug.php

php /usr/local/ispconfig/server/cron_debug.php --cronjob=500-backup.inc.php

Version 3.2.x

command: backup-now.php

Usage:
php backup-now.php --id=<4> [--type=]
Options:
--id id of the website to backup.
--type backup type: all, web or mysql. Default is all.
php /usr/local/ispconfig/server/backup-now.php --id=1 --type=mysql