MySQL Forums
Forum List  »  Replication

Replication problem after moving servers - simple im sure!
Posted by: Scott Paterson
Date: April 17, 2008 08:34PM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
Replication problem after moving servers - simple im sure!
5479
April 17, 2008 08:34PM


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.