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>
index | next in thread | raw e-mail
[-- Attachment #1 --] Hi, The default version of mysql/mysqld changed from 5.6 to 5.7 on 20190701. The problem now is that if "pkg upgrade" is run, mysql-client is 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 "service mysql-server start" is run, it starts up then exits. 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 = 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. [2] unless there is an exclude pattern that can be applied to pkg upgrade -- J. [-- Attachment #2 --] -----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-----help
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20190717040650.GA55947>