Re: [Mediawiki-l] MediaWiki-l Digest, Vol 41, Issue 61

Send MediaWiki-l mailing list submissions to mediawiki-l(a)lists.wikimedia.org To subscribe or unsubscribe via the World Wide Web, visit http://lists.wikimedia.org/mailman/listinfo/mediawiki-l or, via email, send a message with subject or body 'help' to mediawiki-l-request(a)lists.wikimedia.org You can reach the person managing the list at mediawiki-l-owner(a)lists.wikimedia.org When replying, please edit your Subject line so it is more specific than "Re: Contents of MediaWiki-l digest..." Today's Topics: 1. Re: Flash extensions for MW 1.6.9? (Fernando Correia) 2. Fwd: Who can fix an option in xml2sql.exe? (Rolf Lampa) 3. Who can fix an option in xml2sql.exe? (Rolf Lampa) 4. Re: Who can fix an option in xml2sql.exe? (Brion Vibber) 5. Re: Who can fix an option in xml2sql.exe? (Rolf Lampa) 6. Re: Who can fix an option in xml2sql.exe? (Samuel Lampa) ---------------------------------------------------------------------- Message: 1 Date: Thu, 22 Feb 2007 07:02:57 -0300 From: "Fernando Correia" <fernandoacorreia(a)gmail.com> Subject: Re: [Mediawiki-l] Flash extensions for MW 1.6.9? To: "MediaWiki announcements and site admin list" <mediawiki-l(a)lists.wikimedia.org> Message-ID: <8140eff40702220202i18d16b48v6479d7a9cc83db2c(a)mail.gmail.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed 2007/2/21, Ken McDonald <ken(a)pixologic.com>om>: I've written a Flash extension named LinkSwf because the existing ones didn't quite satisfy the requirements of the users of our corporate wiki. Features * Plays the video on a maximized window. * Works on Internet Explorer and Firefox. * Can stretch the video to fill the window or play it in a predefined size. * Supports detection and update of the Flash Video player. * Can be used inside a template. I'm not sure if it would work with version 1.6, though. http://www.mediawiki.org/wiki/Extension:LinkSwf/LinkSwf.php ------------------------------ Message: 2 Date: Thu, 22 Feb 2007 11:38:54 +0100 From: Rolf Lampa <rolf.lampa(a)rilnet.com> Subject: [Mediawiki-l] Fwd: Who can fix an option in xml2sql.exe? To: mediawiki-l(a)lists.wikimedia.org Message-ID: <45DD72BE.3050305(a)rilnet.com> Content-Type: text/plain; charset="iso-8859-1" ------------------------------ Message: 3 Date: Thu, 22 Feb 2007 11:44:33 +0100 From: Rolf Lampa <rolf.lampa(a)rilnet.com> Subject: [Mediawiki-l] Who can fix an option in xml2sql.exe? To: mediawiki-l(a)lists.wikimedia.org Message-ID: <45DD7411.1050704(a)rilnet.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Hi all, Unfortunately the xml2sql.exe makes extended inserts (by n rows) when producing MySQL's INSERT format. Problem is that when there's HUGE pages in the xml dump (like some pages in Wikipedia) then one have to reduce the number of rows per "batch" when uploading with BigDump.php, otherwise the upload will surely crash. But reducing the amount of rows per batch makes upload very slow... If the produced output would (optionally) be NOT extended, I could more easily* fix the INSERTS on my own (reshuffling the sql by total *size* - instead of "extending" the inserts by a certain number of rows). Suggested solution: #1: Option: --noextended or (example, make extended inserts by size (kb) instead: #2: Option: --extendedbykb 512 But the developer Toetew (http://meta.wikimedia.org/wiki/User_talk:Tietew#Hyper_Estraider_extension) doesn't seem to be very active. Can the source code be modified, and if so, who's expert on ANSI C...? Or perhaps someone knows how to get in contact with Tietew? Regards, // Rolf Lampa [*] - more easy: In order to "tear apart" the extended INSERTS into separate rows again (in order to pack them again later, but by total size instead) I need to use three different Regex for finding where to split the INSERT for page.sql, revision.sql and text.sql respectively. But sometimes the text-table gets messed up anyway (it tends to do so when trying to split articles containg like sql code examples and the alike... ). ------------------------------ Message: 4 Date: Thu, 22 Feb 2007 03:02:56 -0800 From: Brion Vibber <brion(a)pobox.com> Subject: Re: [Mediawiki-l] Who can fix an option in xml2sql.exe? To: MediaWiki announcements and site admin list <mediawiki-l(a)lists.wikimedia.org> Message-ID: <45DD7860.7060109(a)pobox.com> Content-Type: text/plain; charset=ISO-8859-1 -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Rolf Lampa wrote: Don't know what xml2sql.exe is or where it comes from; Google search turns up something that looks unrelated to wikis and is documented only in German. Have you tried mwdumper, which we maintain? - -- brion vibber (brion @ pobox.com / brion @ wikimedia.org) ------------------------------ Message: 5 Date: Thu, 22 Feb 2007 12:18:15 +0100 From: Rolf Lampa <rolf.lampa(a)rilnet.com> Subject: Re: [Mediawiki-l] Who can fix an option in xml2sql.exe? To: MediaWiki announcements and site admin list <mediawiki-l(a)lists.wikimedia.org> Message-ID: <45DD7BF7.8020002(a)rilnet.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Brion Vibber wrote: http://meta.wikimedia.org/wiki/Xml2sql No I have not tried that one. I read about it today though (only briefly, it was only mentioned in short amongst other tools) and I didn't "get hooked". Where is the best reading on mwdumper? (or do I really have to try it out... =). I use WinXP & xampplite and I produce data and also process existing xml data locally (fast Delphi-app) before upload. Regards, // Rolf Lampa ------------------------------ Message: 6 Date: Thu, 22 Feb 2007 12:24:01 +0100 From: Samuel Lampa <shl(a)rilpedia.org> Subject: Re: [Mediawiki-l] Who can fix an option in xml2sql.exe? To: MediaWiki announcements and site admin list <mediawiki-l(a)lists.wikimedia.org> Message-ID: <45DD7D51.3030000(a)rilpedia.org> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Brion Vibber skrev: Try http://meta.wikimedia.org/wiki/Xml2sql -- Samuel Lampa http://rilnet.com ------------------------------ _______________________________________________ MediaWiki-l mailing list MediaWiki-l(a)lists.wikimedia.org http://lists.wikimedia.org/mailman/listinfo/mediawiki-l End of MediaWiki-l Digest, Vol 41, Issue 61 *******************************************