nothing is impossible!!!!

nothing is impossible!!!!

Monday, March 16, 2009

Innodb Error 'Can't create table 'mysql.ibbackup_binlog_marker'

Problem:
090316 11:57:32 [ERROR] Slave SQL: Error 'Can't create table 'mysql.ibbackup_binlog_marker' (errno: -1)' on query. Default database: 'mysql'. Query: 'CREATE TABLE ibbackup_binlog_marker(a INT) TYPE=INNODB', Error_code: 1005
090316 11:57:32 [Warning] Slave: The syntax 'TYPE=storage_engine' is deprecated and will be removed in MySQL 5.2. Please use 'ENGINE=storage_engine' instead Error_code: 1287
090316 11:57:32 [Warning] Slave: Can't create table 'mysql.ibbackup_binlog_marker' (errno: -1)
Error_code: 1005
090316 11:57:32 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopped at log 'testing-bin.000009' position 321

Answer:

mysql> CREATE TABLE ibbackup_binlog_marker2(a INT) TYPE=INNODB;
Query OK, 0 rows affected, 1 warning (0.02 sec)

bash# cd /var/mysql/data/
bash# mv mysql/ibbackup_binlog_marker{2,}.frm
bash# mysqladmin flush-tables

mysql> SET SQL_LOG_BIN = 0;
Query OK, 0 rows affected (0.00 sec)

mysql> DROP TABLE IF EXISTS ibbackup_binlog_marker;
Query OK, 0 rows affected (0.12 sec)

No comments: