Skip to content

Instantly share code, notes, and snippets.

@micheleberardi
Created September 10, 2019 01:36
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save micheleberardi/ed1cd82921b735f155c849d3c2c9eee3 to your computer and use it in GitHub Desktop.
Save micheleberardi/ed1cd82921b735f155c849d3c2c9eee3 to your computer and use it in GitHub Desktop.
upgarde_checker
michelone@bd01$ ./mysqlsh root:@localhost:3307 -e "util.checkForServerUpgrade();"
mysqlsh: [Warning] Using a password on the command line interface can be insecure.
The MySQL server at localhost:3307 will now be checked for compatibility issues for upgrade to MySQL 8.0...
MySQL version: 5.7.24 - Source distribution
1) Usage of db objects with names conflicting with reserved keywords in 8.0
No issues found
2) Usage of utf8mb3 charset
No issues found
3) Usage of use ZEROFILL/display length type attributes
No issues found
4) Issues reported by 'check table x for upgrade' command
No issues found
5) Table names in the mysql schema conflicting with new tables in 8.0
No issues found
6) Usage of old temporal type
No issues found
7) Foreign key constraint names longer than 64 characters
No issues found
No known compatibility errors or issues for upgrading the target server to MySQL 8 were found.
michelone@bd01$
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment