MySQL Forums
Forum List  »  MySQL Administrator

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

Hello Scott,

Thanks for your quick response.

Here what I understood:

Fresh backup:
mysql-master$ mysqldump --database mydatabase > mydatabasebackup.sql

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

I am sorry for being very detail. Since I am a new to mysql and need to make sure before I do anything on this production system.

so, I don't not need to restart mysql master service?

Options: ReplyQuote

Written By
Re: binlog file deleted accidentally
August 15, 2012 04:19PM

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.