Description:
----[For better reports, please attach the log file after submitting. You can find it in /home/lewis/.mysql/workbench/log/wb.log]
23:35:29 [INF][ WBContext]: Parsing application arguments.
23:35:29 [INF][ WBContext]: /usr/lib/mysql-workbench/mysql-workbench-bin
23:35:29 [INF][ WBContext UI]: Initializing workbench context UI with these values:
base dir: /usr/share/mysql-workbench
plugin path: /usr/lib/mysql-workbench/plugins
struct path: /usr/share/mysql-workbench/grt
module path: /usr/lib/mysql-workbench/modules
library path: /usr/share/mysql-workbench/libraries
user data dir: /home/lewis/.mysql/workbench
open at start:
open type:
run at startup:
run type:
Force SW rendering: No
Force OpenGL: No
quit when done: No
23:35:29 [INF][ WBContext]: WbContext::init
23:35:30 [INF][ WBA]: Looking for extension modules for WBA...
23:35:30 [INF][ WBA]: 0 extension modules found
23:35:30 [WRN][ grt]: /usr/share/mysql-workbench/data/table_templates.xml:21: link 'com.mysql.rdbms.mysql.datatype.timestamp' <object db.SimpleDatatype> key=simpleType could not be resolved
23:35:30 [WRN][ grt]: /usr/share/mysql-workbench/data/table_templates.xml:106: link 'com.mysql.rdbms.mysql.datatype.varchar' <object db.SimpleDatatype> key=simpleType could not be resolved
23:35:30 [WRN][ grt]: /usr/share/mysql-workbench/data/table_templates.xml:229: link 'com.mysql.rdbms.mysql.datatype.int' <object db.SimpleDatatype> key=simpleType could not be resolved
23:35:30 [WRN][ grt]: /home/lewis/.mysql/workbench/connections.xml:29: link '8eb54aff-fd97-11e5-9936-485ab6bbc2cb' <object GrtObject> key=owner could not be resolved
23:35:30 [INF][ WBContext]: System info:
MySQL Workbench Community (GPL) for Linux/Unix version 6.3.6 CE build 511 (64 bit)
Configuration Directory: /home/lewis/.mysql/workbench
Data Directory: /usr/share/mysql-workbench
Cairo Version: 1.14.6
OS: Linux 4.4.0-21-generic
CPU: 8x Intel(R) Core(TM) i7-4700MQ CPU @ 2.40GHz (2582.156MHz) - 11.67GiB RAM
Distribution: Ubuntu 16.04 LTS
Fips mode enabled: no
23:35:32 [INF][ SSH tunnel]: Starting tunnel
23:35:32 [INF][ SSH tunnel]: Existing SSH tunnel not found, opening new one
23:35:32 [INF][ SSH tunnel]: Opening SSH tunnel to erp.ju-ju-be.com
23:35:34 [INF][ SSH tunnel]: TunnelManager.wait_connection returned OK
23:35:34 [INF][sshtunnel.py:set_keepalive:502]: SSH KeepAlive setting skipped.
23:35:34 [INF][ SSH tunnel]: SSH tunnel connect executed OK
23:35:37 [INF][ SqlEditor]: Opened connection 'ERP JJB USA' to Percona Server (GPL), Release rel35.0, Revision 657 version 5.5.37-35.0
23:35:37 [INF][ AutoCCache]: Initializing autocompletion cache for ERP_JJB_USA
23:35:42 [INF][ SSH tunnel]: Existing SSH tunnel found, connecting
23:35:44 [INF][wb_admin_control.py:query_server_info:690]: WbAdminControl.connect_sql(): The server version stored in the server instance profile was "None". Changed to the version reported by the server: "5.5.37-35.0"
23:35:44 [INF][ SSH tunnel]: Existing SSH tunnel found, connecting
23:35:44 [WRN][ mforms.linux]: Unknown column storage typeUnknown column storage typeMonitoring thread running...
23:36:05 [INF][ SSH tunnel]: Existing SSH tunnel found, connecting
23:39:20 [ERR][wb_admin_main.py:shutdown:217]: shutting down admn
23:39:21 [INF][wb_admin_control.py:server_polling_thread:556]: Monitoring thread done.
23:39:25 [INF][ SSH tunnel]: Existing SSH tunnel found, connecting
23:39:28 [WRN][ mforms.linux]: Unknown column storage typeUnknown column storage typeExisting SSH tunnel found, connecting
23:39:30 [INF][wb_admin_control.py:server_polling_thread:540]: Monitoring thread running...
23:39:58 [INF][ SSH tunnel]: Existing SSH tunnel found, connecting
How to repeat:
Login to a database (I use MySQL over SSH always)
Server->Export...
Select single-file
rename single-file to mnemonic or table name-`date +%Y-%m-%d`.sql
Ensure create table is selected
Click Export
Suggested fix:
Process each table one at a time, or even a few records at a time, so that the UI is updated little and often.