Page 1 of 1

Cannot start MySql when upgrading from version 5.5.55 to 5.6

Posted: 2019/06/13 02:31:15
by Scorpio
Earlier, I attempting to upgrade my MySQL using the SSH Client 'PuTTY'. I was looking to upgrade from MySQL 5.5.55 to MySQL 5.6.

Not having performed such an update before, I carefully following this article on the Plesk website:

https://support.plesk.com/hc/en-us/arti ... -on-Linux-

Where I headed to the 'Plesk on CentOS 6' Tab and managed to get as far as step 10.

As per the step, I then tried to start the MySQL. Unfortunately, this did not work; where I received the following message:

Code: Select all

MySQL Daemon failed to start
Starting mysqld: [FAILED]​
I have checked a variety of questions, on this forum, as well as other online resources. Unfortunately, nothing seems to be helping me. Maybe I am overlooking something.

Here is the latest MySQL Log:

[System] [MY-011012] [Server] Starting upgrade of data directory.
[ERROR] [MY-013090] [InnoDB] Unsupported redo log format (0). The redo log was created before MySQL 5.7.9
[ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Generic error.
[ERROR] [MY-011013] [Server] Failed to initialize DD Storage Engine.
[ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
[ERROR] [MY-010119] [Server] Aborting
[System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.16) MySQL Community Server - GPL.
[Warning] [MY-011070] [Server] 'Disabling symbolic links using --skip-symbolic-links (or equivalent) is the default. Consider not using this option as it' is deprecated and will be removed in a future release.
[System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.16) starting as process 4283
[System] [MY-011012] [Server] Starting upgrade of data directory.
[ERROR] [MY-013090] [InnoDB] Unsupported redo log format (0). The redo log was created before MySQL 5.7.9
[ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Generic error.
[ERROR] [MY-011013] [Server] Failed to initialize DD Storage Engine.
[ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
[ERROR] [MY-010119] [Server] Aborting
[System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.16) MySQL Community Server - GPL.
[Warning] [MY-011070] [Server] 'Disabling symbolic links using --skip-symbolic-links (or equivalent) is the default. Consider not using this option as it' is deprecated and will be removed in a future release.
[System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.16) starting as process 4608
[System] [MY-011012] [Server] Starting upgrade of data directory.
[ERROR] [MY-013090] [InnoDB] Unsupported redo log format (0). The redo log was created before MySQL 5.7.9
[ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Generic error.
[ERROR] [MY-011013] [Server] Failed to initialize DD Storage Engine.
[ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
[ERROR] [MY-010119] [Server] Aborting
[System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.16) MySQL Community Server - GPL.
[Warning] [MY-011070] [Server] 'Disabling symbolic links using --skip-symbolic-links (or equivalent) is the default. Consider not using this option as it' is deprecated and will be removed in a future release.
[System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.16) starting as process 4939
[System] [MY-011012] [Server] Starting upgrade of data directory.
[ERROR] [MY-013090] [InnoDB] Unsupported redo log format (0). The redo log was created before MySQL 5.7.9
[ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Generic error.
[ERROR] [MY-011013] [Server] Failed to initialize DD Storage Engine.
[ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
[ERROR] [MY-010119] [Server] Aborting
[System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.16) MySQL Community Server - GPL.

Re: Cannot start MySql when upgrading from version 5.5.55 to 5.6

Posted: 2019/06/13 06:20:04
by TrevorH
Unfortunately, we only support what we ship and for CentOS 6, we ship mysql 5.1.73 not 5.5 nor 5.6 and definitely not the 8.0 that you appear to be running. You'll need to ask in a mysql forum for support.

Re: Cannot start MySql when upgrading from version 5.5.55 to 5.6

Posted: 2019/06/16 19:28:58
by aks