CODEWITHSUNDEEP
mysqlworkbench
Subo
Subo

Reputation: 37

MySQL workbench workspace restore

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?

Upvotes: 2

Views: 3010

Answers (2)

fatimasajjad
fatimasajjad

Reputation: 601

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

  1. Recovering from HISTORY
  2. Recovering from AUTO SAVE

1 -> HISTORY

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

Extra details here: https://stackoverflow.com/a/26618099/7397820 enter image description here

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:

enter image description here

*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

Upvotes: 0

Rute Lemos
Rute Lemos

Reputation: 191

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

Upvotes: 1

Related Questions