Home > database >  Mariadb 10.2.14 using xtrabackup backup error.
Mariadb 10.2.14 using xtrabackup backup error.

Time:12-11

Mariadb versions: Server version: 10.2.14 - mariadb mariadb Server
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 xtrabackup
Xtrabackup - backup - target - dir =/root/bak0422/- uroot - password='mypasword'

CodePudding user response:

What was in the mariadb with engine to save the data

CodePudding user response:

reference 1st floor crynono response:
command with no wrong, my side backup, the latest official document has no innobackupex, with xtrabackup
Xtrabackup - backup - target - dir =/root/bak0422/- uroot - password='mypasword'


Thank you, have been solved, mariadn10 use after xtabackup2.4 version after version, after using version 2.4 with respect to ok,

CodePudding user response:

refer to the second floor rucypli response:
what was in the mariadb with engine to save data

Version of the problem, want to use after the version 2.4, thanks to reply,
  • Related