you guessed correctly!
I used this command.
sed -e 's/character set latin1 collate latin1_bin/character set utf8
collate utf8_unicode_ci/gi' -e 's/CHARSET=latin1/CHARSET=utf8/g'
wikidb.190510.latin1.mysql > wikidb.190510.utf8.mysql
any hints on any error I could have made ?
thanks
Rick
Platonides wrote:
Riccardo Veraldi wrote:
ater trying to move from latin1 to utf8 and
conerting enconding using
sed I ahev this error:
mysql -u root -p < wikidb.190510-4.utf8.mysql
Enter password:
ERROR 1062 (23000) at line 237: Duplicate entry '0-Procom_Netforce_3000'
for key 2
I guess you used sed to change the KEY length? Which exact command did
you use?
the latin1 file instead works... looks like
something gets mangled
You can use the wiki with mysql thinking it's latin1.
_______________________________________________
MediaWiki-l mailing list
MediaWiki-l(a)lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-l