log☇︎
34000+ entries in 0.352s
CompanionCube: https://en.wikipedia.org/wiki/Wakanda_(comics)
shinohai: https://pbs.twimg.com/media/C8n4cyrWAAQ_MIt.jpg
Framedragger: mircea_popescu: by text-only i meant the *output*, it can certainly handle binary blobs
Framedragger: typical small .sql is usually just a set of "INSERT INTO .. VALUES ..", but mircea_popescu is running a large escher megasite, so i'm less certain..
Framedragger: mircea_popescu: .sql is a set of statements which you can run on db to put it back into the state which produced the .sql in question, no? but, if there's mysql specific convention bullshit tho, i wouldn't know :/
a111: Logged on 2017-02-14 00:14 mircea_popescu: gabriel_laddel_p if it could detect and wipe the idiotic wrap(80) thing that'd be great.
asciilifeform: gabriel_laddel_p: what am i looking at
Framedragger: mircea_popescu: hm okok. an .sql file should not contain any non-printable chars so that in itself is alarming.. weird
a111: Logged on 2017-04-06 18:16 gabriel_laddel_p: https://docs.google.com/document/d/1tQ8nHp2wWD-U4c7l8FbZgW3GJfhni78hDZJH4ihKSpI/edit?usp=sharing
deedbot: gabriel_laddel_p voiced for 30 minutes.
asciilifeform: !!up gabriel_laddel_p
asciilifeform: cat file.foo | tr -d '\000' > new_file.foo
asciilifeform: ( it suggests that mircea_popescu's sql dump isn't 7bit clean )
asciilifeform: mircea_popescu: is it really ^@ or is that just what you get out of the terminal
mircea_popescu: tail -n+150000 tril_posts.sql | head -n5 > hurr.txt produces empty file ; meanwhile wc -l claims 111119289
Framedragger: mircea_popescu: recently had to tail multigb files, it was *instant* (because, seeks to end of file). seems like a disk prob to me
a111: Logged on 2017-04-06 19:05 mircea_popescu: head doesn't work on a large file.
CompanionCube: mircea_popescu: it seems the feature was introduced in this release: https://git.savannah.gnu.org/cgit/coreutils.git/tree/NEWS#n355
mircea_popescu: 111119289 tril_posts.sql << that took ~5 minutes of wc time.
asciilifeform: also mircea_popescu how didja know that 'dd hanged' rather than merely taking long time
asciilifeform: if this is anything like past cases, mircea_popescu's box is peculiar in some way literally nobody else could possibly guess
asciilifeform: mircea_popescu: if you want 'what box came with', that means standard retarded unixland
asciilifeform: (or 'dd_rescue', they are -- perversely -- separate proggies by separate people, that do ~same thing )
jhvh1: mircea_popescu: bannon :: When a person or animal gets high on a substance, often in unexpected places. This usually ends in chaos for everyone. [ex:] At school all my friends bannoned on sharpies. [/ex]
jhvh1: mircea_popescu: trump :: 1. To have superior power over.2. To surpass or outdo.3. When a person says "trump," you are required to do whatever you just claimed you would do, no matter how exaggerated it was. If you don't do it, you get a [spartan kick] to the chest. [ex:] 1. Bob: The president's word trumps yours, Joe, you homeless piece of shit. When he says something it must be done.2. Joe: Man, I'll trump your ass (5 more messages)
jhvh1: mircea_popescu: obama :: The Messiah for brain-dead Democrats. [ex:] No matter what he says, no matter what he does, they'll worship the great Obama. [/ex] | An acronym standing for One BigAss Mistake,America! [ex:] Q: What was the result of the 2008 election?A: OBAMA [/ex] | Has no real experience, because most of his time as "senator" was spent campaigning for his own election to President. Is praised (10 more messages)
jhvh1: mircea_popescu: ERROR: 'woke whore' not defined on UrbanDictionary.
shinohai: Turned !~ud bqck on mircea_popescu ... cheers!
trinque 100% in favor of ben_vulpes' p-peddle to the metal m-morty approach to end of the state
trinque: mircea_popescu: universal basic income
jhvh1: mircea_popescu: Error: "ud" is not a valid command.
trinque: ben_vulpes: compulsory leave?
asciilifeform: next day ben_vulpes went to a boar hunt, could not resist eating the bacon he brought in a bag himself...
shinohai: buenas tardes ben_vulpes, listo para cojer putas?
gabriel_laddel_p: ben_vulpes: hello!
trinque: in this thread we listen to how gabriel_laddel_p is very special, and you don't understand me mom
trinque: gabriel_laddel_p: why the FUCK would you spend any time whatsoever on doing it that way?
Framedragger: gabriel_laddel_p: ideally it would also save a full 'rich' version (whole DOM) but without JS, the way archive.is does
Framedragger: mircea_popescu: hm.. okay. wonder why it failed. (i guess in the future consider LONGBLOB for this (and encode/decode as needed), but it wasn't..that large, even.. huh.)
asciilifeform: gabriel_laddel_p: where do you host this ? also google ?
asciilifeform: didn't somebody finally buy the gabriel_laddel_p box ..?
gabriel_laddel_p: mircea_popescu: no wrap(80) for the archiver.
deedbot: gabriel_laddel_p voiced for 30 minutes.
asciilifeform: !!up gabriel_laddel_p
asciilifeform: mircea_popescu: and they also stole the ip range of google corp ?
asciilifeform: mircea_popescu: the odd thing is, it did anyway -- until somewhat recently
Framedragger: pete_dushenski: plox to update bot commands at some point, ty! :)
asciilifeform: i recall, we had a thread where mircea_popescu: 'it never once crashed'
Framedragger: mebbe you had a separate /var partition from linux install long ago, mircea_popescu.. this can bite
BingoBoingo: <mircea_popescu> incredible. this is even legal ? << O hai I R the packet interceptor. Pls to pay again for delivery.
asciilifeform: what's your sector size, mircea_popescu ?
mircea_popescu: 39491524 /var/lib/mysql/trilema_blog/tril_posts.MYD << reported by du | 40439263232 Apr 6 11:12 tril_posts.MYD << reported by ls -l
mircea_popescu: 40439263232 Apr 6 11:12 tril_posts.MYD
asciilifeform: mircea_popescu: i seem to recall ~200MB last time you tallied it and posted here (6 mo ago ?)
lobbes: mircea_popescu: Nah nothing really. I noticed you pasted that link earlier but bot didn't quote. I think you were just too fast for it
lobbesbot: Logged on 2017-04-06 00:05:55: <mircea_popescu> until trinque's deedbot payment is on i dunno what lightweight to recommend you
Framedragger: mircea_popescu: sorry i forgot or didn't know that you actually in fact restarted it.
Framedragger: mircea_popescu: well you can still kill the particular mysql process which is handling the query, `show processlist` (may show "Waiting for table metadata lock" under "State" column; "Info" column should display the query in question), then `Kill IDGOESHERE`
Framedragger: do you still have a running mysql cli session mircea_popescu?
a111: Logged on 2016-12-30 17:16 mircea_popescu: it really should be up to operator wtf, if i want to read dirty let me read dirty what sort of decision is this for designer to make.
asciilifeform: mircea_popescu: you don't , http://btcbase.org/log/2016-12-30#1593662 ☝︎
asciilifeform: welcome to sql hell mircea_popescu
Framedragger: hmh it should at least fail, or sth. is it still running mircea_popescu? can you do `show processlist` with separate mysql client session? (NB, am not a mysql guy)
Framedragger: what's the column data type mircea_popescu
Framedragger: mircea_popescu: you're putting it in mysql aren't you, and making php generate a table or sth?
a111: Logged on 2017-04-06 13:28 Framedragger: btw asciilifeform mircea_popescu i'm rehosting the main '/stats' page here, autoredownload every 5min (handles http timeout cases): http://siphnos.mkj.lt/phuctor-stats/
asciilifeform: mircea_popescu finally cured of 'maga' ?
Framedragger: mircea_popescu: if you're planning to rehost, maybe useful (very simplistic, i've just put this into cron for now): http://siphnos.mkj.lt/phuctor-stats/download-stats.sh
asciilifeform: aseriousgogetta (~Kimberley@ip-64-134-144-245.public.wayport.net) has joined #trilema << hey mircea_popescu , can haz hammer ? every time that monkey's connection cycles, i feel like a chimp is throwing shit in my face
Framedragger: btw asciilifeform mircea_popescu i'm rehosting the main '/stats' page here, autoredownload every 5min (handles http timeout cases): http://siphnos.mkj.lt/phuctor-stats/ ☟︎
asciilifeform: http://www.loper-os.org/pub/snap/ph_snap.html << example
asciilifeform: http://btcbase.org/log/2016-12-08#1579779 << mircea_popescu ☝︎
asciilifeform: mircea_popescu: yes, 1s
a111: Logged on 2017-04-06 12:43 mircea_popescu: lel. the cheapest is for the site to support it natively!
a111: Logged on 2017-04-06 12:33 mircea_popescu: except google can't index it because the /stats/ dies on it i guess.
a111: Logged on 2017-04-06 12:29 mircea_popescu: asciilifeform https://www.google.com/search?q=phuctor&channel=fs&tbas=0&tbs=qdr:m&* << notice anything missing ?
Framedragger: mircea_popescu: ahahahaha it does say "MUM" (should be "Mon" of course)
Framedragger: that is exactly what it means mircea_popescu lol
mircea_popescu: dat day when ben_vulpes 's pastatron allocates you UriNe as an identifier...
a111: Logged on 2017-03-29 16:25 mircea_popescu: if you find it within yoruself to post forms you were issued that'd be grand.
asciilifeform: mircea_popescu: one of the flying sims i leeched on warez , for winblows box, was 40G or so
shinohai: They might read trilema, see mircea_popescu in earlier days with joofro and start pogrom
shinohai hopes mircea_popescu 's Russian chicks aren't anti-semitic
asciilifeform: mircea_popescu: phun phakt, solar cells quickly disappear under grime, dead leaves, bird shit, unless regularly cleaned (~nobody cleans.)
asciilifeform: mircea_popescu: 731 Wh is approx enough to run.. a pogo.
asciilifeform: mircea_popescu: these are per-panel
a111: Logged on 2017-04-06 02:27 mircea_popescu: asciilifeform lulz of all time : you can get further victims AS THEY ARE INDEXED BY GOOGLE through for instance searching for "800-00038-r08" or such strings. you get a very lulzy welcome if selecting eg "deutshc" : everything's "translation missing"
asciilifeform: mircea_popescu: http://btcbase.org/log/2017-04-06#1638665 >>> http://btcbase.org/log/2017-04-06#1638599 ☝︎☝︎
BingoBoingo: <mircea_popescu> anyway, no explaining, ridiculous move. << perhaps move to lure pantsuits into self hanging? Either that or clog fake news circuit.
BingoBoingo: <asciilifeform> if mircea_popescu dun feel like qntra -- BingoBoingo , then ? << I can/will qntra, but in the future when you are lulzing about the details of a thing and are unsure if editor is awake/digging-liming holes/trying to get older sober lady to 13th step him, maybe consider writing a qntra while you have and are playing with the details? Makes for more timely publication when editor is awake? Publication can happen faster when
mod6: <+asciilifeform> mod6 ? << need some perl? <+mircea_popescu> asciilifeform working on list. << looks like mp is on it.
phf: i'm going to become this guy instead http://farm6.staticflickr.com/5292/5561497850_c1f42f470a.jpg
asciilifeform: if you're archiving, archive the http://IP_ADDR/inventory?locale=en also -- it has the panel install dates.
asciilifeform: mircea_popescu -- maybe worth a trilema piece ?
asciilifeform: mircea_popescu: some probably dead. or -- most likely -- dynamic ip
a111: Logged on 2017-04-06 00:26 mircea_popescu: anyway. the new password is now phuctor.
asciilifeform: simply submit http://IP_ADDRESS/home?locale=en for ea.
asciilifeform: oh mircea_popescu will like this:
asciilifeform: if mircea_popescu dun feel like qntra -- BingoBoingo , then ?
asciilifeform: mircea_popescu: this find is yours, qntra it if you feel like