RDS for MySQL 备份文件恢复到自建数据库遇到启动问题

淡淡的烟草味﹌ 2022-07-15 01:29 178阅读 0赞

# [RDS for MySQL 备份文件恢复到自建数据库][RDS for MySQL] #

参见如下：

https://help.aliyun.com/knowledge\_detail/41817.html

恢复启动时遇到如下错误：

mysqld\_safe --defaults-file=/home/mysqlbakup/backup-my.cnf --user=mysql --datadir=/home/mysqlbakup/

2016-10-28T01:17:58.928126Z 0 \[Note\] /usr/local/mysql/bin/mysqld (mysqld 5.7.14) starting as process 2961 ...  
2016-10-28T01:17:58.934128Z 0 \[Note\] InnoDB: PUNCH HOLE support not available  
2016-10-28T01:17:58.934152Z 0 \[Note\] InnoDB: Mutexes and rw\_locks use GCC atomic builtins  
2016-10-28T01:17:58.934155Z 0 \[Note\] InnoDB: Uses event mutexes  
2016-10-28T01:17:58.934158Z 0 \[Note\] InnoDB: GCC builtin \_\_sync\_synchronize() is used for memory barrier  
2016-10-28T01:17:58.934190Z 0 \[Note\] InnoDB: Compressed tables use zlib 1.2.3  
2016-10-28T01:17:58.934193Z 0 \[Note\] InnoDB: Using Linux native AIO  
2016-10-28T01:17:58.934342Z 0 \[Note\] InnoDB: Number of pools: 1  
2016-10-28T01:17:58.934412Z 0 \[Note\] InnoDB: Using CPU crc32 instructions  
2016-10-28T01:17:58.936476Z 0 \[Note\] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M  
2016-10-28T01:17:58.946301Z 0 \[Note\] InnoDB: Completed initialization of buffer pool  
2016-10-28T01:17:58.949380Z 0 \[Note\] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().  
2016-10-28T01:17:58.982063Z 0 \[Note\] InnoDB: Highest supported file format is Barracuda.  
2016-10-28T01:17:59.000041Z 0 \[ERROR\] InnoDB: Log block 5160141 at lsn 2641991680 has valid header, but checksum field contains 1791751127, should be 1555321045  
2016-10-28T01:17:59.000064Z 0 \[ERROR\] InnoDB: Ignoring the redo log due to missing MLOG\_CHECKPOINT between the checkpoint 2641991739 and the end 2641991680.  
2016-10-28T01:17:59.000072Z 0 \[ERROR\] InnoDB: Plugin initialization aborted with error Generic error  
2016-10-28T01:17:59.603002Z 0 \[ERROR\] Plugin 'InnoDB' init function returned error.  
2016-10-28T01:17:59.603060Z 0 \[ERROR\] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.  
2016-10-28T01:17:59.603076Z 0 \[ERROR\] Failed to initialize plugins.  
2016-10-28T01:17:59.603092Z 0 \[ERROR\] Aborting

删除/home/mysqlbakup/ 目录下的ib\_logfile0和ib\_logfile1重新启动就可以了

[RDS for MySQL]: https://help.aliyun.com/knowledge_detail/41817.html#RDS%20for%20MySQL%20备份文件恢复到自建数据库