Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

mysqldump 8.0 does not work #10804

Closed
SunRunAway opened this issue Jun 13, 2019 · 1 comment · Fixed by #10829
Closed

mysqldump 8.0 does not work #10804

SunRunAway opened this issue Jun 13, 2019 · 1 comment · Fixed by #10829
Labels
good first issue Denotes an issue ready for a new contributor, according to the "help wanted" guidelines. help wanted Denotes an issue that needs help from a contributor. Must meet "help wanted" guidelines. type/compatibility
Projects
MySQL 8.0 Compatibility

Comments

@SunRunAway
Copy link
Contributor

Bug Report

Please answer these questions before submitting your issue. Thanks!

  1. What did you do?
    If possible, provide a recipe for reproducing the error.
/usr/local/Cellar/mysql/8.0.15/bin/mysqldump -h127.0.0.1 -P4000 -uroot test
  1. What did you expect to see?

dump result.

  1. What did you see instead?
mysqldump: Couldn't execute '/*!80000 SET SESSION information_schema_stats_expiry=0 */': Unknown system variable 'information_schema_stats_expiry' (1193)
  1. What version of TiDB are you using (tidb-server -V or run select tidb_version(); on TiDB)?
@morgo
Copy link
Contributor

morgo commented Jun 15, 2019

The variable information_schema_stats_expiry relates to the new data dictionary in 8.0.

I suggest that we add it to TiDB with the same default value (86400), but make it essentially a noop.

@morgo morgo added type/compatibility good first issue Denotes an issue ready for a new contributor, according to the "help wanted" guidelines. help wanted Denotes an issue that needs help from a contributor. Must meet "help wanted" guidelines. labels Jun 15, 2019
@morgo morgo added this to To do in MySQL 8.0 Compatibility via automation Jun 16, 2019
This was referenced Jun 17, 2019
Merged
Merged
MySQL 8.0 Compatibility automation moved this from To do to Done Jun 26, 2019
@zz-jason zz-jason moved this from Done to DONE in MySQL 8.0 Compatibility Apr 21, 2021
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
good first issue Denotes an issue ready for a new contributor, according to the "help wanted" guidelines. help wanted Denotes an issue that needs help from a contributor. Must meet "help wanted" guidelines. type/compatibility
Projects
No open projects
MySQL 8.0 Compatibility
  
DONE
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

infoschema, sessionctx: add support for mysqldump from 8.0
2 participants
@morgo @SunRunAway