Description:
When innobackup is executed, it generates table based logs that includes history and progress logs.
The history logs has different fields where one of the column is mysql_data_dir. This is shown incorrectly in the table with innodb tablespace information. Ideally it should show the data directory name of MySQL server.
How to repeat:
Please pull the latest code of MEB logs from commits-mysql-enterprise-backup-ext email list. Then execute innobackup and check for the logs.
You will find the following
SELECT * FROM mysql.backup_history;;
backup_id BACKUP_ID
tool_name INNOBACKUP --port=13000 --user=root --no-timestamp MYSQLTEST_VARDIR/my.cnf MYSQLTEST_VARDIR/tmp/meb_bup_dir
start_time START_TIME
end_time STOP_TIME
binlog_pos -1
binlog_file binlog not enabled
compression_level 1
engines MEMORY:MyISAM:InnoDB:ARCHIVE:BLACKHOLE:CSV:
innodb_data_file_path ibdata1:10M;ibdata2:10M:autoextend
innodb_file_format Antelope
start_lsn 0
end_lsn 0
incremental_base_lsn 0
backup_type FULL
backup_format DIRECTORY
mysql_data_dir ibdata1:10M;ibdata2:10M:autoextend -----> "PLS NOTE"
innodb_data_home_dir MYSQLTEST_VARDIR/mysqld.1/data
innodb_log_group_home_dir MYSQLTEST_VARDIR/mysqld.1/data
innodb_log_files_in_group 3
innodb_log_file_size 5M
backup_destination MYSQLTEST_VARDIR/tmp/meb_bup_dir
lock_time 5.000
exit_state success
last_error NO_ERROR
last_error_code 0
Suggested fix:
Please change the mysql_data_dir to show the data directory name.
