• Registered: 2016-02-23
  • Posts: 2

Topic: Switching from Remi's 5.5 MySQL to 'standard' 5.7

I had a server that was running '5.5.44 MySQL Community Server (GPL) by Remi' (which I did not realize). I installed the standard mysql (with yum install mysql-devel) and the sever crashed. It will not come up now - it fails with this:

Fatal error: mysql.user table is damaged. Please run mysql_upgrade

How can I run mysql_upgrade if I can't start the server?

I need to get this server back up ASAP. What can I do? Can anyone help?

  • Remi
  • Remi
  • Administrateur
  • Offline
  • From: Champagne...
  • Registered: 2009-04-28
  • Posts: 3,834

Re: Switching from Remi's 5.5 MySQL to 'standard' 5.7

Sorry, but the only solution I see is logical dump from old version (mysqldump > file) and import in the new version (mysql < file).

Laptop:  Fedora 38 + rpmfusion + remi (SCL only)
x86_64 builder: Fedora 39 + rpmfusion + remi-test
aarch64 builder: RHEL 9 with EPEL
Hosting Server: CentOS 8 Stream with EPEL, rpmfusion, remi

Remi's Website

  • Registered: 2016-02-23
  • Posts: 2

Re: Switching from Remi's 5.5 MySQL to 'standard' 5.7

Thanks, that worked. Hopefully nothing was dependent on your MySQL or PHP and nothing will break.

  • Remi
  • Remi
  • Administrateur
  • Offline
  • From: Champagne...
  • Registered: 2009-04-28
  • Posts: 3,834

Re: Switching from Remi's 5.5 MySQL to 'standard' 5.7

> Thanks, that worked.
smile

Laptop:  Fedora 38 + rpmfusion + remi (SCL only)
x86_64 builder: Fedora 39 + rpmfusion + remi-test
aarch64 builder: RHEL 9 with EPEL
Hosting Server: CentOS 8 Stream with EPEL, rpmfusion, remi

Remi's Website