MySQL Forums
Forum List  »  MySQL Administrator

Re: binlog file deleted accidentally
Posted by: Raz Salton
Date: August 15, 2012 05:08PM

Thank you so much for your quick response again.

I like to introduce new tool at this point. I do have downtime window which will allow me to bring down the master server.

if I stop "service mysqld stop" and then do the export from master and import slave then it will work?

otherwise, I will be executing the follwoing:

mysql-master server:
mysql>flush tables with read lock;

mysql-master$ mysqldump --database mydatabase > mydatabasebackup.sql

import to slave:
mysql>stop slave;
mysql-slave$ mysql mydatabase < mydatabasebackup.sql
mysql>start slave;

mysql-master server:

mysql-master server:
mysql>unlock tables;

I hope this will work?

Options: ReplyQuote

Written By
Re: binlog file deleted accidentally
August 15, 2012 05:08PM

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.