InnoDB: Error: log file ./ib_logfile0 is of different size 5242880 bytes
[root@zhanglin bin]# ./xtrabackup --defaults-file=/etc/my.cnf --backup --log-stream --target-dir=/mysqlbak/xtrabackup/delta
./xtrabackup version 2.2.3 based on MySQL server 5.6.17 Linux (x86_64) (revision id: )
xtrabackup: uses posix_fadvise().
xtrabackup: cd to /usr/local/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:10M:autoextend
xtrabackup: innodb_log_group_home_dir = ./
xtrabackup: innodb_log_files_in_group = 2
xtrabackup: innodb_log_file_size = 50331648
InnoDB: Error: log file ./ib_logfile0 is of different size 5242880 bytes
InnoDB: than specified in the .cnf file 50331648 bytes!
對於使用了預設 my.cnf(一般教程都會教你使用support-files/my-medium.cnf)
如果中間使用了innodb的話,innodb預設的log file大小是56M
解決方法:
1、關閉資料庫,刪除日誌檔案(或者移動到其他目錄,以防MySQL起不來),重新啟動資料庫。
2、如果上面情況後,來時報同樣的錯誤,接下來修改配置檔案將日誌檔案大小設定成備份資料庫的配置大小(比當前要大很多也行)。
修改引數為:
innodb_log_file_size = 1G
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/30936525/viewspace-2016607/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- mysql innodb_log_file_size 和innodb_log_buffer_size引數MySql
- [ERROR] InnoDB: ibdata1 different size (rounded down to MB)Error
- mysql錯誤: [ERROR] InnoDB: auto-extending data file /data/ibdata1 is of a different size 768 pages...MySqlError
- ORA-27046: file size is not a multiple of logical block sizeBloC
- MySQL啟動報錯InnoDB: The innodb_system data file './ibdata1' is of a differentMySql
- PHP Fatal error: Allowed memory size of 1610612736 bytesPHPError
- error:unable to get logical block size for spfileErrorBloC
- redo的等待log file sync和log file parallel write和redo size設定Parallel
- Log check error: Log file /var/log/messages is not readable!Error
- Index column size too large. The maximum column size is 767 bytesIndex
- Index column size too large. The maximum column size is 767 bytes.Index
- xtrabackup備份mysql“ib_logfile0 is ofMySql
- ORA-27092: skgfofi: size of file exceeds file size limit of the processMIT
- File size 屬性
- gitignore by file size?Git
- 1709 - Index column size too large. The maximum column size is 767 bytes.Index
- 【MySQL】ERROR 1799 (HY000) innodb_online_alter_log_max_size引數過小的一則caseMySqlError
- [Err] 1709 - Index column size too large. The maximum column size is 767 bytes.Index
- MySQL建立表失敗:Index column size too large. The maximum column size is 767 bytesMySqlIndex
- MySQL 5.7 到 5.6,出現 Index column size too large. The maximum column size is 767 bytesMySqlIndex
- Allowed memory size of 134217728 bytes 錯誤解決心得
- (轉)innodb_doublewrite_file
- Oracle Log Block SizeOracleBloC
- MySQL innodb_buffer_pool_size 變數MySql變數
- mysql specified key was too long與Index column size too large. The maximum column size is 767 bytes.MySqlIndex
- log file sync 和 log file parallel writeParallel
- ORA-01189的完整解決過程(File is from a different RESETLOGS than previous files)
- MySQL資料庫index column size too large. the maximum column size is 767 bytes問題解決MySql資料庫Index
- ubuntu 命令列更改innodb_buffer_pool_sizeUbuntu命令列
- SAP Security Audit log size
- mysql5.7 資料匯入5.6 Index column size too large. The maximum column size is 767 bytes.MySqlIndex
- 測試中出現ERROR StatusLogger No log4j2 configuration fileError
- InnoDB undo log原理
- log file switch
- [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11Error
- Error 15: File not found for RedhatErrorRedhat
- Could not find first log file name in binary log index fileIndex
- ulimit: core file size: cannot modify limit: Operation not permittedMIT