MySQL4.0 upgrade 5.1SA engineer in writing automatic script shi forgot. binmysql_upgrade-uroot-p -- socktmpmysql5.sock now
MySQL 4.0 upgrade 5.1 SA engineer forgot when writing automatic script shi./bin/mysql_upgrade-u root-p -- sock =/tmp/mysql5.sock
1. database data volume surge. Compared with databases similar to other services, the data volume of a table is abnormal. Finally, a bug of repeated data migration is identified...
120301 17:30:43 [ERROR] Column count of mysql. db is wrong. Expected 22, found 15. The table is probably upted
120301 17:30:43 [ERROR] mysql. user has no 'event _ priv' column at position 29
120301 17:30:43 [ERROR] Event schedles: An error occurred when initializing system tables. Disabling the Event Scheduler.
2. MySQL 4.0 upgrade 5.1 SA engineer forgot when writing the automatic script shi./bin/mysql_upgrade-u root-p -- sock =/tmp/mysql5.sock
3. When I used the MyISAM engine in the past, multi-threaded update often breaks down the table. Recently, the insert engine also sent the table damage, finally, the insert tablename values select ....... union all select ......., it will cause table damage. Split the table and insert the table one by one.
,