Cant switch from MariaDB 10.2 to MySQL5.6

Phuturist

Verified User
Joined
Dec 30, 2018
Messages
28
I'm trying to switch from MariaDB 10 to MySQL 5.6 (run into issues restoring a Magento 2.2 database). Did all the necessary steps but the switch fails with the following log. How can I fix this and get MySQL 5.6 up and running (a clean install will be fine as well).

Code:
This is a brief description of the upgrade process.  Important details
can be found in the MySQL manual, in the Upgrading section.
******************************************************************
error: %pre(MySQL-server-5.6.42-1.el6.x86_64) scriptlet failed, exit status 1
error: MySQL-server-5.6.42-1.el6.x86_64: install failed
   2:MySQL-devel-5.6.42-1.el6         ################################# [ 50%]
   3:MySQL-client-5.6.42-1.el6        ################################# [ 75%]
Ensuring local-infile is disabled for security reasons in MySQL configuration file...
Giving mysqld a few seconds to start up...
Phase 1/7: Checking and upgrading mysql database
# Connecting to localhost...
# Disconnecting from localhost...
mysql.columns_priv                                 OK
mysql.db                                           OK
mysql.event                                        OK
mysql.func                                         OK
mysql.general_log                                  OK
mysql.help_category                                OK
mysql.help_keyword                                 OK
mysql.help_relation                                OK
mysql.help_topic                                   OK
mysql.host                                         OK
mysql.ndb_binlog_index                             OK
mysql.plugin                                       OK
mysql.proc                                         OK
mysql.procs_priv                                   OK
mysql.proxies_priv                                 OK
mysql.servers                                      OK
mysql.slow_log                                     OK
mysql.tables_priv                                  OK
mysql.time_zone                                    OK
mysql.time_zone_leap_second                        OK
mysql.time_zone_name                               OK
mysql.time_zone_transition                         OK
mysql.time_zone_transition_type                    OK
mysql.user                                         OK
Upgrading from a version before MariaDB-10.1
Phase 2/7: Installing used storage engines
Checking for tables with unknown storage engine
Phase 3/7: Fixing views
/usr/bin/mysqlcheck: unknown variable 'process-views=YES'
FATAL ERROR: Upgrade failed
cp: '/usr/lib/libmysqlclient.so' and '/usr/lib/mysql/libmysqlclient.so' are the same file
cp: '/usr/lib/libmysqlclient.so.18' and '/usr/lib/mysql/libmysqlclient.so.18' are the same file
Restarting MySQL.
 
MySQL 5.6 is a downgrade, MySQL/MariaDB cannot be simply downgraded. What errors did you run into? I'm almost sure they are sql mode related (meaning a simple fix) :)
 
The error is in the supplied log:

Code:
/usr/bin/mysqlcheck: unknown variable 'process-views=YES'
FATAL ERROR: Upgrade failed

I just followed the instructions here https://help.directadmin.com/item.php?id=563 but this still results in restoring MariaDB while I really need to get back to MySQL 5.6.
 
I was asking for magento error with MariaDB 10.2 :) Was there any?
 
Oh right ... :)

Yes, when importing the database I suffered from the issue as described here: https://github.com/magento/magento2/issues/19542

Looking at the table in question in the source MySQL server (running MySQL5.6) it seems it has no partitioning or primary key configured. And maybe the backup function from Magento screw things up.
 
Hmmm, yes. Using mysqldump to create a backup and restoring this on MariaDB 10 worked. I guess the Magento 2 database backup functionality is a bit borked.
 
Back
Top