Xtrabackup version: xtrabackup version 2.3.10 -based
Use code: innobackupex - user='mysql' - the password='123456'/mariadb/
Account and permissions in mysql already gave, gave the mysql/mariadb/already permissions,
An error is as follows:
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:12 m: 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 the log file creation failed.
InnoDB: If that is the case, both please refer to
InnoDB: http://dev.mysql.com/doc/refman/5.6/en/error-creating-innodb.html
CodePudding user response:
Backup command with no wrong, my side no problem, the latest official document has no innobackupex, with xtrabackupXtrabackup - backup - target - dir =/root/bak0422/- uroot - password='mypasword'
CodePudding user response:
What was in the mariadb with engine to save the dataCodePudding user response: