MySQL Bugs: #56718: Need an auto save feature and system recovery feature in case of crash

Bug #56718	Need an auto save feature and system recovery feature in case of crash
Submitted:	10 Sep 2010 16:25	Modified:	12 Oct 2010 15:25
Reporter:	Wade Wendorf	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Workbench: Modeling	Severity:	S1 (Critical)
Version:	5.2.27	OS:	Windows (Windows 7 Home Ultimate)
Assigned to:	Alfredo Kojima	CPU Architecture:	Any
Tags:	system crashing

Description:
I was using 5.2.27 to design a new database for a large project.  I had many tables and relationships built, and the system crashed.  

How to repeat:
unknown

Suggested fix:
This software needs an auto save that can have the minutes adjust as to how often you want it to auto save.  It should also have a project recovery option built in.

I agree that this is important feature to have.

Bug #56957 has been marked as duplicate of this one

fix confirmed in repository.

New option on the preferences page "general" has been added to set a time-interval where Workbench will automatically save the currently open model. Workbench will offer to recover the auto-saved version when  opening a model file that has not been closed properly last time it was opened (e.g. in case of power off or unexpected program termination)

Note for docs: please add the info that for the auto-recovery-feature to take effect on a new file, the user has to save the file once

Main docs updated.

Also, a 'change' entry has been added to the 5.2.29 changelog:

An open model that has not been saved will automatically be saved after this period. On loading a model file, MySQL Workbench will notify the user if the file was not previously saved correctly, due to a crash or power failure. MySQL Workbench can then attempt to recover the last auto-saved version. Note that for automatic recovery to be available for a new file, it will have to have been saved at least once by the user.