Re: migration from 4.0 to 5.0
You are right.
Mysql 4.0 don't have a concept charset.
2008/5/16 MarisRuskulis <[EMAIL PROTECTED]>:
> 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.
>
>
>
> --
>
>
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/[EMAIL PROTECTED]
>
--
I'm a mysql DBA in china.
More about me just visit here:
http://yueliangdao0608.cublog.cn
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.
>
>
>
>
>
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
migration from 4.0 to 5.0
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. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
