через бэкап(innobackup) дамп с мастера, хочу запустить, ошибка - " [ERROR] [MY-013140] [Server] Incorrect prefix key; the used key part isn't a string, the used length is longer than the key part, or the storage engine doesn't support unique prefix keys"
https://dev.mysql.com/doc/refman/8.0/en/upgrade-prerequisites.html - видел. не один запрос из тех что на странице по iS не дает результат. прочел тут https://bugs.mysql.com/bug.php?id=93101
[11 Mar 22:01] Daniel Price
Posted by developer:
The MySQL 8.0 upgrade instructions were updated.
https://dev.mysql.com/doc/refman/8.0/en/upgrade-prerequisites.html
"In-place upgrade to MySQL 8.0 is not supported if tables contain old
temporal columns in pre-5.6.4 format (TIME, DATETIME, and TIMESTAMP
columns without support for fractional seconds precision). If your tables
still use the old temporal column format, upgrade them before attempting
an in-place upgrade to MySQL 8.0. For more information, see Changes in MySQL 5.7."
Changes should appear online soon.
Thank you for the bug report.
как это проверить ?
Я бы вернул на 5.7 прогнал upgrade потом еще раз попробовал
Обсуждают сегодня