Loading...
 
[Zobrazit/Skrýt nabídky vlevo]
[Zobrazit/Skrýt nabídky vpravo]

MySQL - repair corrupted relay log

  • save output from "show slave status\G" for later usage (!important!)
  • stop slave;
  • reset slave;
  • change master to master_log_file='master-bin.005431', master_log_pos=97799659; (master_log_file=Relay_Master_Log_File from status, master_log_pos=Exec_Master_Log_Pos from status)
  • start slave;

Created by darek. Last Modification: Úterý 19 of leden, 2016 08:24:27 CET by darek.