Friday, January 05, 2007

Upgrading multiple instance MySQL DB to new version


After upgradation, we need to convert the system tables to current format.
For this we need to run mysql_fix_privilege_tables command.

If we are having multiple instances, we need to specify the socket file as shown below:

# mysql_fix_privilege_tables --socket=/path/to/socket_file