how to upgrade mysql56-server to mysql57-server?

[tech-lists]

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.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 833 bytes
Desc: not available
URL: <http://lists.freebsd.org/pipermail/freebsd-questions/attachments/20190717/24ee73c1/attachment.sig>