moved hosts, sql problem

ok so im moving hosts, luckily i have the .co.uk and .com for my site so iv just transferred one for now until i can get up and running properly.

anyway I followed the guide for switching hosts. Backed up my database from the opencart admin. backed up my files.
Iv installed the latest version of opencart on my new server. I updated my old server to make sure i had all the same files etc.

Iv uploaded my files from my old server barring the 2 config files.
Now im in phpmyadmin and have emptied the database without deleting it.
tried importing the backup sql and i get this error.

Error
SQL query:

TRUNCATE TABLE `address` ;


MySQL said:

#1146 - Table 'web141-a-openc-8.address' doesn't exist

so i went into the oc_address at the left hand side and changed the name to address, tried importing the sql backup again and it got past the first file and now has the same error for affiliate.

have i done something wrong? do i have to change every line now?
my site it currently throwing up an internal 500 error so i cant access the admin of opencart at the moment.

anyone?