11

I changed some settings for my InnoDB tables in MySQL and encountered the problem that InnoDB was not shown in SHOW ENGINES output. As an answer I got the suggestion to delete the log files of InnoDB. Where are these stored on Ubuntu?

  • ls /var/lib/mysql/ did the job. Every file ib_logfile0, iblogfile1 is a InnoDB logfile, if I am not mistaken, that is. :-) – Aufwind Aug 8 '11 at 0:54
  • You are correct, those are the innodb log files. – SpamapS Oct 1 '11 at 6:37
  • Aufwind, you should make your comment an answer and make this question "answered" – SpamapS Oct 31 '11 at 7:50
  • @SpamapS: Done! :-) – Aufwind Oct 31 '11 at 20:20
15

ls /var/lib/mysql/ did the job. Every file ib_logfile0, iblogfile1 is a InnoDB logfile, if I am not mistaken, that is. :-)

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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