@ KingOfDCP - That was it right there . just before you posted this i went and found that setting and adjusted it . thinking i already did when i configured a bunch of settings for the vps .

i also took donhopkin's advice and did this mysql -u username -p databasename < database.sql again . i must have did this line 3 times . so after ruffly 3-5 min it was finished this time .

So now thanks to the help i got here its now up and running

Thanks everyone for your help .

now to make a backup with mysqldumper and save it . i do like that program.

Again . Thank you .


Edit : i used mysql -u username -p databasename < database.sql not mysql -u username -p databasename < database.sql.gz or database.gz .