I just ran an upgrade from MySQL 5.7 to MariaDB 10.3 via WHM v. 88.09 -- and everything went smoothly. Very quick & I've checked all database-driven sites on the server and all seem to be functioning as expected.
However, I am puzzled by this:
During the course of the upgrade, I was given the message:
"MariaDB does not utilize the sys schema. If you upgrade from MySQL 5.7 to MariaDB, you must manually remove the sys database, because it can cause unnecessary errors during certain check table calls."
I assumed that means I am supposed to get rid of the "sys" database -- but when I go to phpMyAdmin and click the link to "Databases" -- the little box to the left of the "sys" database is grayed out -- so I can' simply click the box and drop the database.
So my questions are this:
1. Does "must" mean that it is necessary for me to remove this database? (Or does it just mean that removal is optional, but if I want to remove it, I will have to do it manually)?
2. And if I do need to remove the database, how should I do it? Is that something that can be done via phpMyAdmin, or would I need to use a command-line operation? Or would it work to simply remove the "sys" file from the /var/lib/mysql/ directory?
I don't want to mess things up -- so assuming that I need to take this extra step, I'd like to know the safest and easiest way to do it.
However, I am puzzled by this:
During the course of the upgrade, I was given the message:
"MariaDB does not utilize the sys schema. If you upgrade from MySQL 5.7 to MariaDB, you must manually remove the sys database, because it can cause unnecessary errors during certain check table calls."
I assumed that means I am supposed to get rid of the "sys" database -- but when I go to phpMyAdmin and click the link to "Databases" -- the little box to the left of the "sys" database is grayed out -- so I can' simply click the box and drop the database.
So my questions are this:
1. Does "must" mean that it is necessary for me to remove this database? (Or does it just mean that removal is optional, but if I want to remove it, I will have to do it manually)?
2. And if I do need to remove the database, how should I do it? Is that something that can be done via phpMyAdmin, or would I need to use a command-line operation? Or would it work to simply remove the "sys" file from the /var/lib/mysql/ directory?
I don't want to mess things up -- so assuming that I need to take this extra step, I'd like to know the safest and easiest way to do it.