Bug #2486 Replication problem
| Submitted: | 23 Jan 2004 2:26 | Modified: | 23 Jan 2004 5:07 |
|---|---|---|---|
| Reporter: | Luca Tocco | Email Updates: | |
| Status: | Not a Bug | Impact on me: | |
| Category: | MySQL Server: Replication | Severity: | S2 (Serious) |
| Version: | 4.0.17 | OS: | Linux (Linux-Mandrake) |
| Assigned to: | CPU Architecture: | Any |
[23 Jan 2004 2:26]
Luca Tocco
[23 Jan 2004 3:23]
Luca Tocco
I have set master log file: MASTER_LOG_FILE='smarty2-bin.001'; and it work but: MASTER_LOG_FILE='smarty2-bin.index'; not work.
[23 Jan 2004 5:07]
Guilhem Bichot
Thank you for taking the time to write to us, but this is not a bug. Please double-check the documentation available at http://www.mysql.com/documentation/ and the instructions on how to report a bug at http://bugs.mysql.com/how-to-report.php Additional info: Hi, As you noted the correct command is MASTER_LOG_FILE='smarty2-bin.001'; It's all explained in the replication section of our manual. Regards, Guilhem
[17 Apr 2008 4:23]
James Day
You also get this error message: Could not find first log file name in binary log index file (server_errno=1236) if you specify the full path to the binary log file instead of only the log file in the MASTER_LOG_FILE entry of CHANGE MASTER: Wrong: MASTER_LOG_FILE='/mysql/binlog.000001' Correct: MASTER_LOG_FILE='binlog.000001' If you see a / or \ in the Master_Log_File entry of SHOW SLAVE STATUS this is probably the mistake.
Portions of this website are copyright © 2001, 2002 The PHP Group
Page generated in 0.039 sec. using MySQL 8.4.7-u6-cloud
Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the
respective copyright holders.
It is not reviewed in advance
by Oracle and does not necessarily represent the opinion of
Oracle or any other party.