[00:10:38] <drewmutt>	 Is there a quarry query or a tool that could see if the same external link is on a page > 5x or somthing?
[00:12:43] <legoktm>	 drewmutt: probably, you want to look at the externallinks table.
[00:14:49] <drewmutt>	 Ah, good idea.. I'll take a peeksie poo.
[00:29:28] <drewmutt>	 Is running stuff on a labs SSH any faster than quarry? I imagine no since they both use the same servers, iirc.
[01:11:28] <legoktm>	 drewmutt: its the same servers, yeah. I know quarry has a query timeout though
[01:11:45] <drewmutt>	 30 min, I just hit it :P
[01:12:14] <drewmutt>	 legoktm: Know a way I can pull down just one table instead of having to dl the whole dump?
[01:12:49] <legoktm>	 https://dumps.wikimedia.org/enwiki/20170901/enwiki-20170901-externallinks.sql.gz ?
[01:12:57] <legoktm>	 that's 2.7GB
[01:13:40] <drewmutt>	 legoktm: Ahh.. much better, thanks. Also, it says I can SQL against dumps in the docs, any idea how to do that.
[01:13:53] <legoktm>	 which docs?
[01:14:57] <drewmutt>	 https://en.wikipedia.org/wiki/Wikipedia:Database_download#Doing_SQL_queries_on_the_current_database_dump
[01:15:21] <legoktm>	 no idea what that means
[01:16:14] <drewmutt>	 You and me both...
[01:16:16] <legoktm>	 drewmutt: that page seems a bit outdated I think
[01:17:17] <drewmutt>	 Yeah, to say the least.
[01:18:42] <drewmutt>	 legoktm: Oh, since I gotcha.. any protips on how to pull down a file from SSH?
[01:18:59] <legoktm>	 scp or find a graphical sftp client
[01:20:14] <drewmutt>	 k, and last one.. prob a dumb question, it says how to spin up the webserver, but not actually where to see the contents of it online..
[03:13:50] <legoktm>	 drewmutt: sorry, what does what?
[18:34:49] <JD|cloud>	 I would think that we have contingency plans should pmtpa be taken out by Irma, right?
[18:34:58] <JD|cloud>	 I guess that's why we have Dallas now
[18:43:02] <Nemo_bis>	 Sure. So that Texas governors can cut down flooding protections
[18:52:56] <Nemo_bis>	 So readable http://www.riskmap6.com/documents/Meeting_263/48113CIND0D.pdf
[18:55:56] <Nemo_bis>	 water streams on all sides? https://www.openstreetmap.org/way/292909288#map=16/32.9873/-96.9279
[19:04:14] <Nemo_bis>	 0.2 % annual chance of floods in the datacenter location if I read http://water.weather.gov/ahps2/inundation/index.php?gage=dalt2# correctly
[19:08:32] <Reedy>	 JD|cloud: Um. We've had no servers in Tampa for years now
[19:21:33] <Zppix>	 IIRC we have no FL dcs
[21:56:49] <Dispenser>	 What should be done when MW messages show wikitext?  https://cubeupload.com/im/cfn53a.png  
[22:05:22] <Reedy>	 Sounds like a message that needs parsing or something...