I did restores successfully before, don't know what's wrong here.
1.I downloaded the whole blog files to c:/ and ftped it to the new host.
2. Made a sql backup and created the exact same mysql db at new host. When trying to restore sql, I get this error:
MySQL said: Documentation
#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEFAULT CHARSET=latin1 AUTO_INCREMENT=8' at line 32