1

This question already has an answer here:

I'm currently experiencing issues with my server MySQL databases as I keep receiving the following error:

InnoDB: The log sequence in ibdata files is higher
InnoDB: than the log sequence number in the ib_logfiles! Are database?
InnoDB: you are using the right ib_logfiles to start up the database?
InnoDB: Log sequence number in ib_logfiles in 6316712, log
InnoDB: sequence numbers stamped to ibdata file headers are between
InnoDB: 24916633497 and 24916633497

Hope someone can help me with this. Thanks, in advance!

marked as duplicate by RolandoMySQLDBA innodb Nov 10 '15 at 23:02

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.

  • Did something happen to the ib_logfiles? Did you move/restore them? – dwjv Nov 10 '15 at 12:47
  • When I first began having the issues I did not touch the files at all, but I tried restructuring the server therefore backing up, deleting then restoring the files and since then the same issue is occurring. – Richard Nov 10 '15 at 21:43
  • @Richard what mysql version are you running? – naschoff Nov 10 '15 at 22:32
  • I'm running version 5.5.46 – Richard Nov 12 '15 at 10:01
1
  1. Stop MySQL server;
  2. Check the error log see verify if your shutdown was successful. (No errors)
  3. Move your log files: mv /path/to/datadir/ib_logfile* /tmp/
  4. Start MySQL server. This will create new logs;
  5. When you’re absolutely sure that MySQL server has started successfully, you can remove the old log files: rm /tmp/ib_logfile*

    1. Possible roll back would be to repeat the steps again in this sequence: 1, reverse 3, 4.

Not the answer you're looking for? Browse other questions tagged or ask your own question.