I'm unable to export my 8.0.1 MySQL database using MySQL Workbench 8.0. When I go to perform the export via the "Administration" table, with all the default settings (I didn't change anything anywhere, not even Advanced settings) I run into this error:

09:10:26 Dumping account (all tables)
Running: /Applications/MySQLWorkbench.app/Contents/MacOS/mysqldump --defaults-file="/var/folders/m2/y4sdt3ks3_x206vw2gv37pgc0000gp/T/tmptSYqBY/extraparams.cnf"  --user=root --host=account.biblebowl.org --protocol=tcp --port=4488 --default-character-set=utf8 --no-create-info=TRUE --skip-triggers "account"
mysqldump: Couldn't execute '/*!80000 SET SESSION information_schema_stats_expiry=0 */': Unknown system variable 'information_schema_stats_expiry' (1193)

Operation failed with exitcode 2
09:10:26 Export of /Users/me/dumps/Dump20190207.sql has finished with 1 errors

I could downgrade to a previous version Workbench, but I'd prefer to get this one working and I imagine other folks are going to run into this as well. How can I get around this error and properly export my database?

  • MySQL server version? Commented Feb 7, 2019 at 21:08
  • Server version: 8.0.1
    – Ben
    Commented Feb 7, 2019 at 21:54

1 Answer 1


information_schema_stats_expiry was added in 8.0.3. Use the MySQL Workbench for 8.0.1. I hope you're upgrading to a stable version.

  • 2
    The first 'GA' version is 8.0.11.
    – Rick James
    Commented Feb 8, 2019 at 22:46
  • I've tried using the latest stable. Quite frankly I manage several different MySQL servers on different versions and am frustrated that my version of workbench matters. I don't want to juggle several different versions of workbench depending on the server I'm connecting to. I'm just going to use a different MySQL management tool.
    – Ben
    Commented Feb 13, 2019 at 13:23

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.