Ubuntu – the MySQL InnoDB log files stored


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?

Best Answer

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