How to convert big/large table from MyISAM to InnoDB?
Hello,
I have a MyISAM table with approx 120.000.000 entries.
How can I convert it into an InnoDB table?
I had generate a new InnoDB table without indexes and copied all the data into it.
Then I altered the table and tried to add the primary index key. But this fails and the mysqld did not answered anymore.
After I killed the prozess and started the mysqld again the server runs, but still with the MyISAM table.
Thanks
Oliver
Subject
Views
Written By
Posted
How to convert big/large table from MyISAM to InnoDB?
3446
May 14, 2008 04:30AM
1623
May 23, 2008 10:28PM
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.