1. show engine for your tables: for example you try change table city, SHOW CREATE TABLE city: note: if you have another engine , try to change it: ALTER TABLE city ENGINE=INNODB