Re: [gentoo-dev] MySQL 4.0 => 4.1 upgrade

[Francesco R <vivo@gentoo.org>]

Jason Stubbs wrote:

>On Monday 12 September 2005 00:05, Francesco R wrote:
>  
>
>>http://dev.gentoo.org/~vivo/doc/mysql-update.html
>>    
>>
>
>With step 2, you should probably mention the issues that can arise with 
>non-ASCII data in char fields. The character set really needs to specified 
>in the dump. After the upgrade to 4.1, the default charset of the server 
>should be set to something compatible and then the charset of the data 
>should be specified to mysql when re-importing the backup.
>  
>
--default-character-set=charset
should be that of my.cnf config file, mysqldump don't permit an atomic
setting of this variable.
The only option for this kind of users is to atomically dump the tables
and then concat the results.

Importing in mysql-4.1 it's ok, provided your default character set is utf8.

Russian, asian whatever person has experience on this please speak now
to correct what affermed here.

>Just another one of the many gotchas...
>
>  
>
expand this please

-- 
gentoo-dev@gentoo.org mailing list