I try the other idea I had. - I create a page_title_blob field in wiki_page table, which is a binary blob. - sometimes, a query update wiki_page set page_title_blob=page_title In case of problem - a query update wiki_page set page_title=page_title_blob
If the binary blob is well dumped/imported, then a simple query could repair page_title field.
In a first time I planned to do it with complex php script, but Database class is a bit obscure for me, so I tried with queries in PhpMyAdmin, and it seems to work.
2007/5/7, Brion Vibber brion@wikimedia.org:
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
Sylvain Machefert wrote:
Hi Tim, is "Mysql 5 binary" schema working on MySQL 4.1-11 ?
In theory, however it may have some issues as it is not well tested.
is there a way to upgrade the datas to this better schema ?
We don't have an automated conversion worked out at this time, but you could probably do it with appropriate ALTER TABLEs. Might need some sort of conversion applied somewhere. Let us know if you work it out. :)
- -- brion vibber (brion @ wikimedia.org)
-----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.2.2 (Darwin) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
iD8DBQFGPznrwRnhpk1wk44RAo2sAKCpaF9Ws+b8kD93XPMUwgrFazwOSwCgxgWa whyz/6ESdH0GSXjCBWDW17E= =TfQS -----END PGP SIGNATURE-----
MediaWiki-l mailing list MediaWiki-l@lists.wikimedia.org http://lists.wikimedia.org/mailman/listinfo/mediawiki-l