Database error after transferring Drupal 6 site
Check that the table isn't corrupted or locked in some way. phpmyadmin should show you this when you view the list of tables in the database.

Try dropping the table and re-importing just that table, not the entire DB.