MySQL Workbench saves configuration, cache, and log-related files and directories on your system. These files are saved in a directory assigned to the current user as defined by MySQL Workbench. The following table shows the default file path by platform.
Table 3.1 Default Local Configuration Base File Path
|Operating System||File Path|
The next table provides a brief description of these directories and files.
Table 3.2 Local MySQL Workbench Files and Directory Descriptions
|Directory or File||Description|
||General behaviors are stored per-connection in
||Log files include MySQL Workbench startup information, and also per-connection SQL action results performed in MySQL Workbench.|
||Saved user scripts, modules, and libraries that enables you to extend MySQL Workbench capabilities.|
||Queries executed in MySQL Workbench are stored here, and are available from within MySQL Workbench.|
||Configuration details, such as the tab order or schema tree, are stored here by connection instance.|
||Saved SQL snippets are stored here. For additional information, see Section 8.1.5, “SQL Additions - Snippets Tab”.|
||Cache storage by the Audit Log inspector. For additional information, see Section 6.6, “MySQL Audit Inspector Interface”.|
||Saved MySQL server connection information, as seen on the home screen tab. For information about backing up and restoring this file, see Section 18.104.22.168.7, “The Tools Menu”.|
||Stores your MySQL server information, as it relates to your MySQL connections.|
||Stores your preferences, both configured and default.|
||Stores the previous user-interface state. You can delete this file if you encounter a problem with the MySQL Workbench user interface.|
cache/ directory contains cache files
in the user's
MySQL Workbench directory. All cache files are stored as
SQLite 3 databases, and they are not meant to be edited outside
of MySQL Workbench. The types of cache files are:
These are the saved column widths after adjusting columns in the SQL editor's results grid. The fields include column_id, stored as column_name::db_name::table_name, and width, stored as an integer of character length.
This information (schemas, engines, and other global information) serves as a quick lookup source for the SQL editor's auto completion functionality, and is implicitly updated whenever the schema tree is updated.
All cache/ file names begin with the MySQL connection name. For
example, the column width file is named
Local_instance_3306.column_widths for a
MySQL connection named "Local Instance 3306".
Cached files remain after a connection is either renamed or deleted.
MySQL Workbench start up and SQL actions are logged and stored in
log/ directory. This directory is in
the user's MySQL Workbench
To find these text files, selectfrom the menu.
Debugging information is generated when MySQL Workbench is started and unexpectedly stopped. Information includes paths used, modules and plugins loaded, system information, and more. The log files are useful when reporting a MySQL Workbench bug.
The log files rotates when MySQL Workbench is started, in that
wb.logis renamed to
wb.logis reset, and the previous
wb.1.logfile is renamed to
wb.2.log, and so on, all the way up to
A log of all SQL execution results but without the data, for debugging purposes.
The SQL editor's SQL history does not originate from here, as it is stored in the
Custom user script, module, and library files are stored in the
libraries directories. These user files are
accessible from the file browser in the Workbench Scripting
Shell. For additional information about user scripts, see
Section C.5, “The Workbench Scripting Shell”. For more information about
user modules, see Section C.2, “Modules” and
Section C.3, “Plugins and Tools”.
SQL statements executed in the SQL editor are saved in the
sql_history directory. They are stored as
plain text files that are separated one per day (such as
2015-12-15) and they contain your
MySQL Workbench SQL statement history for all MySQL connections. For
additional information, see
Section 8.1.7, “Output Panel”.
Workspace information is saved to the
sql_workspaces directory by connection
automatically. MySQL Workbench generates a subdirectory that
persists between work sessions for each connection tab that you
open. It uses the name of the connection, appended with a
sequential number, to represent the order of each connection
tab. For example, opening two connection tabs for a connection
Local instance MySQL80 creates two
local_instance_MySQL80-2.autosave. The file
extension changes from
.workspace when you close the connection
SQL snippets used by the SQL editor are stored in the
snippets directory. These files include
bundled snippets (such as "SQL DDL Statements") and custom
snippets saved under the My Snippets tab.
For additional information, see
Section 8.1.5, “SQL Additions - Snippets Tab”.