After you stop the slave and start mysqldump, execute the below on slave db. show slave status\G.
Note down the Master_Log_File and Exec_Master_Log_Pos. This will be the point from which you need to do the recovery. regards anandkl On 9/25/07, Eric Frazier <[EMAIL PROTECTED]> wrote: > > Boyd Hemphill wrote: > > I have executed a strategy for backup where I stop a slave and do a > mysqldump with --master-data. Both master and slave are 4.1.20 > > > > My assumption was that the log coordinates in the dump file would > provide me with the place to replay the log for a point in time recovery. > > > > What I learned today however is that it appears the binary log only > captures statements run directly on the slave. Any SQL run by the SQL > thread of replication seems only to go in the relay log. This effectively > renders the --master-data useless for my purpose. > > > > So, I have two questions. > > 1. Can someone verify that the binary log on the slave is not capturing > SQL from the replication SQL thread. > > > > It sounds like you need --log-slave-updates > > http://dev.mysql.com/doc/refman/5.0/en/replication-options.html > > 2. If the above is really true, what strategies are you using to backup > InnoDB without InnoDB hot backup? > > > > Thanks for your time! > > > > Peace > > Boyd > > > > > > > > > > > > > > > > CONFIDENTIALITY NOTICE: This email & attached documents may contain > confidential information. All information is intended only for the use of > the named recipient. If you are not the named recipient, you are not > authorized to read, disclose, copy, distribute or take any action in > reliance on the information and any action other than immediate delivery to > the named recipient is strictly prohibited. If you have received this email > in error, do not read the information and please immediately notify sender > by telephone to arrange for a return of the original documents. If you are > the named recipient you are not authorized to reveal any of this information > to any other unauthorized person. If you did not receive all pages listed or > if pages are not legible, please immediately notify sender by phone. > > > > > > > > > > > > > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > >
