Please check the ownership of the files copied on the slave. Give permissions by chown -R mysql:mysql
On Fri, May 23, 2008 at 2:47 PM, Ananda Kumar <[EMAIL PROTECTED]> wrote: > Hi Krishna, > As i said, this is a complete copy from master db to slave. > I have deleted all old files from slave and setting up from scratch, by > taking a complete backup from master, copying over to slave and using the > change master command with BIN LOG and POSITION taken before taking a backup > copy from master. > > > > > On 5/23/08, Krishna Chandra Prajapati <[EMAIL PROTECTED]> wrote: >> >> check permissions >> >> On Fri, May 23, 2008 at 12:33 PM, Ananda Kumar <[EMAIL PROTECTED]> wrote: >> >>> Hi All, >>> I shutdown my master, took a db files backup. Copied it over to slave >>> machine. >>> I executed "change master" command, then when i start slave "slave >>> start", i >>> get the below error. I did "reset slave", but still getting same error, >>> what >>> could be the reason, and how to fix it. >>> >>> 080522 23:04:05 [ERROR] Failed to open log (file >>> '/data/mysql-log/relay-log/relay.000791', errno 2) >>> 080522 23:04:05 [ERROR] Failed to open the relay log 'FIRST' >>> (relay_log_pos >>> 4) >>> >>> I am using mysql 5.0.41 community version, on debain. >>> >>> regards >>> anandkl >>> >> >> >> >> -- >> Krishna Chandra Prajapati >> MySQL DBA, >> Ed Ventures e-Learning Pvt.Ltd. >> 1-8-303/48/15, Sindhi Colony >> P.G.Road, Secunderabad. >> Pin Code: 500003 >> Office Number: 040-66489771 >> Mob: 9912924044 >> URL: ed-ventures-online.com >> Email-id: [EMAIL PROTECTED] > > > -- Krishna Chandra Prajapati MySQL DBA, Ed Ventures e-Learning Pvt.Ltd. 1-8-303/48/15, Sindhi Colony P.G.Road, Secunderabad. Pin Code: 500003 Office Number: 040-66489771 Mob: 9912924044 URL: ed-ventures-online.com Email-id: [EMAIL PROTECTED]
