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@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-l