* Re: [gentoo-dev] MySQL 4.0 => 4.1 upgrade
@ 2005-09-11 17:51 99% ` Francesco R
0 siblings, 0 replies; 1+ results
From: Francesco R @ 2005-09-11 17:51 UTC (permalink / raw
To: gentoo-dev
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
^ permalink raw reply [relevance 99%]
Results 1-1 of 1 | reverse | options above
-- pct% links below jump to the message on this page, permalinks otherwise --
2005-09-08 11:08 [gentoo-dev] MySQL 4.0 => 4.1 upgrade Francesco R
2005-09-10 22:01 ` Michael Kohl
2005-09-11 15:05 ` Francesco R
2005-09-11 16:02 ` Jason Stubbs
2005-09-11 17:51 99% ` Francesco R
This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox