1. [root@thinkmake thinkmake]# mysql-workbench --version
  2. MySQL Workbench CE (GPL) 6.2.5 0 build 397
  4. Starting...
  5. Connect to source DBMS...
  6. - Connecting...
  7. Connecting to Mysql@localhost:3306...
  8. Connected to Mysql@localhost:3306, 10.0.17-MariaDB-log
  9. Connect to source DBMS done
  10. Reverse engineer selected schemas....
  11. Reverse engineering mysql from def
  12. - Preparing...
  13. - Preparing...
  14. Reverse engineering tables from mysql
  15. - Retrieving table mysql.column_stats...
  16. - Reverse engineering mysql.column_stats...
  17. - Parsing MySQL SQL Script...
  18. ERROR: Line 8: SQL syntax error near 'decimal(12,4) DEFAULT NULL,
  19. `avg_length` decimal(12,4) DEFAULT NULL,
  20. `avg_fr'. Statement skipped.
  21. - Creating foreign key references...
  22. - Finished parsing MySQL SQL script.
  23. - Retrieving table mysql.columns_priv...
  24. - Reverse engineering mysql.columns_priv...
  25. - Parsing MySQL SQL Script...
  26. ERROR: Line 8: SQL syntax error near 'timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  27. `Col'. Statement skipped.
  28. - Creating foreign key references...
  29. - Finished parsing MySQL SQL script.
  30. - Retrieving table mysql.db...
  31. - Reverse engineering mysql.db...
  32. - Parsing MySQL SQL Script...
  33. - Processing object: db
  34. - Creating foreign key references...
  35. - Finished parsing MySQL SQL script.
  36. - Retrieving table mysql.event...
  37. - Reverse engineering mysql.event...
  38. - Parsing MySQL SQL Script...
  39. ERROR: Line 7: SQL syntax error near 'datetime DEFAULT NULL,
  40. `interval_value` int(11) DEFAULT NULL,
  41. `interval_fiel'. Statement skipped.
  42. - Creating foreign key references...
  43. - Finished parsing MySQL SQL script.
  44. - Retrieving table mysql.func...
  45. - Reverse engineering mysql.func...
  46. - Parsing MySQL SQL Script...
  47. ERROR: Line 4: SQL syntax error near 'tinyint(1) NOT NULL DEFAULT '0',
  48. `dl` char(128) COLLATE utf8_bin NOT NULL DEFA'. Statement skipped.
  49. - Creating foreign key references...
  50. - Finished parsing MySQL SQL script.
  51. - Retrieving table mysql.general_log...
  52. - Reverse engineering mysql.general_log...
  53. - Parsing MySQL SQL Script...
  54. ERROR: Line 3: SQL syntax error near 'timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6'. Statement skipped.
  55. - Creating foreign key references...
  56. - Finished parsing MySQL SQL script.
  57. - Retrieving table mysql.gtid_slave_pos...
  58. - Reverse engineering mysql.gtid_slave_pos...
  59. - Parsing MySQL SQL Script...
  60. ERROR: Line 3: SQL syntax error near 'int(10) unsigned NOT NULL,
  61. `sub_id` bigint(20) unsigned NOT NULL,
  62. `server_id'. Statement skipped.
  63. - Creating foreign key references...
  64. - Finished parsing MySQL SQL script.
  65. - Retrieving table mysql.help_category...
  66. - Reverse engineering mysql.help_category...
  67. - Parsing MySQL SQL Script...
  68. ERROR: Line 3: SQL syntax error near 'smallint(5) unsigned NOT NULL,
  69. `name` char(64) NOT NULL,
  70. `parent_category_id'. Statement skipped.
  71. - Creating foreign key references...
  72. - Finished parsing MySQL SQL script.
  73. - Retrieving table mysql.help_keyword...
  74. - Reverse engineering mysql.help_keyword...
  75. - Parsing MySQL SQL Script...
  76. ERROR: Line 3: SQL syntax error near 'int(10) unsigned NOT NULL,
  77. `name` char(64) NOT NULL,
  78. PRIMARY KEY (`help_keyw'. Statement skipped.
  79. - Creating foreign key references...
  80. - Finished parsing MySQL SQL script.
  81. - Retrieving table mysql.help_relation...
  82. - Reverse engineering mysql.help_relation...
  83. - Parsing MySQL SQL Script...
  84. ERROR: Line 3: SQL syntax error near 'int(10) unsigned NOT NULL,
  85. `help_keyword_id` int(10) unsigned NOT NULL,
  86. PRIM'. Statement skipped.
  87. - Creating foreign key references...
  88. - Finished parsing MySQL SQL script.
  89. - Retrieving table mysql.help_topic...
  90. - Reverse engineering mysql.help_topic...
  91. - Parsing MySQL SQL Script...
  92. ERROR: Line 3: SQL syntax error near 'int(10) unsigned NOT NULL,
  93. `name` char(64) NOT NULL,
  94. `help_category_id` smal'. Statement skipped.
  95. - Creating foreign key references...
  96. - Finished parsing MySQL SQL script.
  97. - Retrieving table mysql.host...
  98. - Reverse engineering mysql.host...
  99. - Parsing MySQL SQL Script...
  100. - Processing object: host
  101. - Creating foreign key references...
  102. - Finished parsing MySQL SQL script.
  103. - Retrieving table mysql.index_stats...
  104. - Reverse engineering mysql.index_stats...
  105. - Parsing MySQL SQL Script...
  106. ERROR: Line 6: SQL syntax error near 'int(11) unsigned NOT NULL,
  107. `avg_frequency` decimal(12,4) DEFAULT NULL,
  108. PRIMA'. Statement skipped.
  109. - Creating foreign key references...
  110. - Finished parsing MySQL SQL script.
  111. - Retrieving table mysql.innodb_index_stats...
  112. - Reverse engineering mysql.innodb_index_stats...
  113. - Parsing MySQL SQL Script...
  114. ERROR: Line 6: SQL syntax error near 'timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  115. `sta'. Statement skipped.
  116. - Creating foreign key references...
  117. - Finished parsing MySQL SQL script.
  118. - Retrieving table mysql.innodb_table_stats...
  119. - Reverse engineering mysql.innodb_table_stats...
  120. - Parsing MySQL SQL Script...
  121. ERROR: Line 5: SQL syntax error near 'timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  122. `n_r'. Statement skipped.
  123. - Creating foreign key references...
  124. - Finished parsing MySQL SQL script.
  125. - Retrieving table mysql.plugin...
  126. - Reverse engineering mysql.plugin...
  127. - Parsing MySQL SQL Script...
  128. - Processing object: plugin
  129. - Creating foreign key references...
  130. - Finished parsing MySQL SQL script.
  131. - Retrieving table mysql.proc...
  132. - Reverse engineering mysql.proc...
  133. - Parsing MySQL SQL Script...
  134. ERROR: Line 15: SQL syntax error near 'timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  135. `mod'. Statement skipped.
  136. - Creating foreign key references...
  137. - Finished parsing MySQL SQL script.
  138. - Retrieving table mysql.procs_priv...
  139. - Reverse engineering mysql.procs_priv...
  140. - Parsing MySQL SQL Script...
  141. ERROR: Line 10: SQL syntax error near 'timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  142. PRIM'. Statement skipped.
  143. - Creating foreign key references...
  144. - Finished parsing MySQL SQL script.
  145. - Retrieving table mysql.proxies_priv...
  146. - Reverse engineering mysql.proxies_priv...
  147. - Parsing MySQL SQL Script...
  148. ERROR: Line 7: SQL syntax error near 'tinyint(1) NOT NULL DEFAULT '0',
  149. `Grantor` char(141) COLLATE utf8_bin NOT NULL'. Statement skipped.
  150. - Creating foreign key references...
  151. - Finished parsing MySQL SQL script.
  152. - Retrieving table mysql.roles_mapping...
  153. - Reverse engineering mysql.roles_mapping...
  154. - Parsing MySQL SQL Script...
  155. - Processing object: roles_mapping
  156. - Creating foreign key references...
  157. - Finished parsing MySQL SQL script.
  158. - Retrieving table mysql.servers...
  159. - Reverse engineering mysql.servers...
  160. - Parsing MySQL SQL Script...
  161. ERROR: Line 8: SQL syntax error near 'int(4) NOT NULL DEFAULT '0',
  162. `Socket` char(64) NOT NULL DEFAULT '',
  163. `Wrapper'. Statement skipped.
  164. - Creating foreign key references...
  165. - Finished parsing MySQL SQL script.
  166. - Retrieving table mysql.slow_log...
  167. - Reverse engineering mysql.slow_log...
  168. - Parsing MySQL SQL Script...
  169. ERROR: Line 3: SQL syntax error near 'timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6'. Statement skipped.
  170. - Creating foreign key references...
  171. - Finished parsing MySQL SQL script.
  172. - Retrieving table mysql.table_stats...
  173. - Reverse engineering mysql.table_stats...
  174. - Parsing MySQL SQL Script...
  175. ERROR: Line 5: SQL syntax error near 'bigint(21) unsigned DEFAULT NULL,
  176. PRIMARY KEY (`db_name`,`table_name`)
  177. ) ENGIN'. Statement skipped.
  178. - Creating foreign key references...
  179. - Finished parsing MySQL SQL script.
  180. - Retrieving table mysql.tables_priv...
  181. - Reverse engineering mysql.tables_priv...
  182. - Parsing MySQL SQL Script...
  183. ERROR: Line 8: SQL syntax error near 'timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  184. `Tab'. Statement skipped.
  185. - Creating foreign key references...
  186. - Finished parsing MySQL SQL script.
  187. - Retrieving table mysql.time_zone...
  188. - Reverse engineering mysql.time_zone...
  189. - Parsing MySQL SQL Script...
  190. ERROR: Line 3: SQL syntax error near 'int(10) unsigned NOT NULL AUTO_INCREMENT,
  191. `Use_leap_seconds` enum('Y','N') NOT'. Statement skipped.
  192. - Creating foreign key references...
  193. - Finished parsing MySQL SQL script.
  194. - Retrieving table mysql.time_zone_leap_second...
  195. - Reverse engineering mysql.time_zone_leap_second...
  196. - Parsing MySQL SQL Script...
  197. ERROR: Line 3: SQL syntax error near 'bigint(20) NOT NULL,
  198. `Correction` int(11) NOT NULL,
  199. PRIMARY KEY (`Transition'. Statement skipped.
  200. - Creating foreign key references...
  201. - Finished parsing MySQL SQL script.
  202. - Retrieving table mysql.time_zone_name...
  203. - Reverse engineering mysql.time_zone_name...
  204. - Parsing MySQL SQL Script...
  205. ERROR: Line 4: SQL syntax error near 'int(10) unsigned NOT NULL,
  206. PRIMARY KEY (`Name`)
  207. ) ENGINE=MyISAM DEFAULT CHARSE'. Statement skipped.
  208. - Creating foreign key references...
  209. - Finished parsing MySQL SQL script.
  210. - Retrieving table mysql.time_zone_transition...
  211. - Reverse engineering mysql.time_zone_transition...
  212. - Parsing MySQL SQL Script...
  213. ERROR: Line 3: SQL syntax error near 'int(10) unsigned NOT NULL,
  214. `Transition_time` bigint(20) NOT NULL,
  215. `Transitio'. Statement skipped.
  216. - Creating foreign key references...
  217. - Finished parsing MySQL SQL script.
  218. - Retrieving table mysql.time_zone_transition_type...
  219. - Reverse engineering mysql.time_zone_transition_type...
  220. - Parsing MySQL SQL Script...
  221. ERROR: Line 3: SQL syntax error near 'int(10) unsigned NOT NULL,
  222. `Transition_type_id` int(10) unsigned NOT NULL,
  223. `'. Statement skipped.
  224. - Creating foreign key references...
  225. - Finished parsing MySQL SQL script.
  226. - Retrieving table mysql.user...
  227. - Reverse engineering mysql.user...
  228. - Parsing MySQL SQL Script...
  229. ERROR: Line 39: SQL syntax error near 'int(11) unsigned NOT NULL DEFAULT '0',
  230. `max_updates` int(11) unsigned NOT NULL'. Statement skipped.
  231. - Creating foreign key references...
  232. - Finished parsing MySQL SQL script.
  233. Reverse engineering triggers from mysql
  234. Reverse engineering stored procedures from mysql
  235. Reverse engineering functions from mysql
  236. - Reverse engineered 30 objects
  237. Reverse engineer selected schemas finished
  238. Post-processing of reverse engineered schemas...
  239. Post-processing of reverse engineered schemas done
  240. Tasks finished with warnings and/or errors, view the logs for details
  241. Finished performing tasks.