On Fri, May 23, 2008 at 8:13 AM, Ananda Kumar <[EMAIL PROTECTED]> wrote:
> Files is owned by mysql, but the point is, these relay-log files are not > present. > Before setting up the slave, i cleaned up all files. > If you want the logs back you could use RESET MASTER .... maybe. http://dev.mysql.com/doc/refman/5.0/en/reset-master.html Let me know. :-) > > regards > anandkl > > > On 5/23/08, Krishna Chandra Prajapati <[EMAIL PROTECTED]> wrote: > > > > 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] > > >