SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
05-16-2008, 01:40 PM
| ||||
| ||||
 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.      |
|
05-16-2008, 01:40 PM
| |||
| |||
| 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. > > > ------------------------------------------------------------------------ > > > |
|
05-20-2008, 05:55 PM
| ||||
| ||||
| Re: migration from 4.0 to 5.0 You are right. Mysql 4.0 don't have a concept charset. 2008/5/16 MarisRuskulis <maris@co.inbox.lv>: > 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/mysql?unsub=y...0608@gmail.com > -- I'm a mysql DBA in china. More about me just visit here: http://yueliangdao0608.cublog.cn |
Linear Mode
