Date: Wed, 17 Jul 2019 10:06:04 +0100 From: Mike Clarke <jmc-freebsd2@milibyte.co.uk> To: freebsd-questions@freebsd.org Cc: tech-lists <tech-lists@zyxst.net> Subject: Re: how to upgrade mysql56-server to mysql57-server? Message-ID: <1569215.MsCH1bHPGx@curlew> In-Reply-To: <20190717040650.GA55947@mon.zyxst.net> References: <20190717040650.GA55947@mon.zyxst.net>
next in thread | previous in thread | raw e-mail | index | archive | help
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
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?1569215.MsCH1bHPGx>