language mess-up on move

[Xanthouos]

I'm moving servers, and was having problems importing the DB on the new server. I read somewhere here that it needed to be exported as mysql4. That helped!
Problem is, the text from the site is in French, and on the new server, after DB import, it's all there, but the accents are messed up.
It seams there is a table missing in the export. How can I get/fix it?

Screenshot:
http://picasaweb.google.com/david.valia ... 3030738962

[garvinhicking]

Hi!

From which MySQL and PHP version are you moving to which one?

Moving from a MySQL 3.x Server to 4.x, or from 4.x to 3.x, or from 4.0 to 4.1 or from 4.1 to 4.0 can cause some serous problems because of MySQL 4.1 by default only using UTF-8.

Prepare to get some major headaches. Charset conversions are always very hard to to by importing, since there are 3 ways where you can "fuck up" (client charset, server charset, client/server charset on the export).

Best regards,
Garvin

[Xanthouos]

From:

phpMyAdmin - 2.9.0.2
MySQL client version: 4.1.10
Server version: 4.1.21-standard-log


to:

phpMyAdmin 2.6.4-pl2
MySQL 4.0.27-standard
PHP version 4.4.1

(is that the needed info??)

.....perhaps I should have exported the xml, to re-import? (I could change the nameserver back to the old host to do that export, and then back to the new one to import...) ...or is that re-inventing the wheel??

[garvinhicking]

Hi!

Okay. You are downgrading your MySQL to an older server.

That's bad. You will need to google for "UTF-8 MYSQL export import" and wade your way through. There's no common way I can recommend.

Maybe you can instead migrate to a server that also has MySQL 4.1. MySQL 4.0 also performs a lot slower than your old hoster.

XML-importing will create even more problems as the table structure cannot be migrated.

Best regards,
Garvin

[Xanthouos]

Hi!

Okay. You are downgrading your MySQL to an older server.

Maybe you can instead migrate to a server that also has MySQL 4.1. MySQL 4.0 also performs a lot slower than your old hoster.

....or ask them to upgrade....which they kindly did.

MySQL 4.1.21-standard

Works now, although still seams something was lost or garbled in the move...but nothing like the way it was before.
Thanks for the input Garvin!!

BTW, here's the work in progress: http://www.activezvous.ch