| 1 |
Hi! |
| 2 |
|
| 3 |
I notice you are one of authors for Gentoo's MySQL upgrade guide |
| 4 |
http://www.gentoo.org/doc/en/mysql-upgrading.xml |
| 5 |
and I've few questions about it. |
| 6 |
|
| 7 |
# MYSQL --execute="FLUSH TABLES WITH READ LOCK;" |
| 8 |
... |
| 9 |
# MYSQL --execute="UNLOCK TABLES;" |
| 10 |
|
| 11 |
AFAIK MySQL drop any locks when connection closes, so you probably need to |
| 12 |
open MySQL client in another console and run FLUSH TABLES/UNLOCK TABLES |
| 13 |
there while executing tar in first console between these commands. |
| 14 |
|
| 15 |
# mysql_upgrade_shell --user=root --password='your_password' \ |
| 16 |
--protocol=tcp --datadir="${DATADIR}" |
| 17 |
|
| 18 |
In original MySQL upgrade documentation they recommend to run mysql_upgrade |
| 19 |
program and there is nothing about mysql_upgrade_shell script. |
| 20 |
AFAIK mysql_upgrade_shell is older version of this program (mysql_upgrade |
| 21 |
program was added because there no bash to execute mysql_upgrade_shell |
| 22 |
script on Win32). |
| 23 |
So, what's better to run - mysql_upgrade_shell or mysql_upgrade? Or there |
| 24 |
no difference between them now? |
| 25 |
|
| 26 |
-- |
| 27 |
WBR, Alex. |
| 28 |
-- |
| 29 |
gentoo-server@g.o mailing list |
Archives