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?
8.0.1
– Webnet Feb 7 at 21:54