MySQL Forums
Forum List  »  InnoDB

MYSQL Stops when importing the .ibd file
Posted by: Vaishak Shanbhag
Date: February 03, 2015 07:47AM

Hi

I am trying to import a table into the database from .ibd file. I created the table and discarded the tablespace using
Alter Table XXXX discard table space

Then I tried copied the file into the data folder and then ran query
Alter Table XXXX import table space

But after some time the query stops as the SQL service stops. The .ibd file is 10.38 GB.

The import worked with another file with same columns (small variation) that is about 4.2 GB.

Is there a parameter that I will have to extend to import the large file successfully.

It am in a bit of hurry.

Thanks Regards
Vaishak

Options: ReplyQuote


Subject
Views
Written By
Posted
MYSQL Stops when importing the .ibd file
2282
February 03, 2015 07:47AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.