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.
-- [email protected] mailing list
