View Single Post
Old 29th September 2007, 20:14
tera7 tera7 is offline
Join Date: Apr 2007
Posts: 44
Thanks: 0
Thanked 1 Time in 1 Post

Ok first of all thank you for your time.
Now i start it again from the begining i have all set it good at master but although
it creates binlogs can not read it through phpmyadmin (at my previous set it was readable)the log file of mysql shows nothing.
At the slave i set as it has to be i also read other how to and a lot of things at mysql documentation.
But at the log file shows that
070929 20:31:02 [Note] /usr/libexec/mysqld: Normal shutdown

070929 20:31:02 [Note] Error reading relay log event: slave SQL thread was killed
070929 20:31:02 [Note] /usr/libexec/mysqld: Shutdown complete

070929 20:31:02  mysqld ended

070929 20:31:04  mysqld started
070929 20:31:04 [Warning] Neither --relay-log nor --relay-log-index were used; so replication may break when this MySQL server acts as a slave and has his hostname changed!! Please use '--relay-log=used-relay-bin' to avoid this problem.
070929 20:31:04 [ERROR] Failed to open the relay log './GTO004-relay-bin.000001' (relay_log_pos 98)
070929 20:31:04 [ERROR] Could not find target log during relay log initialization
070929 20:31:04 [ERROR] Failed to initialize the master info structure
070929 20:31:04 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.27'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution
070929 20:49:36 [Note] Slave SQL thread initialized, starting replication in log 'mysql-bin.000001' at position 485, relay log './used-relay-bin.000001' position: 4
070929 20:49:36 [Note] Slave I/O thread: connected to master 'slave_user@',  replication started in log 'mysql-bin.000001' at position 485
070929 20:49:36 [ERROR] Error reading packet from server: Could not find first log file name in binary log index file ( server_errno=1236)
070929 20:49:36 [ERROR] Got fatal error 1236: 'Could not find first log file name in binary log index file' from master when reading data from binary log
070929 20:49:36 [Note] Slave I/O thread exiting, read up to log 'mysql-bin.000001', position 485

Now i try to solve it from here because i have a large database and its difficult
to start it from scratch.

Thank you again for your attention to my problem.
Reply With Quote