mariadb版本：Server version: 10.2.14-MariaDB MariaDB Server
xtrabackup版本：xtrabackup version 2.3.10 based
使用代碼：innobackupex --user='mysql' --password='123456' /mariadb/
賬戶和權限在mysql里面已經給了，/mariadb/ 已經給了mysql的權限。
報錯如下：
xtrabackup: uses posix_fadvise().
xtrabackup: cd to /var/lib/mysql/
xtrabackup: open files limit requested 0, set to 1024
xtrabackup: using the following InnoDB configuration:
xtrabackup: innodb_data_home_dir = ./
xtrabackup: innodb_data_file_path = ibdata1:12M:autoextend
xtrabackup: innodb_log_group_home_dir = ./
xtrabackup: innodb_log_files_in_group = 2
xtrabackup: innodb_log_file_size = 50331648
InnoDB: No valid checkpoint found.
InnoDB: If this error appears when you are creating an InnoDB database,
InnoDB: the problem may be that during an earlier attempt you managed
InnoDB: to create the InnoDB data files, but log file creation failed.
InnoDB: If that is the case, please refer to
InnoDB: http://dev.mysql.com/doc/refman/5.6/en/error-creating-innodb.html
uj5u.com熱心網友回復：
命令用錯了沒，我這邊備份沒問題的。最新的官方檔案已經不用innobackupex 了。都用xtrabackupxtrabackup --backup --target-dir=/root/bak0422/ -uroot --password='mypasword'
uj5u.com熱心網友回復：
看看mariadb用的是什么引擎存資料uj5u.com熱心網友回復：
謝謝，已經解決的，mariadn10版本之后的要用xtabackup2.4版本之后的。用2.4版本后就ok了。
uj5u.com熱心網友回復：
版本的問題，要用2.4版本之后的，感謝答復。
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/90943.html
標籤：MySQL
上一篇：mongo匯出再匯入數量變多