MySQL Workbench Database Export Error

• MySQL Workbench Database Export Error

MySQL Workbench Database Export Error

MySQL Workbench Database Export Error “Unknown table column statistics in information schema 1109”.

Steps to fix error

1. Navigate to C:\Program Files\MySQL\MySQL Workbench 8.0 CE\modules

2. Edit the file wb_admin_export.py (you need admin permissions for this)

3. Update the following line of code:

   • skip_column_statistics = True if get_mysqldump_version() > Version(8, 0, 2) and self.owner.ctrl_be.target_version < Version(8, 0, 0) else False

   to

   skip_column_statistics = True

4. Restart MySQL Workbench (otherwise it not work again)

5. Perform the export (Export done)