开发者社区> 问答> 正文

数据库恢复报错

[root@MysqlServer /]# innobackupex --defaults-file=/home/mysql/data/backup-my.cnf --apply-log /home/mysql/data/
170105 22:18:05 innobackupex: Starting the apply-log operation

IMPORTANT: Please check that the apply-log run completes successfully.

       At the end of a successful apply-log run innobackupex
       prints "completed OK!".

innobackupex version 2.3.2 based on MySQL server 5.6.24 Linux (x86_64) (revision id: 306a2e0)
xtrabackup: cd to /home/mysql/data/
xtrabackup: This target seems to be not prepared yet.
xtrabackup: xtrabackup_logfile detected: size=356712448, start_lsn=(857379349490)
xtrabackup: using the following InnoDB configuration for recovery:
xtrabackup: innodb_data_home_dir = ./
xtrabackup: innodb_data_file_path = ibdata1:200M:autoextend
xtrabackup: innodb_log_group_home_dir = ./
xtrabackup: innodb_log_files_in_group = 1
xtrabackup: innodb_log_file_size = 356712448
xtrabackup: using the following InnoDB configuration for recovery:
xtrabackup: innodb_data_home_dir = ./
xtrabackup: innodb_data_file_path = ibdata1:200M:autoextend
xtrabackup: innodb_log_group_home_dir = ./
xtrabackup: innodb_log_files_in_group = 1
xtrabackup: innodb_log_file_size = 356712448
xtrabackup: Starting InnoDB instance for recovery.
xtrabackup: Using 104857600 bytes for buffer pool (set by --use-memory parameter)
InnoDB: Using atomics to ref count buffer pool pages
InnoDB: The InnoDB memory heap is disabled
InnoDB: Mutexes and rw_locks use GCC atomic builtins
InnoDB: Memory barrier is not used
InnoDB: Compressed tables use zlib 1.2.3
InnoDB: Using CPU crc32 instructions
InnoDB: Initializing buffer pool, size = 100.0M
InnoDB: Completed initialization of buffer pool
InnoDB: Log file ./ib_logfile1 is of different size 1048576000 bytes than other log files 356712448 bytes!
xtrabackup: innodb_init(): Error occured.

展开
收起
小笔呵呵哒 2017-01-05 22:57:24 4671 0
1 条回答
写回答
取消 提交回答
  • 旺旺:nectar2。

    题主您好,

    我没有实践的经验,

    好象提示日志文件(log file)的大小不符合要求喔。

    2019-07-17 20:40:39
    赞同 展开评论 打赏
问答排行榜
最热
最新

相关电子书

更多
2022 DTCC-阿里云一站式数据库上云最佳实践 立即下载
云时代的数据库技术趋势 立即下载
超大型金融机构国产数据库全面迁移成功实践 立即下载