mysql相关的问题
1、使用xtrabackup恢复数据时报错
- (1)报错
]# xtrabackup --defaults-file=/usr/local/mysql/conf/my.cnf --copy-back --target-dir=./20230206-full xtrabackup: File 'undo001' not found (Errcode: 2 - No such file or directory) InnoDB: Operating system error number 2 in a file operation. InnoDB: The error means the system cannot find the path specified. [01] error: cannot open file undo001 [01] Error: copy_file() failed.
- (2)解决问题
- 通过百度“File 'undo001' not found”获知,要将innodb_undo_tablespaces注释掉。
]# vim /usr/local/mysql/conf/my.cnf #innodb_undo_tablespaces = 3
1
# #