MySQLBACKUP failed
Posted by: Haidar AbuBaker
Date: February 29, 2016 04:52AM
Date: February 29, 2016 04:52AM
Dears,
Im trying to run the below MySQLBACKUP script:
/var/lib/mysql/meb-3-7-1-el6-x86-64bit/bin/mysqlbackup --port=3306 --protocol=tcp --user=root --password --with-timestamp --backup-dir=/usr/protei/backup/ backup
but always I got this error:
mysqlbackup: INFO: Backing up the database directory '.mc'
mysqlbackup: ERROR: Source database directory should contain only files.
Found Subdirectory = /var/lib/mysql/.mc/cedit
mysqlbackup: ERROR: Cannot backup table `.mc`.`cedit`
mysqlbackup: ERROR: Cannot backup database '.mc'
mysqlbackup: ERROR: Backup of non-innodb tables failed.!
160229 12:07:36 mysqlbackup: INFO: All tables unlocked
Error: operation failed. global_error_count: 4 backup_config.error_count: 1
Please advise :)
Find below full backup log (which is failed)
MySQL Enterprise Backup version 3.7.1 [2012/03/20]
Copyright (c) 2003, 2012, Oracle and/or its affiliates. All Rights Reserved.
INFO: Starting with following command line ...
/var/lib/mysql/meb-3-7-1-el6-x86-64bit/bin/mysqlbackup --port=3306
--protocol=tcp --user=root --password --with-timestamp
--backup-dir=/usr/protei/backup/ backup
Enter password:
INFO: Got some server configuration information from running server.
IMPORTANT: Please check that mysqlbackup run completes successfully.
At the end of a successful 'backup' run mysqlbackup
prints "mysqlbackup completed OK!".
--------------------------------------------------------------------
Server Repository Options:
--------------------------------------------------------------------
datadir = /var/lib/mysql/
innodb_data_home_dir = /var/lib/mysql/
innodb_data_file_path = ibdata1:10M:autoextend
innodb_log_group_home_dir = /var/lib/mysql/
innodb_log_files_in_group = 2
innodb_log_file_size = 268435456
--------------------------------------------------------------------
Backup Config Options:
--------------------------------------------------------------------
datadir = /usr/protei/backup/2016-02-29_12-07-32/datadir
innodb_data_home_dir = /usr/protei/backup/2016-02-29_12-07-32/datadir
innodb_data_file_path = ibdata1:10M:autoextend
innodb_log_group_home_dir = /usr/protei/backup/2016-02-29_12-07-32/datadir
innodb_log_files_in_group = 2
innodb_log_file_size = 268435456
mysqlbackup: INFO: Unique generated backup id for this is 14567404527203314
mysqlbackup: INFO: Uses posix_fadvise() for performance optimization.
mysqlbackup: INFO: System tablespace file format is Antelope.
mysqlbackup: INFO: Found checkpoint at lsn 4629701.
mysqlbackup: INFO: Starting log scan from lsn 4629504.
160229 12:07:32 mysqlbackup: INFO: Copying log...
160229 12:07:32 mysqlbackup: INFO: Log copied, lsn 4629701.
We wait 1 second before starting copying the data files...
160229 12:07:33 mysqlbackup: INFO: Copying /var/lib/mysql/ibdata1 (Antelope file format).
160229 12:07:36 mysqlbackup: INFO: Copying /var/lib/mysql/mysql/slave_relay_log_info.ibd (Antelope file format).
160229 12:07:36 mysqlbackup: INFO: Copying /var/lib/mysql/mysql/slave_master_info.ibd (Antelope file format).
160229 12:07:36 mysqlbackup: INFO: Copying /var/lib/mysql/mysql/innodb_table_stats.ibd (Antelope file format).
160229 12:07:36 mysqlbackup: INFO: Copying /var/lib/mysql/mysql/slave_worker_info.ibd (Antelope file format).
160229 12:07:36 mysqlbackup: INFO: Copying /var/lib/mysql/mysql/innodb_index_stats.ibd (Antelope file format).
160229 12:07:36 mysqlbackup: INFO: Copying /var/lib/mysql/rp/MailboxStorageInfoHistory.ibd (Antelope file format).
160229 12:07:36 mysqlbackup: INFO: Copying /var/lib/mysql/rp/COS.ibd (Antelope file format).
160229 12:07:36 mysqlbackup: INFO: Copying /var/lib/mysql/rp/System.ibd (Antelope file format).
160229 12:07:36 mysqlbackup: INFO: Copying /var/lib/mysql/rp/Session.ibd (Antelope file format).
160229 12:07:36 mysqlbackup: INFO: Copying /var/lib/mysql/rp/DeliverySchedule.ibd (Antelope file format).
160229 12:07:36 mysqlbackup: INFO: Copying /var/lib/mysql/rp/WHC_Profile.ibd (Antelope file format).
160229 12:07:36 mysqlbackup: INFO: Copying /var/lib/mysql/rp/Message.ibd (Antelope file format).
160229 12:07:36 mysqlbackup: INFO: Copying /var/lib/mysql/rp/Profile.ibd (Antelope file format).
160229 12:07:36 mysqlbackup: INFO: Copying /var/lib/mysql/rp/DATABASECHANGELOG.ibd (Antelope file format).
160229 12:07:36 mysqlbackup: INFO: Copying /var/lib/mysql/rp/ProfileCosHistory.ibd (Antelope file format).
160229 12:07:36 mysqlbackup: INFO: Copying /var/lib/mysql/rp/Account.ibd (Antelope file format).
160229 12:07:36 mysqlbackup: INFO: Copying /var/lib/mysql/rp/DATABASECHANGELOGLOCK.ibd (Antelope file format).
160229 12:07:36 mysqlbackup: INFO: Copying /var/lib/mysql/rp/DeletingMessage.ibd (Antelope file format).
160229 12:07:36 mysqlbackup: INFO: Copying /var/lib/mysql/rp/Welcome.ibd (Antelope file format).
mysqlbackup: INFO: Preparing to lock tables: Connected to mysqld server.
160229 12:07:36 mysqlbackup: INFO: Starting to lock all the tables....
160229 12:07:36 mysqlbackup: INFO: All tables are locked and flushed to disk
mysqlbackup: INFO: Opening backup source directory '/var/lib/mysql/'
160229 12:07:36 mysqlbackup: INFO: Starting to backup all files in subdirectories of '/var/lib/mysql/'
mysqlbackup: INFO: Backing up the database directory '.mc'
mysqlbackup: ERROR: Source database directory should contain only files.
Found Subdirectory = /var/lib/mysql/.mc/cedit
mysqlbackup: ERROR: Cannot backup table `.mc`.`cedit`
mysqlbackup: ERROR: Cannot backup database '.mc'
mysqlbackup: ERROR: Backup of non-innodb tables failed.!
160229 12:07:36 mysqlbackup: INFO: All tables unlocked
Error: operation failed. global_error_count: 4 backup_config.error_count: 1
-------------------------------------------------------------
Parameters Summary
-------------------------------------------------------------
Start LSN : 0
End LSN : 0
-------------------------------------------------------------
Im trying to run the below MySQLBACKUP script:
/var/lib/mysql/meb-3-7-1-el6-x86-64bit/bin/mysqlbackup --port=3306 --protocol=tcp --user=root --password --with-timestamp --backup-dir=/usr/protei/backup/ backup
but always I got this error:
mysqlbackup: INFO: Backing up the database directory '.mc'
mysqlbackup: ERROR: Source database directory should contain only files.
Found Subdirectory = /var/lib/mysql/.mc/cedit
mysqlbackup: ERROR: Cannot backup table `.mc`.`cedit`
mysqlbackup: ERROR: Cannot backup database '.mc'
mysqlbackup: ERROR: Backup of non-innodb tables failed.!
160229 12:07:36 mysqlbackup: INFO: All tables unlocked
Error: operation failed. global_error_count: 4 backup_config.error_count: 1
Please advise :)
Find below full backup log (which is failed)
MySQL Enterprise Backup version 3.7.1 [2012/03/20]
Copyright (c) 2003, 2012, Oracle and/or its affiliates. All Rights Reserved.
INFO: Starting with following command line ...
/var/lib/mysql/meb-3-7-1-el6-x86-64bit/bin/mysqlbackup --port=3306
--protocol=tcp --user=root --password --with-timestamp
--backup-dir=/usr/protei/backup/ backup
Enter password:
INFO: Got some server configuration information from running server.
IMPORTANT: Please check that mysqlbackup run completes successfully.
At the end of a successful 'backup' run mysqlbackup
prints "mysqlbackup completed OK!".
--------------------------------------------------------------------
Server Repository Options:
--------------------------------------------------------------------
datadir = /var/lib/mysql/
innodb_data_home_dir = /var/lib/mysql/
innodb_data_file_path = ibdata1:10M:autoextend
innodb_log_group_home_dir = /var/lib/mysql/
innodb_log_files_in_group = 2
innodb_log_file_size = 268435456
--------------------------------------------------------------------
Backup Config Options:
--------------------------------------------------------------------
datadir = /usr/protei/backup/2016-02-29_12-07-32/datadir
innodb_data_home_dir = /usr/protei/backup/2016-02-29_12-07-32/datadir
innodb_data_file_path = ibdata1:10M:autoextend
innodb_log_group_home_dir = /usr/protei/backup/2016-02-29_12-07-32/datadir
innodb_log_files_in_group = 2
innodb_log_file_size = 268435456
mysqlbackup: INFO: Unique generated backup id for this is 14567404527203314
mysqlbackup: INFO: Uses posix_fadvise() for performance optimization.
mysqlbackup: INFO: System tablespace file format is Antelope.
mysqlbackup: INFO: Found checkpoint at lsn 4629701.
mysqlbackup: INFO: Starting log scan from lsn 4629504.
160229 12:07:32 mysqlbackup: INFO: Copying log...
160229 12:07:32 mysqlbackup: INFO: Log copied, lsn 4629701.
We wait 1 second before starting copying the data files...
160229 12:07:33 mysqlbackup: INFO: Copying /var/lib/mysql/ibdata1 (Antelope file format).
160229 12:07:36 mysqlbackup: INFO: Copying /var/lib/mysql/mysql/slave_relay_log_info.ibd (Antelope file format).
160229 12:07:36 mysqlbackup: INFO: Copying /var/lib/mysql/mysql/slave_master_info.ibd (Antelope file format).
160229 12:07:36 mysqlbackup: INFO: Copying /var/lib/mysql/mysql/innodb_table_stats.ibd (Antelope file format).
160229 12:07:36 mysqlbackup: INFO: Copying /var/lib/mysql/mysql/slave_worker_info.ibd (Antelope file format).
160229 12:07:36 mysqlbackup: INFO: Copying /var/lib/mysql/mysql/innodb_index_stats.ibd (Antelope file format).
160229 12:07:36 mysqlbackup: INFO: Copying /var/lib/mysql/rp/MailboxStorageInfoHistory.ibd (Antelope file format).
160229 12:07:36 mysqlbackup: INFO: Copying /var/lib/mysql/rp/COS.ibd (Antelope file format).
160229 12:07:36 mysqlbackup: INFO: Copying /var/lib/mysql/rp/System.ibd (Antelope file format).
160229 12:07:36 mysqlbackup: INFO: Copying /var/lib/mysql/rp/Session.ibd (Antelope file format).
160229 12:07:36 mysqlbackup: INFO: Copying /var/lib/mysql/rp/DeliverySchedule.ibd (Antelope file format).
160229 12:07:36 mysqlbackup: INFO: Copying /var/lib/mysql/rp/WHC_Profile.ibd (Antelope file format).
160229 12:07:36 mysqlbackup: INFO: Copying /var/lib/mysql/rp/Message.ibd (Antelope file format).
160229 12:07:36 mysqlbackup: INFO: Copying /var/lib/mysql/rp/Profile.ibd (Antelope file format).
160229 12:07:36 mysqlbackup: INFO: Copying /var/lib/mysql/rp/DATABASECHANGELOG.ibd (Antelope file format).
160229 12:07:36 mysqlbackup: INFO: Copying /var/lib/mysql/rp/ProfileCosHistory.ibd (Antelope file format).
160229 12:07:36 mysqlbackup: INFO: Copying /var/lib/mysql/rp/Account.ibd (Antelope file format).
160229 12:07:36 mysqlbackup: INFO: Copying /var/lib/mysql/rp/DATABASECHANGELOGLOCK.ibd (Antelope file format).
160229 12:07:36 mysqlbackup: INFO: Copying /var/lib/mysql/rp/DeletingMessage.ibd (Antelope file format).
160229 12:07:36 mysqlbackup: INFO: Copying /var/lib/mysql/rp/Welcome.ibd (Antelope file format).
mysqlbackup: INFO: Preparing to lock tables: Connected to mysqld server.
160229 12:07:36 mysqlbackup: INFO: Starting to lock all the tables....
160229 12:07:36 mysqlbackup: INFO: All tables are locked and flushed to disk
mysqlbackup: INFO: Opening backup source directory '/var/lib/mysql/'
160229 12:07:36 mysqlbackup: INFO: Starting to backup all files in subdirectories of '/var/lib/mysql/'
mysqlbackup: INFO: Backing up the database directory '.mc'
mysqlbackup: ERROR: Source database directory should contain only files.
Found Subdirectory = /var/lib/mysql/.mc/cedit
mysqlbackup: ERROR: Cannot backup table `.mc`.`cedit`
mysqlbackup: ERROR: Cannot backup database '.mc'
mysqlbackup: ERROR: Backup of non-innodb tables failed.!
160229 12:07:36 mysqlbackup: INFO: All tables unlocked
Error: operation failed. global_error_count: 4 backup_config.error_count: 1
-------------------------------------------------------------
Parameters Summary
-------------------------------------------------------------
Start LSN : 0
End LSN : 0
-------------------------------------------------------------
Subject
Views
Written By
Posted
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.