Thanks for the response. These are the steps that I followed:
1. Exported SQL backup using WP-DB-Backup plugin and saved SQL to my local machine.
2. Setup domain on new host
3. Install WP on the new account with same admin and pwd
4. Through phpMyAdmin, on the same DB, import SQL saved in step 1
This worked for many of the domains, but failed in this specific case.
