how to upgrade mysql56-server to mysql57-server?
tech-lists at zyxst.net
Wed Jul 17 04:06:55 UTC 2019
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!  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 
 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.
 unless there is an exclude pattern that can be applied to pkg
-------------- next part --------------
A non-text attachment was scrubbed...
Size: 833 bytes
Desc: not available
More information about the freebsd-questions