Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How to open mysql workbench tab which are closed without saving by mistake?

Recently, By mistake i closed mysql workbench tab in which i have written half stored procedure, and i did not saved it,
so is there anyway to reopen unsaved closed tab or recover whatever i have written in that tab. your suggestions appreciated. thanks in advance.

like image 773
yash Avatar asked Aug 24 '16 06:08

yash


People also ask

Does MySQL Workbench auto save?

Save snapshot of open editors on close: By default, MySQL Workbench saves all query tabs and reopens them when you restart it. Use the related Auto-save scripts interval setting to modify its behavior. Both are set from the SQL Editor preferences tab.

How do I restore a workspace in MySQL Workbench?

Right-click on the MySQL Connections pane and select "Open Connection" from the right-click menu. Left click on the MySQL Connections pane as normal. All the old tabs are restored. Important: When you reopen MySQL workbench later this same process may need to be followed.

What to do if MySQL Workbench is not opening?

dll file mostly 'vcruntime140_1' so all you have to do is download and install the missing . dll file and you are good to go. You can try launching MySQL Workbench again and it should work!


1 Answers

You may find your unsaved work in %appdata%\MySQL\Workbench\sql_workspaces\ or perhaps %appdata%\MySQL\Workbench\sql_history\. I hope this helps!

If you use Mac, you probably will find it in ~/Library/Application Support/MySQL/Workbench/sql_history.

To get what you really want, you will need to replace somethings like &quot; by " or &#x0A; by <space>

like image 80
Heiko Ebens Avatar answered Oct 05 '22 00:10

Heiko Ebens