Hi, I had these problem when migrating... Here is my solution, if like me you started with mysql4 (then at install/upgrade you say you have mysql4, not 5).
For each field which may contain some "national chars" and is not a blob, I created a field_blob which is the copy of the field. For example, page_title in wiki_page table, I created a page_title_blob, and a little query : update wiki_table set page_title_blob=page_title. In case of error during migration, do the reverse query ...set page_title=page_title_blob and it works, at least for me :-) I don't remember all field which may be concerned, there is one in wiki_text I think... This increase the database but it saved me once. The first time the host provider migrated from mysql4 to mysql5 and it was a catastrophe! So I corrected everything by hand (reaaallllly long!), added my field, and moved to another host provider accepting mysql4 :-D Hope this helps 2008/12/29 Giuseppe Briotti <[email protected]> > Did you use the phpMyAdmin tool for export import? I had a similar problem > and > I solved it when I noticed that phpMyAdmin showed a wrong charset for the > database engine (you can set charset for database engine, database and > table). > > Verify by mysql console, if possible, what is the charset setting. > > Hope this help > > Giuseppe > > > Message: 3 > > Date: Sun, 28 Dec 2008 21:34:16 +0100 > > From: "Mateusz Sobczak" <[email protected]> > > Subject: [Mediawiki-l] Page links with national characters disappeared > > after database migration > > To: [email protected] > > Message-ID: > > <[email protected]> > > Content-Type: text/plain; charset=ISO-8859-2 > > > > Hello, > > > > I need some help with the following problem (described also here: > > http://www.mediawiki.org/wiki/Project:Support_desk/Sections/Database). > > > > I am moving a MediaWiki based webpage from one server to another. > > After exporting the database and importing it to the new server I got > > the message "1271: Illegal mix of collations for operation ' IN ' > > (mysql.extremefaith.info)". So I updated MediaWiki to the newest > > stable version (1.13.3) which caused the change of the $wgDBmysql5 > > variable value to "true" and that solved the problem. > > > > Yet another one appeared. Although the content of the present pages > > remained unchanged (all the national characters were present) all the > > links with national characters became "red" (f.ex. "?nie?nobia?e > > ?wiat?o") and I can't access the content of those pages. What's more > > when I add the content manually some pages still remain "red". When I > > click on this kind of edited-"red" page I can see the content but it's > > being opened in "edit" tab by default. All the tables have > > "latin2_general_ci" collation set. > > > > Could you please help me to fix the "red" links with national characters? > > > > (You can see the red links f.ex. here: > > > > http://mat.extremefaith.info/kpk/mediawiki-1.13.3/index.php?title=Teksty_pie%C5%9Bni > ) > > > > server1: > > * MediaWiki: 1.10alpha > > * PHP: 5.2.6 (ucgi5) > > * MySQL: 5.0.66a-log > > * URL: http://www.krokpokroku.pl/wiki/index.php?title=Inspiracje > > > > server2: > > * MediaWiki: 1.13.3 > > * PHP: 5.2.6 (cgi-fcgi) > > * MySQL: 5.0.67-log > > * URL: > > http://mat.extremefaith.info/kpk/mediawiki-1.13.3/index.php?title=Inspiracje > > > > > > Regards, > > > > -- > > Mateusz Sobczak <>< > > -- > > Giuseppe Briotti > [email protected] > > "Alme Sol, curru nitido diem qui > promis et celas aliusque et idem > nasceris, possis nihil urbe Roma > visere maius." > (Orazio) > _______________________________________________ > MediaWiki-l mailing list > [email protected] > https://lists.wikimedia.org/mailman/listinfo/mediawiki-l > -- Sylvain Machefert Tous aux Balkans ! http://www.tousauxbalkans.net _______________________________________________ MediaWiki-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
