Replication problem after moving servers - simple im sure!
Hello,
I've moved replication from a windows server to a linux server and appear to be having a problem with relay-bin logs.
It's weird - I had it working under my test box no problems but I must have done somthing differently but can't figure it out.
The file in ./eris-relay-bin.081000 is actually there! I can see it..
Permissions have been set for the mysql user the same as the other files, so I don't think it's a permission problem. There MAY have been a permissions problem earlier and it seems like mysql somehow now thinks it's looking for file 081001 even though the relay.info and relay-bin files state to use .080000
Apr 18 14:16:20 eris mysqld[7463]: 080418 14:16:20 [ERROR] /usr/sbin/mysqld: File './eris-relay-bin.081001' not found (Errcode: 13)
Apr 18 14:16:20 eris mysqld[7463]: 080418 14:16:20 [ERROR] Could not use eris-relay-bin for logging (error 13). Turning logging off for the whole duration of$
Apr 18 14:16:20 eris mysqld[7463]: 080418 14:16:20 [ERROR] Failed in open_log() called from init_relay_log_info()
Apr 18 14:16:20 eris mysqld[7463]: 080418 14:16:20 [ERROR] Failed to initialize the master info structure
Below are the contents of my relay-log.info and eris-relay-bin.index
relay-log.info contents:
./eris-relay-bin.081000
71271375
sun-bin.000173
139085346
eris-replay-bin.index contents:
./eris-relay-bin.081000
Subject
Views
Written By
Posted
Replication problem after moving servers - simple im sure!
5584
April 17, 2008 08:34PM
2337
April 17, 2008 08:37PM
2529
April 17, 2008 08:51PM
2077
April 17, 2008 11:30PM
Sorry, you can't reply to this topic. It has been closed.
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.