Created
September 10, 2019 01:36
-
-
Save micheleberardi/ed1cd82921b735f155c849d3c2c9eee3 to your computer and use it in GitHub Desktop.
upgarde_checker
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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