From where the Mysql history is coming in Workbench?

Question

i have observed that workbench has an option called history, which is giving all my db operations in day wise, i want to know from where it is getting, i mean is mysql is maintaining any table internally. I need to update the databse everyday to my client so it will be useful to me, Please help

Answer 1

If anyone still needs this 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 the history files at

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

Though the history file stored there only has some dates in it(Seems like Workbench is using it for some indexing.... not sure though). If you need actual history with queries you can check the log files at

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