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 |