>From MySQL Manual: "If you want to change the number or the size of your InnoDB log files, you have to shut down MySQL and make sure that it shuts down without errors. Then copy the old log files into a safe place just in case something went wrong in the shutdown and you will need them to recover the database. Delete then the old log files from the log file directory, edit `my.cnf', and start MySQL again. InnoDB will tell you at the startup that it is creating new log files."
I hope it can help you. Janusz ------------------ Kevin Carlson wrote: > > Using a backup I recreated the /var/lib/mysql directory and when I > restart mysqld I am getting the following error: > > InnoDB: Error: log file /var/lib/mysql/ib_logfile0 is of a different > size 0 5238827 byes > InnoDB: than specified in the .cnf file 0 5242880 > > Of course, the database never starts because of this. Oddly, if I move > the backup to another machine that is running the same version of MySQL > (same OS and version), the database starts correctly. > > I have tried running mysqld with and without a my.cnf file present and > have changed some of the values regarding the logfile size but have not > been able to successfully start the database. Is anyone aware of any > workaround for this? > > Thanks, > > Kevin -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
