MySQL Forums
Forum List  »  Newbie

Re: Mysql server 5.7 recovery
Posted by: Barry Galbraith
Date: June 22, 2021 12:47AM

Glad you got your database sorted.

Your task now is to establish a backup routine, possibly using Windows Task Scheduler to run a batch file to dump to a file named for the time/date of the backup.
A method is shown here. Customise for your own needs.

You might also investigate turning on binary logging if it isn't already on.
Binary logging allows "point in time" recovery. You can restore changes that were made AFTER the backup was taken.
It's in the fine manual.

Good luck,

Options: ReplyQuote

Written By
Re: Mysql server 5.7 recovery
June 22, 2021 12:47AM

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.