MySQL Forums
Forum List  »  Newbie

Backups and Recovery
Posted by: Jose Azevedo
Date: August 29, 2018 12:30AM

Hi, I'm an Oracle DBA so I understand backup and recovery of a database from the Oracle perspective quite well. In Oracle the database is in mount mode whilst it is being recovered so users cannot access the DB whilst a recovery is in progress.

There is however something that I do not fundamentally understand in regard to MySQL Backup/Recovery. Whilst I do a recovery the mysqld daemon is running and anyone can login whilst I do the recovery (with mysqlbinlog). I understand the --skip-networking option so is that the thing to do before I start a recovery? I am looking for something similar to the mount mode in Oracle...

Best regards

Options: ReplyQuote

Written By
Backups and Recovery
August 29, 2018 12:30AM
August 29, 2018 08:31AM
August 29, 2018 04:59PM
August 29, 2018 09:10PM
August 29, 2018 10:12PM

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.