i backup mysql database, , try restore in later version using xtrabackup, mysql service can't start up.
old mysql version:5.0.90;
new version:5.5.31
recovery steps:
innobackupex --use-memory=4g --apply-log /data/backups/2010-03-13_02-42-44/
innobackupex --copy-back /data/backups/2010-03-13_02-42-44/
the second step shows xtrabackup restored mysql database completely.
sudo mysql service start mysql
i try start mysql service, shows "job failed start".i check permission of these database files,as can see below.
-rw-r--r-- 1 mysql mysql 209715200 7月 11 06:02 ibdata1 -rw-r--r-- 1 mysql mysql 1048576000 7月 11 06:03 ib_logfile0 -rw-r--r-- 1 mysql mysql 1048576000 7月 11 06:03 ib_logfile1 drwxr-xr-x 2 mysql mysql 4096 7月 11 06:02 mysql drwxr-xr-x 2 mysql mysql 12288 7月 11 06:02 sp5084afbe48ce9 drwxr-xr-x 2 mysql mysql 4096 7月 11 06:02 test -rw-r--r-- 1 mysql mysql 52 7月 11 06:02 xtrabackup_binlog_pos_innodb -rw-r--r-- 1 mysql mysql 76 7月 11 06:02 xtrabackup_slave_info
this error:
innodb: error: log file ./ib_logfile0 of different size 0 1048576000 bytes innodb: specified in .cnf file 0 5242880 bytes! 130711 6:08:56 [error] plugin 'innodb' init function returned error. 130711 6:08:56 [error] plugin 'innodb' registration storage engine failed. 130711 6:08:56 [error] unknown/unsupported storage engine: innodb 130711 6:08:56 [error] aborting 130711 6:08:56 [note] /usr/sbin/mysqld: shutdown complete
check /etc/mysql/my.cnf
,
innodb_log_file_size = 5m
and change
innodb_log_file_size = 1000m
cause 1048576000/1024/1024=1000 , how innodb engine expecting log file size.
Comments
Post a Comment