Date: Wed, 17 Jul 2019 05:06:50 +0100 From: tech-lists <tech-lists@zyxst.net> To: freebsd-questions@freebsd.org Subject: how to upgrade mysql56-server to mysql57-server? Message-ID: <20190717040650.GA55947@mon.zyxst.net>
next in thread | raw e-mail | index | archive | help
--sdtB3X0nJg68CQEu Content-Type: text/plain; charset=us-ascii; format=flowed Content-Disposition: inline Content-Transfer-Encoding: quoted-printable Hi, The default version of mysql/mysqld changed from 5.6 to 5.7 on 20190701.=20 The problem now is that if "pkg upgrade" is run, mysql-client is=20 upgraded and the existing mysql(56)-server is *removed*. mysql57-server is not installed. If mysql57-server is then manually installed with pkg install, when=20 "service mysql-server start" is run, it starts up then exits.=20 This error happens: [ERROR] InnoDB: The Auto-extending innodb_system data file '/var/db/mysql/ibdata1' is of a different size 4864 pages (rounded down to MB) than specified in the .cnf file: initial 4992 pages, max 0 (relevant if non-zero) pages! [1] This happens despite following the instructions in /usr/ports/UPDATING entry dated 20190701 for pkg. Basically, if you have a FAMP system and keep up-to-date with pkg, and you were using mysql56-server, just running pkg upgrade will leave you without any mysql server installed. It seems the only way of keeping mysqld at version 5.6 is to compile ports, which I didn't want to do (don't know if I can do) on this space-limited instance [2] [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:=20 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. [2] unless there is an exclude pattern that can be applied to pkg upgrade --=20 J. --sdtB3X0nJg68CQEu Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCAAdFiEE8n3tWhxW11Ccvv9/s8o7QhFzNAUFAl0untEACgkQs8o7QhFz NAWAXg//XU5mX6rPIb2DGlFn0/mGzEWNusO96E8xC4SBi0iSZ9b8AVUUpgBFmV5z 2wpxsH3vlbs/n0j8a/HbP6hdIR8lKqOWikkU27w/2cQAG6jr4rfK3icJth4BLV46 evH0YRiD/aWzjxsoipAeJeuYxvw0illQj53TYGk6wMRJaZr9Js/Bv82tICaL0Y50 ZtApbl+nv8DwEAYaPmHCyfwuXjjmxQJ8aortz7Y3rg3l4THULJOv3alcg8DMh6So Du3rnipguAI6EmcALfj8RjhoewJtKn8OeqRZgDKYwLxkTsLeemJPHRzvonB410J8 k68wFi8Sbe8/cwEUJL62uDwW5AfbXPBGR18+EzTjyg0cDsc5Cz1UOL0GpowfwF4J 8fMVXKrLSdLMQv3Hj6VEucroYeAfSBIpG53xuvzjPnrP34CXOZPQFM9tiLLeYqWs e+6UDDcI4iacGMzKygSqgmsvsSd3/pQFKItiBO7e6vB54m2O1A/mbUckriDx6Tjh yTRnIHujg9QYfDHDxY83cRq5xIpL+9pBuNapDKkDJbXlNb6SOjJHW3dOLeSz9wsG bdhciCeIE4Mpcd7wCdwF2mQcpTXuXL51KebDUEQeFb6M34oTZHskXg69tAGw6BqI V7CLkMhO6RsoPZqbQPshmD00OnVrpXT2+liDRuqCyr5sVWjOuS0= =MBxV -----END PGP SIGNATURE----- --sdtB3X0nJg68CQEu--
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20190717040650.GA55947>