重庆思庄Oracle、Redhat认证学习论坛

标题: mysql5.6.40 升级到mysql8.0报错 [打印本页]

作者: 郑全 时间: 2018-7-8 18:18
标题: mysql5.6.40 升级到mysql8.0报错
./bin/mysqld_safe --socket=/data/db/mysql.sock --basedir=/mysql/mysql-5.7.22 --datadir=/data/db/ --log-error=/data/db/mysql-error.log &

直接执行，没有成功，日志中报错了:

more /data/db/mysql-error.log
。。。

018-07-08T09:41:26.506272Z mysqld_safe mysqld from pid file /data/db/dbserver.pid ended
2018-07-08T09:42:27.358324Z mysqld_safe Logging to '/data/db/mysql-error.log'.
2018-07-08T09:42:27.393590Z mysqld_safe Starting mysqld daemon with databases from /data/db
2018-07-08T09:42:27.409257Z 0 [Warning] [MY-010139] [Server] Changed limits: max_open_files: 1024 (requested 8161)
2018-07-08T09:42:27.409444Z 0 [Warning] [MY-010142] [Server] Changed limits: table_open_cache: 431 (requested 4000)
2018-07-08T09:42:27.666498Z 0 [System] [MY-010116] [Server] /mysql/mysql-5.7.22/bin/mysqld (mysqld 8.0.11) starting as process 76163
2018-07-08T09:42:27.773497Z 1 [ERROR] [MY-013090] [InnoDB] InnoDB: Unsupported redo log format (0). The redo log was created before MySQL 5.7.9
2018-07-08T09:42:27.773552Z 1 [ERROR] [MY-012930] [InnoDB] InnoDB: Plugin initialization aborted with error Generic error.
2018-07-08T09:42:28.377597Z 1 [ERROR] [MY-011013] [Server] Failed to initialize DD Storage Engine.
2018-07-08T09:42:28.378527Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2018-07-08T09:42:28.378601Z 0 [ERROR] [MY-010119] [Server] Aborting
2018-07-08T09:42:28.380673Z 0 [System] [MY-010910] [Server] /mysql/mysql-5.7.22/bin/mysqld: Shutdown complete (mysqld 8.0.11) MySQL Community Server - GPL.
2018-07-08T09:42:28.488035Z mysqld_safe mysqld from pid file /data/db/dbserver.pid ended

欢迎光临重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/)