PhpMyAdmin/Sql problem when im trying to transfer database..

[Distance]

Yo.. im trying to export a database from one server and import to another..

export phpmyadmin version: 2.6.1-pl3
new server import phpmyadmin version: 2.8.0.2

When i use the vB option.. go onto maintainance and backup downloading the file this error comes up..

#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci' at line 7


The same error comes up when i export from the old server :s

On my old servers phpmyadmin.. when i export the database i have an option:
SQL export compatibility:

NONE
ANSI
DB2
MAXDB
MSSQL
MYSQL323
MYSQL40
ORACLE
POSTGRESQL
TRADITIONAL

does this have anything to do with it... please help :s

 

[Mictlantecuhtli]

SQL export compatibility might have something to do with it, I'd select MySQL40 from that list.

But I've had so many problems with PHPMyAdmin that I use command line instead, dump the database to a file with mysqldump and import it with source command in MySQL console.

 

[Distance]

no its still coming up with the error... sql40 didnt work

i think im gonna have to start again

 

[Mictlantecuhtli]

Can you post the whole SQL command causing the error?