upgrade - restore physical backups for mysql using xtrabackup -


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:

  1. innobackupex --use-memory=4g --apply-log /data/backups/2010-03-13_02-42-44/

  2. innobackupex --copy-back /data/backups/2010-03-13_02-42-44/

    the second step shows xtrabackup restored mysql database completely.

  3. 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.

similar problem


Comments