MySQL export from 4.0.x to 4.1x

[doom4]

i try to export my 4.0.x database to transfer it to another server with a running 4.1.x but it seems not working.

i tried to export it with phpmyadmin in the console with mysqldump.

does anybody has an idear?

greets

[Philantrop]

[magic919]

Ignoring my learned friend's split infinitive he has a point.

You'll need to help pinpoint where it is failing. Does mysqldump seem ok? Then does the import look fine? Does the database appear? Is this just a permissions/rights problem with the database when imported into the 4.1? Did you grant the correct rights? Can you check all this on the command line??

[doom4]

sorry i totally forget about that ups

okay with phpmyadmin it exports it but forgets some ' so i cant import it without adding everywhere '. so funny thing is that there are some ' but not everywhere.

mysqldump works fine but it doesent export german special character like öäü.

thats what i get from phpmyadmin see the bold part there is the ' for example missing:

INSERT INTO `mos_akobook` VALUES ('1', 'xxxxx', 'xxx xxx', 'xxx@xxx', '', , '2', 'Huhu Ihr beiden. - Das ist ja ne tolle Idee. - Ich hoffe, ich höre so etwas von und über Euch - auch wenn Ihr in weiter Ferne weilt -\r\n\r\nViele liebe Grüße von Ulli', 'xxxx', NULL, 'n', NULL, '1', '', '', '');

this is what i get from mysqldump look again at the bold part:

INSERT INTO mos_akobook VALUES (1,'xxxxx','xxxx','xxx
.de','','',2,'Huhu Ihr beiden. - Das ist ja ne tolle Idee. - Ich hoffe, ich h?re
so etwas von und ?ber Euch - auch wenn Ihr in weiter Ferne weilt -\r\n\r\nViele
liebe Gr??e von Ulli','xxxx',NULL,'n',NULL,1,'','','');


thx for help