查看错误日志/var/log/mysql/mysql.err

InnoDB: Error: log file ./ib_logfile0 is of different size 0 5242880 bytes
InnoDB: than specified in the .cnf file 0 268435456 bytes!

解决方法:

  1. 删除原来的innodb日志文件ib_logfile0,ib_logfile1
    [shell]rm /var/lib/mysql/ib_logfile*[/shell]
  2. 重启mysql,会自动重建innodb日志文件
    [shell]/etc/init.d/mysql restart[/shell]

    100619 19:20:17  InnoDB: Log file ./ib_logfile0 did not exist: new to be created
    InnoDB: Setting log file ./ib_logfile0 size to 256 MB
    InnoDB: Database physically writes the file full: wait…
    InnoDB: Progress in MB: 100 200