[13:54:11] <mataniko>	 Hi, i'm trying to migrate a database from an older installation. My database has random collations so I ran the upgrade and cleanupAncientTables script and exported the old data and re-imported it into an empty mediawiki database
[13:54:22] <mataniko>	 everything looks ok, but the sidebar won't show on the new database
[13:54:25] <mataniko>	 shows fine on the old one
[13:54:48] <Reedy>	 sidebar?
[13:54:55] <mataniko>	 the navigation menu
[13:54:56] <Reedy>	 That should be skin related... not db related
[13:55:25] <mataniko>	 I'm using the same LocalSettings but pointing to my old (upgraded) database it shows 
[13:55:39] <mataniko>	 pointing to the new database - no side nav
[13:56:03] <mataniko>	  /MediaWiki:Sidebar is the same
[13:58:38] <mataniko>	 it's not that the sidebar is missing, it's just that the content from MediaWiki:Sidebar isn't populating it
[15:05:43] <niso>	 ive encountered this warning :"<!-- WARNING: template omitted, post-expand include size too large -->", and got o this page (https://www.mediawiki.org/wiki/Topic:Qncen9jblewc7y29) which advices to get the page size (works), but i cant find the default size of $wgMaxArticleSize and an other best practices about the its limitation), that safe just to pick random number?
[15:06:39] <niso>	 found it ty ^_^
[15:34:39] <Reedy>	 It's a pretty old version, so it's generally unsupported
[15:34:55] <Reedy>	 Even wikia run a newer version ;)
[15:35:56] <Reedy>	 ok, and?
[15:37:16] <Reedy>	 Can you not just visit it in a browser?
[15:38:55] <Reedy>	 Depending on what sort of format you want the data... You're going to do some work either via script
[15:39:29] <legoktm>	 !dump
[15:39:29] <wm-bot>	 For information on how to get dumps from Wikimedia Wikis, see http://meta.wikimedia.org/wiki/Data_dumps . For a how-to on importing dumps, see https://www.mediawiki.org/wiki/Manual:Importing_XML_dumps .
[15:39:55] <legoktm>	 rogen: https://www.mediawiki.org/wiki/Manual:DumpBackup.php is probably useful
[19:14:06] <mataniko>	 Reedy: Editing the sidebar page refreshed it and now it works
[19:15:45] <mataniko>	 I'm not sure if what i'm doing makes sense, but the old database was all MyISAM instead of InnoDB and a mix of collations
[19:17:08] <Reedy>	 myisam -> innodb is generally considered the way to go
[19:18:54] <mataniko>	 The old database had a mix of a couple latin1 collations on the tables, moving the data created some messy characters
[19:19:14] <mataniko>	 not sure if there's a proper way around this
[19:50:27] <mataniko>	 I tried playing with encoding, no matter what accented characters don't show up correctly in the database
[19:50:33] <mataniko>	 err wiki
[19:51:06] <mataniko>	 depending on the encoding they either show the same as on the wiki when looking at the database, or look correctly
[19:51:14] <mataniko>	 but never on the page
[20:03:00] <harmaahylje>	 mataniko: do you have the same encoding in the database?
[20:03:24] <mataniko>	 the original db encoding was latin1, the new database is binary
[20:03:51] <harmaahylje>	 what did you do to the data
[20:03:58] <harmaahylje>	 when migrating
[20:04:28] <bawolff>	 mataniko: I think its probably easiest to just dump the db, change the characters in the sql dump and then reimport
[20:05:18] <mataniko>	 first I pointed mediawiki to the old database and ran upgrade.php and clearAncientTables.php
[20:05:34] <mataniko>	 everything using the old db looks fine
[20:06:08] <bawolff>	 ok, if old db is fine, i'd say just reimport from old db
[20:06:13] <mataniko>	 then i used mysqldump to dump data only, no structure to get a copy of the data (which is latin1)
[20:06:34] <mataniko>	 and imported it into a new database that's been prepped by a fresh mediawiki install
[20:06:35] <Platonides>	 you need to pass a parameter to mysqldump so it dumps it as binary
[20:07:22] <mataniko>	 I tried to do --default-character-set=utf8
[20:07:43] <mataniko>	 it looks fine in the database, but still messed up when viewing the page
[20:08:17] <mataniko>	 i'll try with binary as the charset
[20:08:24] <Platonides>	 yes, try with binary
[20:09:02] <Platonides>	 mediawiki used a hack with old mysql versions, when binary didn't exist, by stating that the character set was latin1
[20:09:10] <Platonides>	 but inserting utf-8 data
[20:09:45] <Platonides>	 however, this means that programs relying on the character set specified in the db showed it incorrectly
[20:09:52] <Platonides>	 or even corrupted data
[20:10:34] <Platonides>	 you are also editing the charset at LocalSettings.php, right?
[20:11:15] <mataniko>	 no i haven't touched LocalSettings.php
[20:11:39] <mataniko>	 I think i might be seeing a cached page
[20:17:58] <mataniko>	 alright i think mysqldump as binary fixed it!
[20:18:17] <mataniko>	 I tried UTF8 and i either hit a cached page or it didn't work
[20:18:42] <mataniko>	 thank you
[20:19:12] <Platonides>	 :)
[20:19:16] <Platonides>	 you are welcome, mataniko 
[22:49:50] <bawolff>	 Hmm, the returnto code seems slightly broken when auto-login triggers from Special:Userlogin