Unable to restore a mysql database from dump produced by mysqldump

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.


Is it done yet?

The short answer is, don’t use mysqldump for really big tables.

Any explanation as to why not to use mysqldump on large tables? Any good alternatives for both innodb and myisam tables?