Thanks Guttu I tried that still get an error. From what support told me " You need to know SQL commands to do proper restore, that way you can check table and restore table by table if required and correct it if it shows an error."
So in light of that I guess I will be sticking with the free forun and just wasted my money buying a domain and hosting :(