[Mediawiki-l] Antwort: Re: moving contents
Ricardo Rodríguez - Your XEN ICT Team
webmaster at xen.net
Fri Oct 27 14:08:38 UTC 2006
>>> <christoph.huesler at css.ch> 17/10/2006 15:59 >>>
>Hi Ricardo,
>
>You are probably running mysql with a default encoding of utf-8. Try changing it to latin1.
>The reason for this error is, that mysql cannot store indexes longer than 1000 bytes.
>When using latin1, everything is fine. But with utf-8, each character needs 3 bytes,
>which exceeds that limit.
>hth
>-- chris
Hi Chris,
I got the point and did some tests here. Default encoding as reported by Navicat Connection Information window says 65001 (UTF-8) both in source and target databases. phpMyAdmin also both running on source and target servers reports the not same info:
Target:
MySQL charset: UTF-8 Unicode (utf8)
MySQL connection collation: utf8_unicode_ci
Source:
MySQL charset: UTF-8 Unicode (utf8)
MySQL connection collation: latin1_bin
In spite of the errors while exporting/importing, Navicat for Mac OS X did the trick. It throws the same error from time to time, but it normally ends the direct data transfer without a glitch. I am not able to understand why, but the work is done now.
Any input that helps to clarify this behaviour will be welcome! Thanks.
All the best,
Ricardo
--
Ricardo Rodríguez
Your XEN ICT Team
More information about the MediaWiki-l
mailing list