MySQL ODBC Connector - Can't reload from dump file

Author

Can't reload from dump file

Chris Mason

2006-01-29, 8:23 pm

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
Enter password:
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 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 copying the .frm file to the current database.
InnoDB: Then MySQL thinks the table exists, and DROP TABLE will
InnoDB: succeed.
InnoDB: You can look for further help from
InnoDB:
http://dev.mysql.com/doc/mysql/en/ ...g_datadict.html

What can I do?

--
Chris Mason
NetConcepts
(264) 497-5670 Fax: (264) 497-8463
Int: (305) 704-7249 Fax: (815)301-9759 UK 44.207.183.0271
Cell: 264-235-5670
Yahoo IM: netconcepts_anguilla
@yahoo.com

--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql? unsub...sie.nctu.edu.tw

Gleb Paharenko

2006-01-30, 7:23 am

Hello.

Perhaps, you haven't recreated the InnoDB tablespace after moving the
database. Recreate the InnoDB table space, or follow recommendations
from the error message. About InnoDB table space you can read here:
http://dev.mysql.com/doc/refman/5.0...figuration.html

Chris Mason (Lists) wrote:
> 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
> Enter password:
> 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 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 copying the .frm file to the current database.
> InnoDB: Then MySQL thinks the table exists, and DROP TABLE will
> InnoDB: succeed.
> InnoDB: You can look for further help from
> InnoDB:
> http://dev.mysql.com/doc/mysql/en/ ...g_datadict.html
>
> What can I do?
>

--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Gleb Paharenko
/ /|_/ / // /\ \/ /_/ / /__ Gleb.Paharenko@stripped
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET
<___/ www.mysql.com

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql? unsub...sie.nctu.edu.tw

Sponsored Links