MySQL Forums
Forum List  »  Install & Repo

[MySQL 5.7]cPanel downgrading from MariaDB doed not start
Posted by: Marco Rios
Date: November 13, 2020 06:02AM

Hello,
I just purchased a host subscription that has by default MariaDB and had problems with to restore my data backup, so I tried to DOWNGRADE to MySQL 5.7.
The problem is that I cannot make MySQL to start for the first time (there is no data in this new server), following is an extract of the MySQL log file mysqld.log

2020-11-12T16:21:53.327911Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2020-11-12T16:21:53.328309Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.32) starting as process 25524 ...
2020-11-12T16:21:53.331050Z 0 [Note] InnoDB: PUNCH HOLE support available
2020-11-12T16:21:53.331075Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2020-11-12T16:21:53.331079Z 0 [Note] InnoDB: Uses event mutexes
2020-11-12T16:21:53.331082Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2020-11-12T16:21:53.331085Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-11-12T16:21:53.331089Z 0 [Note] InnoDB: Using Linux native AIO
2020-11-12T16:21:53.331308Z 0 [Note] InnoDB: Number of pools: 1
2020-11-12T16:21:53.331393Z 0 [Note] InnoDB: Using CPU crc32 instructions
2020-11-12T16:21:53.332615Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2020-11-12T16:21:53.338863Z 0 [Note] InnoDB: Completed initialization of buffer pool
2020-11-12T16:21:53.340656Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2020-11-12T16:21:53.353410Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2020-11-12T16:21:53.353574Z 0 [ERROR] InnoDB: Unsupported redo log format. The redo log was created with MariaDB 10.2.33. Please follow the instructions at http://dev.mysql.com/doc/refman/5.7/en/upgrading-downgrading.html
2020-11-12T16:21:53.353587Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2020-11-12T16:21:53.954595Z 0 [ERROR] Plugin 'InnoDB' init function returned error.
2020-11-12T16:21:53.954653Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2020-11-12T16:21:53.954659Z 0 [ERROR] Failed to initialize builtin plugins.
2020-11-12T16:21:53.954662Z 0 [ERROR] Aborting

2020-11-12T16:21:53.954719Z 0 [Note] Binlog end
2020-11-12T16:21:53.954807Z 0 [Note] Shutting down plugin 'CSV'
2020-11-12T16:21:53.955126Z 0 [Note] /usr/sbin/mysqld: Shutdown complete

How can I fix this problem?
Any help would be appreciated.

Thanks in advance for your valuable help.

Acer LENOVO G450
CPU: Pentium(R) Dual-Core CPU T4400 @ 2.20GHz × 2
RAM: 4GB
Graphics: Intel GM45
OS: UBUNTU 18.04.4 LTS 64bits
GNOME 3.28.2
--
Best regards
Marco
Mexico City, Mexico

Options: ReplyQuote


Subject
Written By
Posted
[MySQL 5.7]cPanel downgrading from MariaDB doed not start
November 13, 2020 06:02AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.