On 08/06/06, Brion Vibber brion@pobox.com wrote:
Ben Bullock wrote:
On 08/06/06, Brion Vibber brion@pobox.com wrote:
Can you:
- Show the exact error message if there is one
- Describe the exact difference between actual and expected behavior if there
isn't an error message ?
OK then. Apologies in advance for the length of this message.
I am running MediaWiki as follows: Special:Version
* MediaWiki: 1.6.3 * PHP: 4.4.2 (apache) * MySQL: 4.1.9
Wait a minute... your prior post talked about MySQL 4.0.16. Can you confirm that this was incorrect, and that you are in fact running 4.1.9?
Sorry, this is the version linked to PHP. The other version was the version given by the command line utilities, as in mysql --version. Since then they seem to have upgraded the command line utilities.
If so, any earlier advice I gave you based on the information you gave does not apply to your situation.
If you're using MySQL 4.1, and the default schema, than you generally must explicitly tell mysqldump to *not* perform bogus character set conversions. This for instance could mean passing --default-character-set=latin1 to suppress the bogus double UTF-8 conversion (which will corrupt your data irrecoverably). You'll have to take a poke at your configuration and the database layout to check what charset it thinks it's using natively.
OK, now I understand what happened. I tried saving again using the command line switch --default-character-set=latin1 and the wiki database was saved correctly.
Thank you very much for your help with this.