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

#                                                                                                                                   #