201100+ entries in 0.112s
mircea_popescu: classical wall mounted
thing with directional controls etc
mircea_popescu: (no weddings were bombed,
totally not
the same as aleppo etc)
fromloper: fromloper quietly pulls his poncho around himself and quietly retreats into
the saguaro darkness, but his eyes are friendly, and he has been grateful for
the warmth.
fromloper: fromloper studies his marshmallow, admiring its gentle bronzing in
the crackling fire.
shinohai: First one I am privy
to in recent memory.
fromloper: actually, I found sweet rants on clojure, and followed
the crumbs.
doppler: I didn't even notice it was comic sans until I happened
to browse on my windows box
shinohai just now noticed
that comic sans "trilema" font
that made him
think of dogecoinz
ben_vulpes: fromloper likely not even looking at browser
tab anymore
ben_vulpes: > 22:51:27 ben_vulpes ups fromloper
to great crickets
ben_vulpes: may have missed
the window of opportunity/interest
there...
Framedragger: (apparently some couple of russians had a fight and one shot
the other over a dispute regarding kant. i can believe
that)
trinque wrenches his
troll-switch back
to off
trinque: you keep your coq
to yourself
Framedragger considers linking
to godel's ontological proof of god in Coq
trinque: (wherein phf gets mad at me re:
that's how set
theory works and I scratch at my left stump)
trinque: hell actually, cut
the dicks off
the females
too!
trinque: I by way of a sad life always write
the where clause first
trinque: mircea_popescu:
the fucking syntax
though eh? cut all dicks off all males,
then you back it down
to particulars!
Framedragger: hey backup&restore process
tested successfully
mircea_popescu: Framedragger i whined at person actually in charge of
this who gave me
the backup.
Framedragger: mircea_popescu: so you went
through every row checking if it has
turd at start, and removing
that
turd? or found binary log
to roll back
the
transaction (which should have aborted and rolled back, something something)
mircea_popescu: the moral being
that db engineers are made not born, and
this is how. so unless you're willing
to burn dbs, don't hire noobs
to engineer your storage
mircea_popescu: and
then it crashed because suddenly
turning 10s of ks of article into a 3mb
turd inflated
the db.
mircea_popescu: I UPDATED EVERY SINGLE CONTENT FIELD FOR EVERY ARTICLE
TO
THE NEW ONE
mircea_popescu: Framedragger i dun
think you've grokked
the depths of my idiocy
CompanionCube: in
the sense
that it/the dump
tool produced a overly-large 40gb file?
CompanionCube: mircea_popescu: do you plan
to write an article about mysql being a shit?
mircea_popescu: please check your favourite articles for any upset!
ty for your patience!
shinohai goes back
to remotely setting up a lovense ....
CompanionCube: 'Wakanda is a fictional nation appearing in American comic books published by Marvel Comics.[1] It is
the most prominent of several fictional African nations in
the Marvel Universe, and it is home
to
the superhero Black Panther. Wakanda first appeared in Fantastic Four #52 (July 1966), and was created by Stan Lee and Jack Kirby.'
shinohai: Which begs
the question, wtf is a Wakanda
shinohai: So I noticed
thestringpuller has changed his location on
twitter from "La Serenissima"
to " Wakanda "
shinohai: "We choose not
to become involved with N. Korea's ongoing war with
the sea" would have been more lulzy
mircea_popescu: which is how one ends up with a multi-gb db. apparently it got executed even
though no ; at end or anything
Framedragger: (one internet says "No, it is not always reliable when you have binary blobs. In
that case you MUST use
the "--hex-blob" flag
to get correct results." << untrusted source)
mircea_popescu: UPDATE
table SET content field = '(the 2mb content of
the post i wanted ADDED goes here)'
Framedragger: mircea_popescu: by
text-only i meant
the *output*, it can certainly handle binary blobs
CompanionCube can't speak for mysql but knows
that postgres dumps can be a mixture of
text and binary data
Framedragger: (but output of mysqldump is *supposed*
to be a set of sql statements.)
Framedragger: (i don't know about
that "db" file,
tho, i mean,
that one's binary)
mircea_popescu: normally it'd be all
text, but because it got fucked it got filled with crap. which
the dumper can't discern from legit stuff.
mircea_popescu: asciilifeform i'm reasonably happy with
the format
tbh.
mircea_popescu: Framedragger and if i store a jpeg
the dumper is supposed
to do what, base64 it ?
gabriel_laddel_p: having both
text &
the js/images/etc prevents lizardhitler from "unhappening" headlines, while ensuring
that DOM dumping and other crazy nonsense doesn't have
to be implemented.
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 :/
gabriel_laddel_p: asciilifeform: in
that conversation I dropped "rich webpage" & "text" archives into
the log, which were OK'd, given
that word-wrapping was removed.
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.
Framedragger: mircea_popescu: hm okok. an .sql file should not contain any non-printable chars so
that in itself is alarming.. weird
mircea_popescu: Framedragger myisamchk'd
the extant MYI/MYD pair, got a db file which works but is
too large, had mysqldump drop it as a .sql
Framedragger: wait how did you end up with
that large ass file? sql dump?
mircea_popescu: sadly
the output is over 8gb already. apparently i got more crap in
there.
Framedragger: sed is only supposed
to work on
text files but hm.. also, one clunky way would be
to hexdump whole file into hex.bin,
then work with
that
mircea_popescu: here's a heads-up : head has been going for ~4 minutes. i expect it
to crash without output.
mircea_popescu: and
the mystery starts
to unravel :
the first 52mb of
this file consist of ... one line of ^@
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