Hello,
I know this is experimental and I know that I've done a terrible mistake but I've done it!... Now how can I repair?
Because, I'm not sure that this is my only problem, but it seems that I'm in big troubles :/
I'm running http://fr.ekopedia.org web site since 4 years and we are using Mediawiki since 2 years and half. The db have migrate from host to host (fortunately all Linux) and from MySQL versions to others. The db is actually a bit more than 300Mo and archives are available at: http://db.ekopedia.org/
My problems actually are: - it seems that there is multiples encoding inside the db (used iconv to check). - specials characters (like in esperanto) are turned into literal question marks. - mysqlhotcopy (a standard backup mysql tool) does a backup that is impossible to reimport. - dumpBackup.php seems to work perfectly but in time to reimporting, MySQL or mwdumper.jar say that some entry is already there and it stop without going further. - last but not least... Mediawiki application seems to get stucked sometimes on SQL queries. Result is that the server get so loaded that my only solution is to reboot!... This was happening not so frequently but now it's quiet all days.....
So does anyone can give me advises on how I can do ?
Thanks!! Jean-Luc