-
编辑 删除
[ERROR] InnoDB: Failed to find tablespace for table XXX in the cache
在使用innodb_force_recovery参数强制恢复mysql库以后，错误日志里出现大量错误信息：2015-01-01 17:58:28 26714 [ERROR] InnoDB: Failed to find tablespace for table '"live_koo"."live_consumer_koo"' in the cache. Attempting to load the tablespace with space id 6.2015-01-01 17:58:28 26714 [ERROR] InnoDB: F...
-
编辑 删除
mysqldump: Couldn't execute 'SET OPTION SQL_QUOTE_SHOW_CREATE=1'
上一篇中，因为使用参数强制启动了mysql服务，所以需要使用mysqldump对数据进行备份但是备份过程中报错如下：[root@test11g ~]# mysqldump -uroot -proot -h 192.168.100.141 --all-database > all.sqlmysqldump: Couldn't execute 'SET OPTION SQL_QUOTE_SHOW_CREATE=1': You have an error in your SQL syntax; check ...
-
编辑 删除
xtrabackup结合percona recover工具恢复被drop的表
mysql版本mysql> select version();+-------------------------------------------+| version() |+-------------------------------------------+| 5.6.22-enterprise-commercial-advanced-log |+...
-
编辑 删除
使用xtrabackup恢复被单表数据
mysql版本mysql> select version();+-------------------------------------------+| version() |+-------------------------------------------+| 5.6.22-enterprise-commercial-advanced-log |+...
-
编辑 删除
使用percona recover工具恢复被delete的数据-共享innodb表空间
mysql版本mysql> select version();+-------------------------------------------+| version() |+-------------------------------------------+| 5.6.22-enterprise-commercial-advanced-log |+...
-
编辑 删除
使用percona recover工具恢复被delete的数据-独享innodb表空间
MySQL 5.6版本，独享innodb表空间模式测试表：mysql> select count(*) from live_users;+----------+| count(*) |+----------+| 34258 |+----------+1 row in set (0.02 sec)mysql> delete from live_users;Query OK, 34258 rows affected (0.25 sec)mysql> commit;Query OK, 0 rows affected (...
-
编辑 删除
Can't open and lock privilege tables: Table 'mysql.user' doesn't exist
今早启动一台mysql测试库的时候，启动失败：[root@test11g scripts]# /etc/init.d/mysqld restartShutting down MySQL.. [ OK ]Starting MySQL..The server quit wi...
