Hello again! I am trying to convert my tables to InnoDB, and i am getting an error...
Error: 1075 Incorrect table definition; there can be only one auto column and it must be defined as a key Now, I converted a table in my sandbox earlier this morning to do some testing, and it worked fine... mind you, i did truncate the table first, but i am not sure if that is relavent or not. The table structure has a TONNE of fields, but to give you an idea... here is what is starts out like: CREATE TABLE `radacct_201002` ( `Year_Month` INT(11) UNSIGNED NOT NULL DEFAULT '0', `Radacct_Id` INT(11) UNSIGNED ZEROFILL NOT NULL AUTO_INCREMENT, `Acct_Authentic` VARCHAR(32) DEFAULT '', Etc etc........ PRIMARY KEY (`Year_Month`,`Radacct_Id`), UNIQUE KEY `radacct_id` (`Radacct_Id`), KEY (there are keys here.... not of any relevance that i can see) ) ENGINE=INNODB DEFAULT CHARSET=latin1 That is the table in the sandbox, and as i said, all i did was truncate it, and change to innodb (there was prolly about 5-10 rows when i did it) and there wasn't any issues. When i do it to the live database (i copied a table of live data, so i can convert it and see what kind of times/loads i get) i get the error... I am in the midst of removing the combined unique primary key, to see if that is the culperate or not, but if anyone has any ideas, i am eager to listen :) Steve. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
