Hello All,
I have made a dump of my database in which one table is pretty huge (about 4 million records) and has good number of indices(One full text index along with a primary key and 3 unique indices). When i try to restore this dump the restore hangs(its been running for five days now) when it tries to execute the statement which enables keys (ALTER table x ENABLE keys).
Any suggestions on how to go about restoring this dump are more than welcome. The table in question is a myisam table.
Thanks