13

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?

4
  • 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, 2011 at 0:54
  • You are correct, those are the innodb log files.
    – SpamapS
    Oct 1, 2011 at 6:37
  • Aufwind, you should make your comment an answer and make this question "answered"
    – SpamapS
    Oct 31, 2011 at 7:50
  • @SpamapS: Done! :-)
    – Aufwind
    Oct 31, 2011 at 20:20

1 Answer 1

16

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

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .