Date: Wed, 17 Jul 2019 14:07:24 +0100 From: tech-lists <tech-lists@zyxst.net> To: freebsd-questions@freebsd.org Subject: Re: how to upgrade mysql56-server to mysql57-server? Message-ID: <20190717130724.GA56923@mon.zyxst.net> In-Reply-To: <1569215.MsCH1bHPGx@curlew> References: <20190717040650.GA55947@mon.zyxst.net> <1569215.MsCH1bHPGx@curlew>
next in thread | previous in thread | raw e-mail | index | archive | help
--CE+1k2dSO48ffgeK Content-Type: text/plain; charset=us-ascii; format=flowed Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Wed, Jul 17, 2019 at 10:06:04AM +0100, Mike Clarke wrote: >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 =3D >> 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 Sorry, I meant mysql_upgrade. Like this: # mysql_upgrade root@localhost -p Enter password:=20 Checking if update is needed. Checking server version. Running queries to upgrade MySQL server. Checking system database. mysql.columns_priv OK mysql.db OK [...] lots of this, ends here: mysql.user OK Upgrading the sys schema. Checking databases. Error occurred: Error during call to mysql_check. This still happens even if the process is repeated. The only difference in output: mysql.user OK The sys schema is already up to date (version 1.5.1). Checking databases. Error occurred: Error during call to mysql_check. [...] So it seems mysql_upgrade invokes mysql_check. Nothing usable in the error log; I can't see which tables are malfunctioning. The way I can tell is indirectly, when the=20 mysqld-enabled site loads, there is missing information. --=20 J. --CE+1k2dSO48ffgeK Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCAAdFiEE8n3tWhxW11Ccvv9/s8o7QhFzNAUFAl0vHYIACgkQs8o7QhFz NAUpYQ//TelZlrL+cQB5cUJyMiSB2b00rm/S5PqoksZTi6D537BJZjA7mr9HhBrX pqi/enxmhaf94NCtIeyjtFaWQxrtlwzxL8igq5fggeOOW7VTL8sNyUgCoIcZcsba PBchz+mqRCAegHTWtngHZl8sbau0jQUGl/4LJUauiRkfoLT4zSNo2SSe60ZualTs zp1vf3uKKBo6k/Z4SceuW3ZcPyO+Fwb9LT9EALKw5hnVEPiiIY+3kAnQHQhRW1JB csaCeEdZ860qozg389iHwft3zC/KHqKpjaMUOhanGQCJZdZ2h/ds5m5ej5ZRuAHP uykdgAb9WB2p6UctToK7/oH5Ppt2c+BDUfu7TSnZYKHha69Z2TtQjMhZeJo/ZDe6 tuWP4GSSp7oqoTgvV704CSLma4cE2ScgG71f2VD81Vde/BBFwbaYLOfSFaFys3Hh aQ1aGWZ60p3eahgIRhn9+jTx8uBvG9TelGwvB/cBFSwWtJXox8iwBzORWJzHw6/H VhYg4BqoGzIzEKwalejZnWPZKdu2Y0312UBRI9kb3fZmcvFdHDxSO+ihzjCKH9F0 7Kw/vvVUbFN9XLbFG2rwkzkxzEQ7QczxeJkspO5nMK0LChmqZBjFYYTM109sp9N1 TeOWmDv0eTI589FjdDaG+X3+5M+78qI8jfaEn1zWuI3Exf5Jnow= =He/j -----END PGP SIGNATURE----- --CE+1k2dSO48ffgeK--
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20190717130724.GA56923>