xtrabackup 备份恢复

xtrabackup备份恢复出错如下：

mysqld: File './binlog.index' not found (OS errno 13 - Permission denied)
2022-08-18T01:11:55.151140Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.15) starting as process 73830
2022-08-18T01:11:55.153014Z 0 [ERROR] [MY-010119] [Server] Aborting
2022-08-18T01:11:55.153155Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.15)  MySQL Community Server - GPL.
2022-08-18T01:12:15.484579Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.15) starting as process 73847
2022-08-18T01:12:16.166015Z 1 [ERROR] [MY-011087] [Server] Different lower_case_table_names settings for server ('0') and data dictionary ('1').
2022-08-18T01:12:16.166341Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2022-08-18T01:12:16.166478Z 0 [ERROR] [MY-010119] [Server] Aborting
2022-08-18T01:12:17.242325Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.15)  MySQL Community Server - GPL.

 

处理：恢复后注意权限，注意初始化参数lower_case_table_names=1 ，可以使用mysqld --user=root启动

posted @ 2022-08-18 14:54  da0h1  阅读(270)  评论(0)  编辑  收藏  举报