I'm having a very strange problem. I have a website on Pantheon (Nginx) that I attempting to import into my local dev environment, but when I import, it is failing when it gets to the cache_rules table. So I dropped the cache_rules table on the server DB, dumped the DB, and imported it, and then tried to re-create the cache_rules table with the following command:
CREATE TABLE IF NOT EXISTS `cache_rules` ( `cid` varchar(255) NOT NULL DEFAULT '' COMMENT 'Primary Key: Unique cache ID.', `data` longblob COMMENT 'A collection of data to cache.', `expire` int(11) NOT NULL DEFAULT '0' COMMENT 'A Unix timestamp indicating when the cache entry should expire, or 0 for never.', `created` int(11) NOT NULL DEFAULT '0' COMMENT 'A Unix timestamp indicating when the cache entry was created.', `serialized` smallint(6) NOT NULL DEFAULT '0' COMMENT 'A flag to indicate whether content is serialized (1) or not (0).', PRIMARY KEY (`cid`), KEY `expire` (`expire`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Cache table for the rules engine to store configured items.';
which I found here. I am running the command in phpMyAdmin.
However, when I do that, I get this error message:
"Can't create table errno: -1"
I've attempted to search for this but the explanations suggested that it was usually caused by trying to create a table that had a key that depended on another table that hadn't been created yet, but that is not the case here.
I can run the exact same command above with a different table name (e.g., cache_rules2) and a cache_rules2 table will be created without a problem-- so it's only the specific name cache_rules that is causing this issue, whatever it is.
How can I further debug this to figure out why it suddenly doesn't want to create a cache_rules table?