Home » Forums » MySQL on Windows » MySQL install or upgrade

MySQL upgrade problem

May 31, 2006 - 00:58
MySQL upgrade problem
SoKoOLz
Posts: 15
 Joined: 2006-05-23

Hi Chris,
It's me again, I've got a problem with my old host mysql.

I was using MySQLv.4.0.2.6 and I want to change it to MySQLv.4.1.2.0 instead. Due to the security issue. Anyway I've dumped my several of my databases and try to import them to new database. However, the new sql server gave me a lot of errors while importing tables and data.
Now after I've finished import my database, I've change back to my backup board which currently connected to the new database. The webboard looks fine but the posts and all the others data are messed up. I'm using Thai character(tis620) but now it appears as ???????? instead.
Do you know anyway to fix this issue?

Thanks,
Terry


add new comment | printer friendly version | delicious delicious | digg digg | reddit reddit | google google | technorati technorati

May 31, 2006 - 13:36
Hi Terry,
chris
Posts: 411
 Joined: 2006-01-02

Hi Terry,

Just got back online...
The main issue with this upgrade (4.0 -> 4.1) is that tables now require a caracther set. Using MySQL Administrator checek that your tables have the correct caracther set defined.

Check this out:
http://dev.mysql.com/doc/refman/4.1/en/charset-upgrading.html

Cheers,
C


reply