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? |