moving server error

[Justttt]

hey i am moving servers so i have exported my coppermine database , when i import it to my new database i get this error

You have an error in your SQL syntax near 'ENGINE=MyISAM DEFAULT CHARSET=latin1 ' at line 18


and on that line is AUTO_INCREMENT=2 ;

any help please? ?

[Nibbler]

When you export, select compatibility options appropriate for the database type and version you will be importing the dump into.

[Justttt]

Yup Thanks Nibbler Your A Star , Problem Solved