how to upgrade mysql56-server to mysql57-server?

Mike Clarke jmc-freebsd2 at milibyte.co.uk
Wed Jul 17 09:06:28 UTC 2019


On Wednesday, 17 July 2019 05:06:50 BST tech-lists wrote:

> [1] this was partially fixed by doing ls -lh on /var/db/mysql/ibdata1
> (my file was 78MB) and then looking for the innodb_data_file_path =
> setting in /usr/local/etc/mysql/my.cnf and setting it like this: 
> ibdata1:76M:autoextend at least then it would start. However, running
> mysql_check reported errors when it got to the databases. Some innodb
> tables aren't being read, and I don't know how to fix these.

You need to run mysql_upgrade and then restart the mysql server

-- 
Mike Clarke


More information about the freebsd-questions mailing list