[01:23] congrats SketchCow on being selected to give a keynote at JCDL [03:14] http://www.youtube.com/watch?v=IaFXlLizBgg [03:21] nitro2k01: dude, best virus ever [03:23] SketchCow: Future idea: virus documentary [03:24] +10000000 [11:07] someone has a full sql backup of a mediawiki i am interested in preserving the content of. what would be the best way to do this without him giving me a full dump? [12:58] Schbirid: What's your ultimate plan for the dump, and what's the size? [13:05] DoubleJ: partially having a 7z, but i also want to revive the content on my own website [13:06] OK, now I'm confused. You want to put it on your site, but you don't want to have it in your posession? [13:16] DoubleJ: it's complicated. i just want the contents, not the user accounts etc. :) [13:17] could probably just ask him to strip them out of the sql but it would rock if dumpgenerator could take a sql dump and make that into its format [13:24] Ah, I see. If you know the schema you should be able to do things like delete every line that begins with "insert into userAccountsTable" since IIRC MySQL dumps are 1 command/line [13:25] You'd end up with empty tables of the data you're not replicating online, but that doesn't really hurt anything. [13:25] Of course, maintaining the full file somewhere is also important. [13:25] Schbirid, did you try and read the documentation on mediawiki.org? [13:26] There's supposedly some info about how to dump raw tables, even if you don't want for some reason to produce an xml. [13:26] Nemo_bis: sadly the original server is not online anymore, all the owner has is the full sql dump [13:26] ah [13:26] should have said that, sorr [13:26] Well, I don't know anything about databases. :-) [13:27] Perhaps your problem is that you don't know which tables contain what data? [13:27] Or that you don't know how to edit those files? [13:28] he has the dump and i am thinking of a way how he can strip the juicy bits [13:28] i'll look into mediawiki's db structure [13:28] he is much smarter than me so i will just have to tell him some regexps or so :) [13:28] noo regexps :O [13:29] Anyway, you should only strip passwords and emails, perhaps real names: what else? [13:29] if this is about personal data. [17:39] MORNING [17:39] I am going to be the best keynote ever. [17:41] Hey, SO [17:42] ohai [17:42] =========================================================================== [17:42] I SPEAK TOMORROW ABOUT ARCHIVE TEAM TOMORROW. [17:42] TOMORROW THAT IS. TOMORROW. SEND ME A PHOTO OF YOURSELF AND YOU'RE IN IT [17:42] I DON'T CARE HOW AWFUL IT IS BUT PUT YOUR HANDLE IN IT [17:42] SCARE THE LIBRARY OF CONGRESS, MAKE THE ARCHIVISTS OF THE WORLD SHIT THEIR PANTS [17:43] JASON@TEXTFILES.COM - DO IT BY TONIGHT - SUBJECT LINE: ARCHIVE TEAM PHOTO [17:43] =========================================================================== [17:43] haha awesome [17:43] :3 [17:43] any way we can watch it remotely? [17:44] that would be awesome [17:46] are hats mandatory? [17:47] SketchCow: you want a big photo or more like avatar sized? [17:48] * dnova heads to blingee.com [17:48] SketchCow: also, mind if i pm you about a project i'm working on? [17:49] E-mail me. [17:50] They're not streamed but they're put up very shortly. [17:50] cool [17:50] hmm, is it the PDA conference time again? [17:53] balancing a harddisk on my head and taking a photo just made my droid reboot [17:53] hah [17:54] lol [17:57] hmm [17:58] I should go look for badass photos of me [18:01] if I had more time I'd attempt to recreate the rms st. ignatious photo [18:11] http://spirit.enjoys.it/stuff/schbirid.jpg [18:12] sadly it does not show my balancing skills properly [18:12] i was using no hands [18:13] crap forgot my handle [18:14] should i blingee it on? [18:14] aahah [18:15] PS: that harddisk has backups on it [18:17] SketchCow: "PUT YOUR HANDLE IN IT" <- text added later ok or do you want it on paper or something? [18:18] doh. too bad I shaved my long scraggly beard a week ago [18:20] Schbirid goes beyond "keyboard on head" and goes with keyboard, floppy drive, and hard drive [18:21] well i had to show that stupid phone who is boss [18:22] I could put a stack of hard drives on my head but I think it will end in bloodshed [18:49] I want a big photo. [18:49] It's getting to be my one year anniversary at Archive.org. [18:49] I am collecting all the shit we do into one location. [18:50] when is the actual deadline tonight [18:50] http://twitpic.com/8mgclq [18:54] Oh, just really anytime. [19:04] you should do a video version of the archive.org tour [19:09] I should. [19:26] OK, the archiveteam page on archive.org now has a subcollections collection. [19:51] http://www.archive.org/details/archiveteam-fire [20:45] fyi I just finished http://www.archive.org/details/konachan-siterip-2010 [20:46] I have 2011 and 2012 locally but am having some massaging issues [20:49] why did no one else link photos,.... boo [20:49] I'm at work so I can't really do one until evening [20:50] I'm still debating using an old one or making a new one [20:50] or not submitting one at all [20:50] dont be shy [22:14] ugh. didn't come out quite as well as it looked originally two weeks ago or so. [22:15] http://wegetsignal.org/tmp/coderjoe_hersheycensor.jpg [22:16] it also, sadly, doesn't have my floppy disk autoloader in the background [22:17] Is that golden pepsi some kind of different flavour? [22:17] caffeine free [22:17] that is, caffeine free regular pepsi [22:18] Pepsi without caffeine doesn't make sense [22:22] Any more photos? [22:26] oh hey [22:27] oh yea [22:27] SketchCow: normal photo size or more like avatar size? [22:27] http://bbot.org/etc/hello.jpg [22:27] if you're accepting cameraphone pictures [22:27] probably have something less terrible somewhere [22:29] Normal size preferred. [22:30] kk, i'll see if i have one [22:38] SketchCow: If you're so desperate that you take half pictures as well, here's one of me: http://db.tt/UODyhkXb :) [22:43] apparently the only good picture i have of myself is this one: http://frigolit.net/tmp/me.jpg [22:44] use it if you want [22:44] i'm gonna head off for some sleep, gn gn~ [22:45] SketchCow: is mine alright, or would you prefer something else? [23:04] hahaha [23:04] forgot this one of me was public [23:04] http://www.cosplay.com/photo/1096327/ [23:07] Coderjoe: Looks good [23:08] alard: Can you restart the statusboard? [23:11] let me just say [23:11] we fucking rule ETC! [23:19] SketchCow: running again. [23:25] Thsanks, man [23:28] alard: Is the gap around 12th-13th real or because we've not been running? [23:28] JASON@TEXTFILES.COM - DO IT BY TONIGHT [23:28] Was that tonight, or last night? [23:29] tonight [23:30] fuck yeah [23:40] This one's from a couple years ago; let me know if you want something newer/larger http://www.jasonfleshman.org/tmp/doublej.jpg [23:41] http://i.imgur.com/KxbBw.jpg [23:41] Is that too weird? [23:44] too weird for RedType, at least [23:55] SAVED FOREVER http://liveweb.archive.org/http://i.imgur.com/KxbBw.jpg [23:59] RedType?