mySQL charset problem

[evolver]

Hello All ,

We have a big problem about mySQL charset...

Once our mysql server version is 4.0.23.

Our customer's web site is now 4.1.x mysql server(in cpanel server).When I was upload the their SQL file on our server the characters is ruined on the web site

How can I solve this problem ?Please help us...It's urgent and strange problem for us...

Thank you.

 

[xemaps]

you can try to reload the database dump after verifying mysql charset settings and after erase db

this worked for me

 

[evolver]

you can try to reload the database dump after verifying mysql charset settings and after erase db

this worked for me

Once thank you for your message.

The problem is here How can I change or modify charset settings on mysql 4.0.23 ? in my.cnf ? if it is my.cnf how?

Thanks again...

 

[evolver]

anyone can help me

 

[kke]

anyone can help me

Which charset your customer use?

Try export db from phpmyadmin in the mysql 4.0 format

 

[evolver]

Which charset your customer use?

Try export db from phpmyadmin in the mysql 4.0 format

They used latin1 (turkish)

Thank you I will check the phpMyAdmin on cPanel server.

 

[evolver]

I have check the phpmyadmin but I don't see any information about export to 4.0

 

[kke]

I think thay use old version of phpmyadmin

try install phpmyadmin 2.7.0 or higher on cpanel and dump it

package form da should also usable
http://files.directadmin.com/services/9.0/
(also use config.inc.php from da server)

 

[evolver]

I think thay use old version of phpmyadmin

try install phpmyadmin 2.7.0 or higher on cpanel and dump it

package form da should also usable
http://files.directadmin.com/services/9.0/
(also use config.inc.php from da server)

Thank you for your message...
I was try it, download the backup file in MYSQL40 version...I was successfuly upload the SQL file on mySQL 4.0.x but the Turkish characters is ruined now...

I don't think how can I solve this problem...

The link is: http://212.174.113.100/~forum/index2.php

Thanks...

 

[Chrysalis]

As far as I am aware you cannot download a 4.1 formatted database in 4.0 format it is not backwards compatible.

You more or less need to remove extra 4.1 fields manually then import to 4.0.

I have only had to do this once but it was a pain to do and a while ago so I cant remember the specifics sorry.