ERROR 1034 (HY000) : Wrong aligned block, while importing in mysql
At first glance, I would say you have some corruption. But, this an import. That scares me. Take your mysqldump and run this:

head -20 SQLDump.sql


Does the dump contain DROP TABLE and CREATE TABLE ? My guess would be no.

Did you change the table structure, i.e.,


added columns to the table
removed columns from the table
changed charset/collation to utf8


after doing that mysqldump ? My guess would be yes.

If neither of these are the case, then your table has some corruption in the .frm.

Try installing MySQL on another DB Server and loading the SQLDump there. If nothing errors out, the mysqldump is fine. This verifies some corruption.

Try dropping the problem table, create it from scratch. Then, load it back. You could run myisamchk against the MyISAM table.


http://bugs.mysql.com/bug.php?id=44571
http://grokbase.com/t/mysql/mysql/123aqcrswa/help-the-dreaded-incorrect-key-file-for-table-xxxxxxx-try-to-repair-it-error