Differences

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

--- mysql:recoveringsynchronization [2017/11/11 15:25] – [Sixth step: set the password for the repl user] rlunaro
+++ mysql:recoveringsynchronization [2017/11/11 17:03] – [Sixth step: issue a change master to command in the slave] rlunaro
@@ Line 15: / Line 15: @@
 <code>
 mysql> stop slave;
+-- disable the slow query log is necessary because
+-- in the event of a full restore, the logging tables
+-- are dropped
+mysql> SET GLOBAL slow_query_log=0;
+mysql> set global general_log=0;
 </code>
@@ Line 96: / Line 101: @@
 </code>
-Annotate these "File" and "position": it will be neede futher.
+Annotate these "File" and "position": it will be needed futher.
 ==== Fourth step: make a full backup of your database ====
@@ Line 156: / Line 161: @@
 master_port = 3306,
 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 general_log=1;
 </code>