I'm using MySQL Enterprise Backup Ver 8.0.19-commercial for Linux, running the mysqlbackup command-line tool. I would like to create a single image file backup and am using the backup-to-image option, also see below. It invariably fails when it tries to create a file backup-auto.cnf within the backup directory. Has anyone else seen this?
What have I tried for --backup-dir argument that fails?
1. Invoke with non-existing directory; fails when creating backup-auto.cnf
2. Create a new directory and invoke with that; fails when creating backup-auto.cnf
3. Create a new directory, add a "datadir" subdirectory with mode 777; but mysqldump refuses to start at all
Please note, found this link with the output of mysqldump version 8.0.16, shows it working fine and NOT creating a file "backup-auto.cnf" so maybe something changed in 8.0.19:
https://docs.oracle.com/cd/E17952_01/mysql-enterprise-backup-8.0-en/mysqlbackup.backup.html
Full output below. Sorry I don't know how to add markup that keeps it fixed-width and verbatim, is that supported in this forum?
Am I missing a required command-line option? Please let me know, thanks in advance.
--
# /usr/bin/mysqlbackup --backup-dir=/tmp/bkup --backup-image=/tmp/bkup/mysqlbackup.mbi backup-to-image
MySQL Enterprise Backup Ver 8.0.19-commercial for Linux on x86_64 (MySQL Enterprise - Commercial)
Copyright (c) 2003, 2020, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Starting with following command line ...
/usr/bin/mysqlbackup --backup-dir=/tmp/bkup
--backup-image=/tmp/bkup/mysqlbackup.mbi backup-to-image
IMPORTANT: Please check that mysqlbackup run completes successfully.
At the end of a successful 'backup-to-image' run mysqlbackup
prints "mysqlbackup completed OK!".
200813 16:06:19 MAIN INFO: Starting to log actions.
200813 16:06:19 MAIN INFO: No SSL options specified.
200813 16:06:19 MAIN INFO: MySQL server version is '8.0.19-commercial'
200813 16:06:19 MAIN INFO: MySQL server compile os version is 'Linux'
200813 16:06:19 MAIN INFO: Got some server configuration information from running server.
200813 16:06:19 MAIN INFO: No SSL options specified.
200813 16:06:19 MAIN INFO: Backup directory exists: '/tmp/bkup'
200813 16:06:19 MAIN INFO: MySQL server version_comment is 'MySQL Enterprise Server - Commercial'
200813 16:06:19 MAIN INFO: Mysqlbackup component not installed.
200813 16:06:19 MAIN INFO: Server is not a community server.
200813 16:06:19 MAIN INFO: KEF target path:'/tmp/bkup/meta/keyring_kef'
200813 16:06:19 MAIN INFO: TDE Keyring service initialized.
200813 16:06:19 MAIN INFO: MEB logfile created at /tmp/bkup/meta/MEB_2020-08-13.16-06-19_image_backup.log
--------------------------------------------------------------------
Server Repository Options:
--------------------------------------------------------------------
datadir = /var/lib/mysql/
innodb_data_home_dir =
innodb_data_file_path = ibdata1:12M:autoextend
innodb_log_group_home_dir = /var/lib/mysql/
innodb_log_files_in_group = 2
innodb_log_file_size = 52428800
innodb_undo_directory = /var/lib/mysql/
innodb_undo_tablespaces = 2
innodb_buffer_pool_filename = ib_buffer_pool
innodb_page_size = 16384
innodb_checksum_algorithm = crc32
--------------------------------------------------------------------
Backup Config Options:
--------------------------------------------------------------------
datadir = /tmp/bkup/datadir
innodb_data_home_dir = /tmp/bkup/datadir
innodb_data_file_path = ibdata1:12M:autoextend
innodb_log_group_home_dir = /tmp/bkup/datadir
innodb_log_files_in_group = 2
innodb_log_file_size = 52428800
innodb_undo_directory = /tmp/bkup/datadir
innodb_undo_tablespaces = 2
innodb_buffer_pool_filename = ib_buffer_pool
innodb_page_size = 16384
innodb_checksum_algorithm = crc32
Backup Image Path = /tmp/bkup/mysqlbackup.mbi
200813 16:06:19 MAIN INFO: Unique generated backup id for this is 15973347795017716
200813 16:06:19 MAIN INFO: Creating 14 buffers each of size 16777216.
200813 16:06:19 MAIN INFO: Failed to start redo log archiving...
200813 16:06:19 MAIN INFO: Found checkpoint at lsn 43050390.
200813 16:06:19 MAIN INFO: Starting log scan from lsn = 43049984 at offset = 2048 and checkpoint = 43050390 in file /var/lib/mysql/ib_logfile0.
200813 16:06:19 MAIN INFO: Full Image Backup operation starts with following threads
1 read-threads 6 process-threads 1 write-threads
200813 16:06:19 MAIN INFO: No SSL options specified.
200813 16:06:19 RDR1 INFO: Copying meta file /tmp/bkup/backup-my.cnf.
200813 16:06:19 RLP1 INFO: Starting to parse redo log at lsn = 43050109, whereas checkpoint_lsn = 43050390.
200813 16:06:19 RDR1 INFO: Copying meta file /tmp/bkup/meta/backup_create.xml.
200813 16:06:19 RDR1 INFO: Copying meta file /tmp/bkup/datadir/backup-auto.cnf.
200813 16:06:19 RDR1 ERROR: Opening of file /tmp/bkup/datadir/backup-auto.cnf failed. Error code: 2, No such file or directory
200813 16:06:19 RDR1 ERROR: Missing file /tmp/bkup/datadir/backup-auto.cnf
200813 16:06:19 RDR1 INFO: Requesting rapid completion of redo log copy.
200813 16:06:19 RDR1 INFO: Requesting completion of redo log copy after LSN 0.
200813 16:06:20 RLR1 INFO: Redo log reader waited 0 times for a total of 0.00 ms for logs to generate.
mysqlbackup exit code: 9, IO operation failed
mysqlbackup failed with errors!