From mboxrd@z Thu Jan 1 00:00:00 1970 Received: from lists.gentoo.org ([140.105.134.102] helo=robin.gentoo.org) by nuthatch.gentoo.org with esmtp (Exim 4.62) (envelope-from ) id 1GsU7e-0001QO-Dc for garchives@archives.gentoo.org; Fri, 08 Dec 2006 01:01:54 +0000 Received: from robin.gentoo.org (localhost [127.0.0.1]) by robin.gentoo.org (8.13.8/8.13.8) with SMTP id kB811LG2030776; Fri, 8 Dec 2006 01:01:21 GMT Received: from mail.pnpitalia.it (85-18-21-122.ip.fastwebnet.it [85.18.21.122]) by robin.gentoo.org (8.13.8/8.13.8) with ESMTP id kB80xFe8015270 for ; Fri, 8 Dec 2006 00:59:15 GMT Received: from localhost (localhost [127.0.0.1]) by mail.pnpitalia.it (Postfix) with ESMTP id 8AB687AD179 for ; Fri, 8 Dec 2006 01:59:15 +0100 (CET) Received: from mail.pnpitalia.it ([127.0.0.1]) by localhost (db [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 07613-27 for ; Fri, 8 Dec 2006 01:59:13 +0100 (CET) Received: from [192.168.4.18] (unknown [192.168.4.18]) by mail.pnpitalia.it (Postfix) with ESMTP id C29B27AD178 for ; Fri, 8 Dec 2006 01:59:13 +0100 (CET) Message-ID: <4578B8E1.8070004@gentoo.org> Date: Fri, 08 Dec 2006 01:59:13 +0100 From: Francesco Riosa User-Agent: Mozilla Thunderbird 1.5.0.8 (X11/20061125) Precedence: bulk List-Post: List-Help: List-Unsubscribe: List-Subscribe: List-Id: Gentoo Linux mail X-BeenThere: gentoo-server@gentoo.org Reply-to: gentoo-server@lists.gentoo.org MIME-Version: 1.0 To: gentoo-server@lists.gentoo.org Subject: Re: [gentoo-server] MySQL upgrade guide References: <456FF627.9090005@gentoo.org> <20061207234531.GG17171@home.power> In-Reply-To: <20061207234531.GG17171@home.power> X-Enigmail-Version: 0.94.1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Virus-Scanned: amavisd-new at mail.pnpitalia.it X-Archives-Salt: bc050d32-c2bb-459a-831e-d57e06d48cce X-Archives-Hash: 3e0b5a62c4ee6ac187369de2501c669e Alex Efros ha scritto: > Hi! > > I notice you are one of authors for Gentoo's MySQL upgrade guide > http://www.gentoo.org/doc/en/mysql-upgrading.xml > and I've few questions about it. > > # MYSQL --execute="FLUSH TABLES WITH READ LOCK;" > ... > # MYSQL --execute="UNLOCK TABLES;" > > AFAIK MySQL drop any locks when connection closes, so you probably need to > open MySQL client in another console and run FLUSH TABLES/UNLOCK TABLES > there while executing tar in first console between these commands. > > # mysql_upgrade_shell --user=root --password='your_password' \ > --protocol=tcp --datadir="${DATADIR}" > Verified, docs need to be updated, I'm planning to do a bunch of things next three days on mysql this will be one. > In original MySQL upgrade documentation they recommend to run mysql_upgrade > program and there is nothing about mysql_upgrade_shell script. > AFAIK mysql_upgrade_shell is older version of this program (mysql_upgrade > program was added because there no bash to execute mysql_upgrade_shell > script on Win32). > So, what's better to run - mysql_upgrade_shell or mysql_upgrade? Or there > no difference between them now? > mysql_upgrade_shell has survived better to my test but I should redo those now probably mysql_upgrade is better maintained. -- gentoo-server@gentoo.org mailing list