dump works at home, not on server ?

Problems with the Windows version of XAMPP, questions, comments, and anything related.

dump works at home, not on server ?

Postby dobbelina » 21. May 2006 11:12

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
 
Posts: 17
Joined: 14. March 2005 09:33

Postby dobbelina » 23. May 2006 12:46

bump
dobbelina
 
Posts: 17
Joined: 14. March 2005 09:33

Postby dobbelina » 25. May 2006 09:08

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 ! :D
dobbelina
 
Posts: 17
Joined: 14. March 2005 09:33


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 38 guests