建站
咨詢
售后
建站咨詢
新聞中心
Mariadb 5.5.30 用 percona 5.5.30 的mysql系統(tǒng)庫啟動(dòng)時(shí)會(huì)報(bào)錯(cuò)
- [ERROR] Incorrect definition of table mysql.event: expected column ‘sql_mode’ at position 14 to have type set ……
- [ERROR] mysqld: Table ‘./mysql/tables_priv’ is marked as crashed and should be repaired
- [Warning] Checking table: ‘./mysql/tables_priv’
- [ERROR] mysql.tables_priv: 1 client is using or hasn’t closed the table properly
- mysql.proc …..
Mariadb和percona的mysql.event此表結(jié)構(gòu)有點(diǎn)不同
diff -u Mariadb.event.txt percona.event.txt
— event.txt 2013-05-04 10:35:25.939778373 -0400
+++ event2.txt 2013-05-04 10:36:12.221966298 -0400
@@ -12,7 +12,7 @@
`ends` datetime DEFAULT NULL,
`status` enum(‘ENABLED’,'DISABLED’,'SLAVESIDE_DISABLED’) NOT NULL DEFAULT ‘ENABLED’,
`on_completion` enum(‘DROP’,'PRESERVE’) NOT NULL DEFAULT ‘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_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')
- NOT NULL DEFAULT '',
- + `sql_mode` set('REAL_AS_FLOAT','PIPES_AS_CONCAT','ANSI_QUOTES','IGNORE_SPACE','NOT_USED','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_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')
- NOT NULL DEFAULT '',
`comment` char(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT ”,
`originator` int(10) unsigned NOT NULL,
`time_zone` char(64) CHARACTER SET latin1 NOT NULL DEFAULT ‘SYSTEM’,
導(dǎo)致event無法使用， 在咨詢P.linux兄后，解決辦法如下
裝一個(gè)純凈的mariadb，
然后從percona導(dǎo)出mysql庫
mysqldump -B mysql –opt –triggers=true –events -u root -p > mmmmmysql.sql
注釋掉mysql.event, mysql.proc 表的建表語句(留下insert)，然后手工導(dǎo)mmmmmysql.sql 進(jìn)Mariadb 5.5.30
再啟動(dòng)Mariadb就沒報(bào)錯(cuò)了 ，能正常運(yùn)行！
原文鏈接：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
標(biāo)題名稱：Percona5.5.30轉(zhuǎn)投MariaDB5.5.30小記
網(wǎng)站URL：http://www.dlmjj.cn/article/dpsigop.html
