MySQL Forums
Forum List  »  Newbie

Re: MySQL 5.7 database files
Posted by: Barry Galbraith
Date: September 14, 2021 04:42PM

An image, and a database backup are two subtley different things.
When MySQL is busy, it can hold data in ram (for faster access) and then write to disk "later".
Your disk image will only capture what's on disk, and miss the data held in ram. Mysqldump can capture all of your database.
And what about database changes since your disk image? Using binary logging, along with mysqldump can do point in time recovery, right up to the last change to your database before the failure.
Image your volume by all means, but if you you want a database backup then you need to backup ALL of your database.

Good luck,
Barry.

Options: ReplyQuote


Subject
Written By
Posted
September 13, 2021 06:18PM
September 13, 2021 07:04PM
September 14, 2021 04:44PM
September 14, 2021 07:56PM
September 14, 2021 01:28AM
September 14, 2021 04:16PM
Re: MySQL 5.7 database files
September 14, 2021 04:42PM
September 14, 2021 04:57PM


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.