Re: Best practice to disable log bin for mysql_upgrade

2009-09-02 Thread Russell E Glaue
Does anyone have any information regarding my question? Is the 'share/mysql_fix_privilege_tables.sql' script distributed with MySQL the same as the script (represented as '[fix_priv_tables]') generated interally by the mysql_upgrade command that contains SQL statements to upgrade the tables in the

Re: Best practice to disable log bin for mysql_upgrade

2009-08-26 Thread Russell E Glaue
According to this page in the MySQL 5.0 Manual: http://dev.mysql.com/doc/refman/5.0/en/mysql-upgrade.html - mysql_upgrade executes the following commands to check and repair tables and to upgrade the system tables: mysqlcheck --all-databases --check-upgrade --auto-repair mysql < [fix_priv_tables]