View Single Post

   
  #2 (permalink)  
Old 05-16-2008, 01:40 PM
MarisRuskulis
 
Posts: n/a
Default Re: migration from 4.0 to 5.0

Found partial sollution! Need to specify mysql_query("SET NAMES
'latin1'"); for connection charset.

MarisRuskulis wrote:
> Hello!
> I'm trying to migrate database from mysql 4.0 to 5.0 (latin1). So I
> maked dump from 4.0 and then restored it to 5.0, but without success
> because inside the web symbols isnt correct. On mysql 5.0 database
> charset is latin1 and "SHOW TABLE STATUS" shows that table is latin1.
> When I maked dump I passed --default-character-set=latin1 option, but
> without success. I even tryed to copy data files to 5.0 and the result
> is same.
> hope that someone will help me.
>
>
> ------------------------------------------------------------------------
>
>
>



Reply With Quote