Mariadb5.5.30使用percona5.5.30的mysql系统库启动时会报错[ERROR]Incorrectdefinitionoftablemysql.event:expectedcolumn'sql_mode'atposition14tohavetypeset……[ERROR]mysqld:Table'./mysql/tables_priv'ismarkedascrashedandshouldberepairing]Check:[Warning]'./mysql/tables_priv'[ERROR]mysql.tables_priv:1clientisusingorhasn'tclosedthetableproperlymysql.proc…..Mariadb和percona的mysql.event这种结构有些不同diff-uMariadb.event.txtpercona.event.txt—事件。txt2013-05-0410:35:25.939778373-0400+++event2.txt2013-05-0410:36:12.221966298-0400@@-12,7+12,7@@`ends`datetimeDEFAULTNULL,`status`enum('ENABLED','DISABLED','SLAVESIDE_DISABLED')NOTNULLDEFAULT'ENABLED',`on_completion`enum('DROP','PRESERVE')NOTNULLDEFAULT'DROP',-`sql_mode`set('REAL_AS_FLOAT','PIPES_AS_CONCAT','ANSI_QUOTES','IGNORE_SPACE','IGNORE_BAD_TABLE_OPTIONS','ONLY_FULL_GROUP_BY','NO_UNSIGNED_SUBTRACTION','NO_DIR_IN_CREATE','POSTGRESQL','ORACLE','MSSQL','DB2','MAXDB','NO_KEY_OPTIONS','NO_TABLE_OPTIONS','NO_FIELD_OPTIONS','MYSQL323','MYSQL40'，'ansi'，'no_auto_value_on_zero'，'no_backslash_escapes'，'strict_trans_tables'，'strict_all_all_tables'，'no_zero_in_in_date'，'no_zero_date'，'no_zero_zero_date'no_zero_date'，'no_zero_date'，''''，''''n__d_dates''nof__datenore_divivivivivivion''NO_ENGINE_SUBSTITUTION','PAD_CHAR_TO_FULL_LENGTH')NOTNULLDEFAULT'',+`sql_mode`set('REAL_AS_FLOAT','PIPES_AS_CONCAT','ANSI_QUOTES','IGNORE_SPACE','NOT_USED','ONLY_FULL_GROUP_BY','NO_UNSIGNED_FLOAT','NOT_SUB_RECIRTION',POSTGRESQL','ORACLE','MSSQL','DB2','MAXDB','NO_KEY_OPTIONS','NO_TABLE_OPTIONS','NO_FIELD_OPTIONS','MYSQL323','MYSQL40','ANSI','NO_AUTO_VALUE_ON_ZERO','NO_BACKSLASH_ESCAPES','STRICT_TRANS_TABLES','STRICT_ALL_TABLES','NO_ZERO_IN_DATE','NO_ZERO_DATE','INVALID_DATES','ERROR_FOR_DIVISION_BY_ZERO','TRADITIONAL','NO_AUTO_CREATE_USER','HIGH_NOT_PRECEDENCE','NO_ENGINE_SUBSTITUTION','PAD_CHAR_TO_FULL_LENGTH')NOTNULLDEFAULT'',`comment`char(64)CHARACTERSETutf8COLLATEutf8_binNOTNULLDEFAULT",`originator`timeintN_LENGTHone(10)unsignedchar(64))CHARACTERSETlatin1NOTNULLDEFAULT'SYSTEM'，导致无法使用的事件。咨询了P.linux兄，解决方法如下安装一个纯mariadb，然后将mysql库导出perconamysqldump-Bmysql–opt–triggers=true–events-uroot-p>mmmmmysql.sql注释掉mysql.event、mysql.proc表的建表语句（保留insert），然后手动将mmmmmysql.sql导入到Mariadb5.5.30中，然后启动Mariadb，没有报错，现在可以正常运行了！原文链接：http://www.mysqlops.com/2013/05/08/percona-5-5-30-%E8%BD%AC%E6%8A%95-mariadb-5-5-30-%E5%B0%8F%E8%AE%B0.html【编者推荐】MariaDB5.3将支持ALTERTABLE进度提示MySQL创始人打造完全兼容MySQL5.1的MariaDBMariaDB2周年教你五步优化你的MongoDBMariaDB5.3.4性能测试
