Where did the Mysql story come from in Workbench?

Question

I noticed that workbench has an option called history, which gives all my operations with db per day, I want to know where this comes from, I mean that mysql supports the internal table. I need to update the database every day for my client, so it will be useful to me, please help

Answer 1

If someone still needs it, the history is stored (at least in Windows 7) in UserFolder\AppData\Roaming\MySQL\Workbench\sql_history in separate XML files for each day.

Answer 2

For Mac users, you can find history files in

 /Users/<username>/Library/Application Support/MySQL/Workbench/sql_history 

Although there are only a few dates in the history file stored there (it seems that Workbench is using it for some indexing .... not sure though). If you need the actual query history, you can check the log files for

 /Users/<username>/Library/Application Support/MySQL/Workbench/log/ 

Answer 3

I think that with respect to http://dev.mysql.com/doc/workbench/en/wb-history-palette.html the history of the Workbench is kept from what you are actually doing in the workbench and does not accept this data from the MySQL server .

Is is a query log that you ran in Workbench.

Also, “Like the mysql command-line client utility, MySQL Workbench has a complete history panel that provides a complete session history. This allows the user to easily view, re-run and modify previously executed SQL queries. In addition, several queries can be executed simultaneously, and Results can be viewed in separate tabs, or you can open multiple SQL tabs at the same time.