MySQL workbench workspace restore

Question

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?

that only happens, when it was not closed correctly – nbk Sep 13 '20 at 12:26 — nbk, Sep 13 '20 at 12:26
which os are you using ??? – saurabh kamble Sep 13 '20 at 18:14 — saurabh kamble, Sep 13 '20 at 18:14

score 1 · Accepted Answer · answered Sep 13 '20 at 19:34

1

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

answered Sep 13 '20 at 19:34

Rute Lemos

score 0 · Answer 2 · answered Aug 23 '22 at 19:47

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

2 Answers2