Re: [gentoo-server] MySQL upgrade guide

[Francesco Riosa <vivo@gentoo.org>]

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