Take the 2-minute tour ×
Ask Ubuntu is a question and answer site for Ubuntu users and developers. It's 100% free, no registration required.

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?

share|improve this question
    
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

1 Answer 1

up vote 6 down vote accepted

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

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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