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. :-)
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
4 years ago