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}"
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?
--
WBR, Alex.
--
[email protected] mailing list
