I noticed that my MySQL 4.0.13 Slave Replication server is having a wierd problem. If you look at the master.info file on the slave it keeps updating like it is really updating the slave but in the mysql.err log it shows:
030609 16:12:08 Slave I/O thread: connected to master '[EMAIL PROTECTED]:3306', replication started in log 'io-bin.1964' at position 1930590 ERROR: 1016 Can't open file: 'named.MYI'. (errno: 145) 030609 18:34:13 Slave: error 'Can't open file: 'named.MYI'. (errno: 145)' on query 'update named set registrar='NETWORK SOLUTIONS, INC.', regexpires='2012-06-09', regcreated='', regupdated='2003-02-11', whois='\nWhois Server Version 1.3\n\nDomain names in the .com and .net domains can now be registered\nwith many different competing registrars. Go to http://www.internic.net\nfor detailed information.\n\n Domain Name: HEARTNOTES.COM\n Registrar: NETWORK SOLUTIONS, INC.\n Whois Server: whois.networksolutions.com\n Referral URL: http://www.networksolutions.com\n Name Server: NS1.AROS.NET\nFound name server NS1.AROS.NET\n Name Server: NS2.AROS.NET\nFound name server NS2.AROS.NET\n Status: ACTIVE\n Updated Date: 11-feb-2003\n *** Converted 11-feb-2003 into 2003-02-11.\n Creation Date: 10-jun-1998\n Expiration Date: 09-jun-2012\n *** Converted 09-jun-2012 into 2012-06-09.\n\n\n>>> Last update of whois database: Thu, 29 May 2003 17:56:56 EDT <<<\n\nNOTICE: The expiration date displayed in this record is the date th', error_code=1016 030609 18:34:13 Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopped at log 'io-bin.1896' position 7345847 It complains that it has stopped at position io-bin.1896, position 7345847 but I can't find how to make it just skip to the next record, any help would be appreciated? Devin Atencio -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
