Percona 5.5.30 to MariaDB 5.5.30 note

When Mariadb 5.5.30 is started using the mysql system library of percona 5.5.30, an error is reported.

 
 

  
  
[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 ….. 
 
 

Mysql. event of Mariadb and percona has a different structure.

Diff-u Mariadb.event.txt percona.event.txt

-Event.txt 10:35:25. 939778373-0400

++ Event2.txt 10:36:12. 221966298-0400

@-+ @@

'Enabs' datetime default null,

'Status' enum ('enabled', 'Disabled ', 'slaveside _ DISABLED') not null default 'enabled ',

'On _ completion 'enum ('drop', 'preserv') 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 ',

The event cannot be used. After consulting P. linux, the solution is as follows:

Install a pure mariadb,

Then export the mysql database from percona

Mysqldump-B mysql-opt-triggers = true-events-u root-p> mmmmmysql. SQL

Comment out the statements for creating mysql. event and mysql. proc tables (with insert left), and manually import mmmmmysql. SQL to Mariadb 5.5.30.

If you start Mariadb again, no error is reported. It can run normally!

Edit recommendations]

1. MariaDB 5.3 will support the alter table progress prompt
2. The founder of MySQL builds MariaDB fully compatible with MySQL 5.1.
3. MariaDB 2 anniversary
4. How to optimize your MongoDB in five steps
5. MariaDB 5.3.4 performance test