After several hours of pulling my hair out as well, I found a great plugin that does the entire job for you database and all — including changing the domain if you need to — All-in-One WP Migration. :woohoo: Just thought I would share in case anyone else has trouble.