Here is what I have done:
1. Made addon domain "colonirritable.net" in HostGator, installed Wordpress 3.5.
2. Replaced entire "wp-content" directory with my old "wp-content" directory from SEOHost.
THE KEY PLACES WHERE I PROBABLY MADE A MISTAKE:
3. In "PHP MyAdmin"- selected Databases> Selected the new Hostgator Database> Selected "Import"> Imported old database from SEOHost(after editing username to match the current one)
Now the database is "there" in PHP MyAdmin but it is not being connected to.
I also replaced the wp-config.php file and changed the DB_USER to the database I want- but the password I left the same as the database in SEOHost because I don't know if it has changed when I imported it or what.
Does anyone have experience with this?