SQL Import Error - Somewhat Urgent

[DieuxSoldat_04]

Hey Zenners,

I am trying to move my site from one Host to another. I followed the tutorials perfectly, I think, but I got an error.

Rundown:
I installed Fresh Zen Cart 1.3.8a.
Backed up configure files.
Made Back-ups for live store and database.
Uploaded live back-up to new install.
Went on myPHPadmin for new Database.
Dropped all Tables.
Went to import SQL file and got a error.

SQL query:
--
-- Table structure for table `zen_address_book`
--
DROP TABLE IF EXISTS `zen_address_book`

MySQL said:
#1046 - No Database Selected

I'm horrible with SQL! Please help! Time is money, owner won't be too happy, already asked me why it's down this morning, lol.

- Jason

[kobra]

Looks like you do not have a DB selected and active in phpmyadmin

[DieuxSoldat_04]

Awkward, I did though, Lol.

[DieuxSoldat_04]

SQL query:
SET @saved_cs_client = @ @character_set_client

MySQL said:
#1193 - Unknown system variable 'character_set_client'

New error. So its Character set problem. How can I resolve this?

Thanks in advance!
- Jason

[DrByte]

That error indicates that you've exported from a different version of MySQL than you're trying to import into, and the layout of the export data isn't fully compatible.

[DieuxSoldat_04]

Is there a method where I can make it compatible or maybe change an export setting?

- Jason