MYSQL Stops when importing the .ibd file
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
Subject
Views
Written By
Posted
MYSQL Stops when importing the .ibd file
2288
February 03, 2015 07:47AM
1079
February 03, 2015 11:09AM
953
February 03, 2015 06:18PM
1371
February 03, 2015 06:21PM
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.