From owner-freebsd-questions@freebsd.org Wed Jul 17 09:06:28 2019 Return-Path: Delivered-To: freebsd-questions@mailman.nyi.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2610:1c1:1:606c::19:1]) by mailman.nyi.freebsd.org (Postfix) with ESMTP id 8A5B8A73D3 for ; Wed, 17 Jul 2019 09:06:28 +0000 (UTC) (envelope-from jmc-freebsd2@milibyte.co.uk) Received: from outmx-004.london.gridhost.co.uk (outmx-004.london.gridhost.co.uk [95.142.156.27]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (Client did not present a certificate) by mx1.freebsd.org (Postfix) with ESMTPS id C51916F46C for ; Wed, 17 Jul 2019 09:06:27 +0000 (UTC) (envelope-from jmc-freebsd2@milibyte.co.uk) Received: from curlew.milibyte.co.uk (unknown [82.71.56.121]) (Authenticated sender: mailpool@milibyte.co.uk) by outmx-004.london.gridhost.co.uk (Postfix) with ESMTPA id 9FD9827FD4E24; Wed, 17 Jul 2019 10:06:09 +0100 (BST) Received: from [127.0.0.1] (helo=curlew.localnet) by curlew.milibyte.co.uk with esmtp (Exim 4.92) (envelope-from ) id 1hnfsz-0004YW-2D; Wed, 17 Jul 2019 10:06:05 +0100 From: Mike Clarke To: freebsd-questions@freebsd.org Cc: tech-lists Subject: Re: how to upgrade mysql56-server to mysql57-server? Date: Wed, 17 Jul 2019 10:06:04 +0100 Message-ID: <1569215.MsCH1bHPGx@curlew> In-Reply-To: <20190717040650.GA55947@mon.zyxst.net> References: <20190717040650.GA55947@mon.zyxst.net> MIME-Version: 1.0 X-SA-Exim-Connect-IP: 127.0.0.1 X-SA-Exim-Mail-From: jmc-freebsd2@milibyte.co.uk X-SA-Exim-Scanned: No (on curlew.milibyte.co.uk); SAEximRunCond expanded to false X-Rspamd-Queue-Id: C51916F46C X-Spamd-Bar: ++++ Authentication-Results: mx1.freebsd.org; spf=pass (mx1.freebsd.org: domain of jmc-freebsd2@milibyte.co.uk designates 95.142.156.27 as permitted sender) smtp.mailfrom=jmc-freebsd2@milibyte.co.uk X-Spamd-Result: default: False [4.30 / 15.00]; ARC_NA(0.00)[]; RCVD_VIA_SMTP_AUTH(0.00)[]; FROM_HAS_DN(0.00)[]; TO_DN_SOME(0.00)[]; R_SPF_ALLOW(-0.20)[+ptr]; IP_SCORE(0.51)[ipnet: 95.142.156.0/22(0.96), asn: 198047(1.69), country: GB(-0.08)]; MIME_GOOD(-0.10)[multipart/alternative,text/plain]; MID_RHS_NOT_FQDN(0.50)[]; DMARC_NA(0.00)[milibyte.co.uk]; NEURAL_SPAM_MEDIUM(0.53)[0.527,0]; NEURAL_SPAM_SHORT(0.70)[0.702,0]; RCVD_COUNT_THREE(0.00)[3]; TO_MATCH_ENVRCPT_SOME(0.00)[]; MX_GOOD(-0.01)[mail3.eqx.gridhost.co.uk]; RCPT_COUNT_TWO(0.00)[2]; NEURAL_SPAM_LONG(0.97)[0.968,0]; RCVD_TLS_LAST(0.00)[]; RCVD_IN_DNSWL_LOW(-0.10)[27.156.142.95.list.dnswl.org : 127.0.5.1]; MIME_TRACE(0.00)[0:+,1:+]; R_DKIM_NA(0.00)[]; ASN(0.00)[asn:198047, ipnet:95.142.156.0/22, country:GB]; SUBJECT_ENDS_QUESTION(1.00)[]; CTE_CASE(0.50)[]; FROM_EQ_ENVFROM(0.00)[] Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: 7Bit X-Content-Filtered-By: Mailman/MimeDel 2.1.29 X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.29 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 17 Jul 2019 09:06:28 -0000 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 = > 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 -- Mike Clarke