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 > [email protected] > https://lists.wikimedia.org/mailman/listinfo/mediawiki-l > _______________________________________________ MediaWiki-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
