MySQL workbench workspace restore

Asked 13/9, 2020 at 12:21 Answered 23/8, 2022 at 19:47

EVerytime i open my sql workbench, it never restores my workspace ,I always get an error

could not read contents of C/USer...

How can i make this stop?

Hazy answered 13/9, 2020 at 12:21 Comment(3)

that only happens, when it was not closed correctly – Monotheism 13/9, 2020 at 12:26

which os are you using ??? – Pytlik 13/9, 2020 at 18:14

I use Windows 10 – Hazy 14/9, 2020 at 18:42

To avoid this in the future, close the workbench then delete all data and directories here:

    C:\Users\your_username\AppData\Roaming\MySQL\Workbench\sql_workspaces

Bellina answered 13/9, 2020 at 19:34 Comment(0)

While the workspace auto restore might not be possible, following are the options to restore your executed queries in MySQL Workbench:

1 -> HISTORY

All the query execution history of each day is maintained in by the workbench:

2 -> Recovering from AUTOSAVE

C:\Users\DELL\AppData\Roaming\MySQL\Workbench\log\sql_actions_unconnected.log

You can find the list of all executed queries in past and their results in sql_actions_unconnected.log

Example:

*IMPORTANT NOTE!: Don't forget to remove the contents of the following directory:

C:\Users\{{USERNAME*\AppData\Roaming\MySQL\Workbench\sql_workspaces

Deleting this will only help to avoid problems in future not restore the existing workspace according to https://superuser.com/questions/981333/mysql-workbench-unable-to-restore-workspace/1007793#1007793

Calchas answered 23/8, 2022 at 19:47 Comment(0)