We have had some problems with corrupt data due to running out of space
recently. I wanted to repair the tables so I backed up our database by
dumping to a file with mysqldump. I then tried to repair the database
and had some problems with that.
I stopped MySQL and moved the database to database.old and restarted the
database. I wanted to import the dump file. As it is 700 MB it takes a
while to load.
I got this error
[root@server8 backups]# mysql -u root -p<rt3.sql
ERROR 1005 (HY000) at line 694: Can't create table
'./rt3/Attributes.frm' (errno: 121)
and in the error file:
060129 19:27:32 InnoDB: Error: table `rt3/Attributes` already exists in
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 copying the .frm file to the current database.
InnoDB: Then MySQL thinks the table exists, and DROP TABLE will
InnoDB: You can look for further help from
What can I do?
(264) 497-5670 Fax: (264) 497-8463
Int: (305) 704-7249 Fax: (815)301-9759 UK 44.207.183.0271
Yahoo IM: netconcepts_anguilla@stripped
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.