MySQL Forums
Forum List  »  InnoDB

How to make a correct hot physical backup of MySql Innodb database with binary-log activeted
Posted by: Wander Vieira de Rezende
Date: August 08, 2017 07:55AM

Hi everyone,

I'm Oracle DBA and now I'm learning Mysql. I've been read lots of docs about Mysql backup. But I having a doubt about how to make a correct hot physical backup of a MySql Innodb database with binary-log activeted.

Actualy I'd like to understand how to do this. I saw that tables are locked during the process. It seems a bit confuse to me.

Could you help me giving the correct way to make this kind of backup. Also, I will make a test to restore this backup. Then I will use the binary-logs.

I'm using MySQL Community Edition version 5.7 on Oracle linux 64 bits.

kind regards,

Wander(Brazil)

Options: ReplyQuote


Subject
Views
Written By
Posted
How to make a correct hot physical backup of MySql Innodb database with binary-log activeted
112
August 08, 2017 07:55AM


Sorry, only registered users may post in this forum.

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.