Package: mysql-server Version: 5.1.56-1 Severity: normal --- Please enter the report below this line. ---
Mysql turned off InnoDB on startup for some reason [1], and then it created all further tables as MyISAM. Even when CREATE TABLE explicitly specified ENGINE=InnoDB. I think Mysql should give an error if you ask it to create a table, and it doesn't have that engine enabled. [1] I specified innodb_buffer_pool_size = 768M innodb_log_file_size = 256M in my.cnf, presumably it didn't like the old logfile's size Confirmed via SHOW ENGINES, InnoDB wasn't there. After removing the logfiles and restarting InnoDB got enabled again. --- System information. --- Architecture: amd64 Kernel: Linux 2.6.39-rc4-phenom Debian Release: wheezy/sid 500 unstable ftp.ro.debian.org 500 unstable ftp.lug.ro 500 testing security.debian.org 500 testing ftp.ro.debian.org 500 stable ftp.ro.debian.org 1 experimental ftp.ro.debian.org --- Package information. --- Depends (Version) | Installed ===============================-+-=========== mysql-server-5.1 | 5.1.56-1 Package's Recommends field is empty. Package's Suggests field is empty. -- To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org