今天在備份MYSQL資料庫的時候,導出TEST資料時發現報錯:
C:\Users\Administrator>mysqldump -u root -p test>test.sql
Enter password: ****
mysqldump: Got error: 1168: Unable to open underlying table which is differently
defined or of non-MyISAM type or doesn't exist when using LOCK TABLES
看到error描述:which is differently defined or of non-MyISAM type,我記得之前TEST資料庫裡面的引擎是INNODB,但我昨天測試的時候加了3張表是MYISAM的。難到是這樣是以備份不了。
如是我删除了MYISAM的表後:
C:\Users\Administrator>