Ben, you can search with Google http://www.google.com/advanced_group_search?hl=en with
InnoDB 121 That brings up the explanation which I pasted to the end of this email. Best regards, Heikki Innobase Oy sql query .............. Subject: innoDB (errno: 121) From: Ben Clewett Date: Tue, 18 Feb 2003 11:30:42 +0000 Using innoDB with Mysql 4.0.10-gamma-max-nt and getting lots of: MySql Error: Could not execute command [ ... ] on server because: Can't create table '.\rr\cons.frm' (errno: 121) Where 'rr' is the name of my database. Some of which I just can't get away from never mind what I do. My latest failure: create table if not exists cons ( code integer unsigned not null auto_increment primary key, items_count integer not null default 0 ) type=innodb This error (121) is not listed on http://www.innodb.com/ibman.html#Error_codes Is there somebody who knows what this is, and how I can get away from it? Regards, Ben. ................... From: "Heikki Tuuri" ([EMAIL PROTECTED]) Subject: Re: Innodb table with auto-increment column doesn't create (err 1005) View: Complete Thread (2 articles) Original Format Newsgroups: mailing.database.mysql Date: 2003-01-30 09:50:58 PST Matthias, what have you done? Below you create table 'foo' but mysql answers that it cannot create 'stundenliste.frm'. " mysql> create table foo (id int auto_increment,unique key (id)) type=innodb; ERROR 1005: Can't create table './test_smurf/stundenliste.frm' (errno: 121) mysql> create table stundenliste (id int auto_increment) type=innodb; ERROR 1075: Incorrect table definition; There can only be one auto column and it must be defined as a key mysql> create table stundenliste (id int auto_increment) type=myisam; *SUCCESS* " I guess you have the table stundenliste in the internal data dictionary of InnoDB, but have somehow managed to delete the .frm file. Look to the file yourhostname.err in the datadir of MySQL. You should find there: " heikki@hundin:~/mysql-standard-4.0.6-gamma-pc-linux-i686/bin> mysqld 030130 14:15:17 InnoDB: Started mysqld: ready for connections 030130 14:15:48 InnoDB: Error: table test/stundenliste already exists in InnoDB internal InnoDB: data dictionary. Have you deleted the .frm file InnoDB: and not used DROP TABLE? Have you used DROP DATABASE InnoDB: for InnoDB tables in MySQL version <= 3.23.43? InnoDB: See the Restrictions section of the InnoDB manual. InnoDB: You can drop the orphaned table inside InnoDB by InnoDB: creating an InnoDB table with the same name in another InnoDB: database and moving the .frm file to the current database. InnoDB: Then MySQL thinks the table exists, and DROP TABLE will InnoDB: succeed. InnoDB: You can look further help from section 15.1 of InnoDB: http://www.innodb.com/ibman.html " I tested deleting the .frm file manually and indeed I got: " heikki@hundin:~/mysql-standard-4.0.6-gamma-pc-linux-i686/bin> mysql test Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 to server version: 4.0.6-gamma-standard-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> create table stundenliste (id int auto_increment,unique key (id)) type=in nodb; ERROR 1005: Can't create table './test/stundenliste.frm' (errno: 121) mysql> " Regards, Heikki Innobase Oy sql query --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php