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

#                                                                                                                                   #
posted @ 2023-02-07 16:49  麦恒  阅读(204)  评论(0)  编辑  收藏  举报