#archiveteam 2012-02-23,Thu

↑back Search

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

irclogger-viewer