User Tools

Site Tools


mysql:recoveringsynchronization

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
mysql:recoveringsynchronization [2017/11/11 16:54] – [Third step: take note of the last position of the master database] rlunaromysql:recoveringsynchronization [2022/12/02 22:02] (current) – external edit 127.0.0.1
Line 161: Line 161:
 master_port = 3306, master_port = 3306,
 master_log_file = 'you have to guess the log file name that goes here from the slave', master_log_file = 'you have to guess the log file name that goes here from the slave',
-master_log_pos = 4;  -- everybody put 4 here, I don't know why +master_log_pos = ENTER THE POSITION YOU ANNOTATE IN THE LAST COMMAND;   
 +</code> 
 + 
 +And start the slave:  
 + 
 +<WRAP left round info 20%> 
 +Do this in the slave 
 +</WRAP> 
 +<code> 
 +start slave;
 mysql> SET GLOBAL slow_query_log=1;  mysql> SET GLOBAL slow_query_log=1; 
 mysql> set global general_log=1; mysql> set global general_log=1;
mysql/recoveringsynchronization.1510415699.txt.gz · Last modified: 2022/12/02 22:02 (external edit)