Now that I have corrected the sql problem, when I started moodle up it went to an "upgrade" php file and made some steps. When it got done I got a front page that looks like the attached. Is there an index file that may have been corrupted? I keep coming up with these unique problems. Sorry guys, any help, thanks.
I don't know what I'm supposed to be seeing here. More explanation please 
This is how it is suppose to look with the theme.This is from the hosted server, the view I showed you is the transfered to my new server,
Never mind, I found the problem. It was an ownership issue. Thanks every one so much.