← Back to team overview

maria-discuss team mailing list archive

Re: Change from MySQL to MariaDB - Problem with EVENTS-Table in information_schema


Am 20.12.2013 14:25, schrieb Frank Röhm:
>> You are right, I did the mysql_upgrade only the next day after I noticed
>> this issue and after a research about it.
>> What can I do now?
>> Can I play back the information_schema db or ist this not a solution?

i would make a backup of the datadir, delete the database and use
"mysql_upgrade --force" after that because this database don't contain
any persistent data and should be automatically created

before using that big hammer try "mysql_upgrade -u root -p --force"
and restart the service after that, maybe that's enough

> And when I had done a mysql_upgrade command the next day, I got this:
> This installation of MySQL is already upgraded to 5.5.34-MariaDB, use
> --force if you still need to run mysql_upgrade
> I guess that means, that this command was already done by the installer (aptitude)

maybe, my systems are secured and have no implicit users or unrestricted
ones because i strictly avoid that anything but me makes admin tasks

> Anyway I haven't read in any of the many MySQL to MariaDB
> Upgrade documentations that this command is needed.

that is a basic task for MySQL admins long before MariaDB existed at all

> Could it be an incompatibility?

no, i migrated a lot of instances from MySQL to MariaDB

Attachment: signature.asc
Description: OpenPGP digital signature

Follow ups