在操作innobackupex时,出现无法备份数据库,出现如下代码。
问题点:mysql库中有个库的数据表只有只有ibd文件,没有对应的.frm文件,导致备份无法进行。
[root@mv171 ~]# innobackupex --user=root --password=xxxxxx /bak
231215 10:02:00 innobackupex: Starting the backup operation
IMPORTANT: Please check that the backup run completes successfully.
At the end of a successful backup run innobackupex
prints "completed OK!".
231215 10:02:00 version_check Connecting to MySQL server with DSN 'dbi:mysql:;mysql_read_default_group=xtrabackup;mysql_socket=/tmp/mysql.sock' as 'root' (using password: YES).
231215 10:02:00 version_check Connected to MySQL server
231215 10:02:00 version_check Executing a version check against the server...
231215 10:02:00 version_check Done.
231215 10:02:00 Connecting to MySQL server host: localhost, user: root, password: set, port: 0, socket: /tmp/mysql.sock
Using server version 5.6.40-log
innobackupex version 2.4.4 based on MySQL server 5.7.13 Linux (x86_64) (revision id: df58cf2)
xtrabackup: uses posix_fadvise().
xtrabackup: cd to /application/mysql/data
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: Number of pools: 1
231215 10:02:00 >> log scanned up to (2876077)
xtrabackup: Generating a list of tablespaces
InnoDB: Allocated tablespace ID 1 for mysql/innodb_table_stats, old maximum was 0
InnoDB: Attempted to open a previously opened tablespace. Previous tablespace world/country at filepath: ./world/country.ibd uses space ID: 8. Cannot open filepath: ./world/t1.ibd which uses the same space ID.