MySQL Forums
Forum List  »  Backup

mysql backup error after restore
Posted by: Paolo Sestini
Date: October 22, 2019 04:19AM

I have succesfully backuped up my database using mysqlback.
At a given moment I had to restore it to a backup taken previously.
Since then the Database is running with no problem but when I come backup it up again I get the following error message:


mysqlbackup -uroot -pxxxxxxx --no-locking --backup-dir=/DbRepo/bkp backup


MySQL server version is '5.6.25-enterprise-commercial-advanced'.
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!".

191021 00:05:01 mysqlbackup: INFO: MEB logfile created at /DbRepo/bkp/meta/MEB_2019-10-21.00-05-01_backup.log

--------------------------------------------------------------------
Server Repository Options:
--------------------------------------------------------------------
datadir = /DbRepo/mysql/
innodb_data_home_dir =
innodb_data_file_path = ibdata1:12M:autoextend
innodb_log_group_home_dir = /DbRepo/mysql/
innodb_log_files_in_group = 2
innodb_log_file_size = 50331648
innodb_page_size = 16384
innodb_checksum_algorithm = innodb
innodb_undo_directory = /DbRepo/mysql/
innodb_undo_tablespaces = 0
innodb_undo_logs = 128

--------------------------------------------------------------------
Backup Config Options:
--------------------------------------------------------------------
datadir = /DbRepo/bkp/datadir
innodb_data_home_dir = /DbRepo/bkp/datadir
innodb_data_file_path = ibdata1:12M:autoextend
innodb_log_group_home_dir = /DbRepo/bkp/datadir
innodb_log_files_in_group = 2
innodb_log_file_size = 50331648
innodb_page_size = 16384
innodb_checksum_algorithm = innodb
innodb_undo_directory = /DbRepo/bkp/datadir
innodb_undo_tablespaces = 0
innodb_undo_logs = 128

mysqlbackup: INFO: Unique generated backup id for this is 15716055010820320

mysqlbackup: INFO: Creating 14 buffers each of size 16777216.
191021 00:05:03 mysqlbackup: INFO: Full Backup operation starts with following threads
1 read-threads 6 process-threads 1 write-threads
191021 00:05:03 mysqlbackup: INFO: System tablespace file format is Antelope.
191021 00:05:03 mysqlbackup: INFO: Starting to copy all innodb files...
mysqlbackup: INFO: Could not find binlog index file. binlogs will not be copied for this backup.
Point-In-Time-Recovery will not be possible.
If this is online backup then server may not have started with --log-bin.
You may specify its location with --log-bin-index option.
191021 00:05:03 mysqlbackup: INFO: Found checkpoint at lsn 2429669102659.
191021 00:05:03 mysqlbackup: INFO: Starting log scan from lsn 2429669102592.
191021 00:05:03 mysqlbackup: INFO: Copying log...
191021 00:05:03 mysqlbackup: INFO: Log copied, lsn 2429669183049.
191021 00:05:03 mysqlbackup: INFO: Copying /DbRepo/mysql/ibdata1 (Antelope file format).
mysqlbackup: Progress in MB: 200 400 600
mysqlbackup: ERROR: File_read operation failed for file /DbRepo/mysql/ibdata1. Error code: 5, Input/output error

mysqlbackup failed with errors!


Could anybody help, please?
Thanks.

Options: ReplyQuote


Subject
Views
Written By
Posted
mysql backup error after restore
887
October 22, 2019 04:19AM


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.