dump works at home, not on server ?

[dobbelina]

Hi !
I have a problem.
When uploading a sql dump from my home computer (with xampp 1.5.2),
to the server, I get errors relating to the "Collation".
It seems that the PhpMyadmin at the server doesn't have a collation column at all ?
So every time I upload a functioning db from home with the
"collate latin1_general_ci" in it I get errors relating to that..

The only way for me to get my dumps up, is to edit out all the collation
stuff from the sql files, as I have no idea how to get rid of it in another way.
Is there an easy way ?
There should be a tickbox in the export section of
PhpMyadmin, that would allow for this data to be kept out of the sql dumps, as obviously some mysql servers don't use it, or understand it.
Resulting in failed dumps..
All the dumps from the server that I download, doesn't contain anything
about "Collation", they import fine at home.
But if I then export that same dump up I get this problem, it's making me loose my sleep, please help !

[dobbelina]

bump

[dobbelina]

I found the solution elsewhere.
If somebody wonders, here it is:

From the Export screen you can select the compatability mode, in this case you'd want "MYSQL323".

Works beatifully, no collation junk in the exported dumps !