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