[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