| 00:13.49 | *** part/#uphpu mgeary (~mgeary@50.8.70.19) |
| 01:48.58 | *** join/#uphpu jnbek (~jnbek@pdpc/supporter/active/jnbek) |
| 02:15.30 | *** join/#uphpu mrKrow (~mrKrow@c-67-164-193-59.hsd1.ut.comcast.net) |
| 02:28.50 | *** join/#uphpu jnbek (~jnbek@pdpc/supporter/active/jnbek) |
| 02:35.54 | *** join/#uphpu jtsnow (~jtsnow@VDSL-151-118-129-181.DNVR.QWEST.NET) |
| 02:36.08 | *** join/#uphpu DexterTheDragon (~admin@oalug/member/blackchaos) |
| 02:36.08 | *** mode/#UPHPU [+v DexterTheDragon] by ChanServ |
| 02:54.00 | *** join/#uphpu macnewbold (~Adium@c-67-166-115-242.hsd1.ut.comcast.net) |
| 02:54.00 | *** mode/#UPHPU [+o macnewbold] by ChanServ |
| 03:02.17 | *** join/#uphpu macnewbold (~Adium@c-67-166-115-242.hsd1.ut.comcast.net) |
| 03:02.17 | *** mode/#UPHPU [+o macnewbold] by ChanServ |
| 03:42.01 | *** join/#uphpu josephscott (~josephsco@104.2.233.72.static.reverse.ltdomains.com) |
| 03:42.01 | *** mode/#UPHPU [+v josephscott] by ChanServ |
| 03:42.23 | *** join/#uphpu ninnypants (~ninnypant@69.169.155.132.provo.static.broadweavenetworks.net) |
| 04:39.31 | *** join/#uphpu carmony (~carmony@c-24-10-180-216.hsd1.ut.comcast.net) |
| 04:39.42 | *** mode/#UPHPU [+v carmony] by ChanServ |
| 04:48.02 | *** join/#uphpu mrKrow (~mrKrow@c-67-164-193-59.hsd1.ut.comcast.net) |
| 06:18.42 | *** join/#uphpu optikal (optikal@failcore.com) |
| 06:18.42 | *** mode/#UPHPU [+v optikal] by ChanServ |
| 10:54.58 | *** join/#uphpu jtsnow (~jtsnow@VDSL-151-118-129-181.DNVR.QWEST.NET) |
| 13:25.22 | *** join/#uphpu eggyknap (~jtolley@rs8.endpoint.com) |
| 13:25.22 | *** join/#uphpu eggyknap (~jtolley@unaffiliated/eggyknap) |
| 13:25.22 | *** mode/#UPHPU [+v eggyknap] by ChanServ |
| 13:25.51 | *** join/#uphpu dharmatech (~hayduke@166-70-57-177.ip.xmission.com) |
| 13:59.59 | *** join/#uphpu bhosie (~bhosie@192.84.171.170) |
| 14:01.02 | *** join/#uphpu Utah_Dave (~boucha@72-166-51-162.dia.static.qwest.net) |
| 14:01.02 | *** mode/#UPHPU [+o Utah_Dave] by ChanServ |
| 14:20.00 | *** join/#uphpu bhosie_ (~bhosie@69.27.9.234) |
| 14:23.11 | *** join/#uphpu bhosie (~bhosie@192.84.171.170) |
| 14:31.22 | *** join/#uphpu itimber (~Adium@74.51.216.34) |
| 14:31.22 | *** mode/#UPHPU [+v itimber] by ChanServ |
| 14:32.55 | mindjuju | who is awake? |
| 14:33.01 | itimber | not I |
| 14:33.03 | itimber | :) |
| 14:33.12 | mindjuju | sup itimber, how is the midwest today? |
| 14:33.19 | mindjuju | ohio if i recall, right? |
| 14:33.27 | itimber | Kansas |
| 14:33.32 | itimber | it's hot out here |
| 14:33.39 | mindjuju | :) |
| 14:33.44 | mindjuju | i'd love hot right about now |
| 14:33.48 | mindjuju | i miss the humidity |
| 14:33.51 | itimber | mid 90s, but w/ the humidity it's mid 110s |
| 14:33.56 | itimber | really?!? |
| 14:33.58 | itimber | psht |
| 14:34.07 | itimber | I'm not a fan |
| 14:34.31 | mindjuju | born in san antonio texas, grew up in houston |
| 14:34.33 | itimber | although, I do love the fact that you can feel and smell a rainstorm coming afar off |
| 14:34.38 | itimber | oh ya |
| 14:34.47 | itimber | you know what I'm talkin' about |
| 14:34.59 | mindjuju | yup |
| 14:35.08 | mindjuju | see them clouds rolling in like nobody's business |
| 14:35.22 | mindjuju | sky turns a little green |
| 14:35.27 | mindjuju | i miss a good storm |
| 14:41.50 | *** join/#uphpu eggyknap (~jtolley@74-37-184-179.dsl1.dta.ut.frontiernet.net) |
| 14:41.50 | *** join/#uphpu eggyknap (~jtolley@unaffiliated/eggyknap) |
| 14:41.50 | *** mode/#UPHPU [+v eggyknap] by ChanServ |
| 14:43.54 | *** join/#uphpu redroy (~Adium@216.51.63.72) |
| 14:45.00 | *** join/#uphpu mrKrow (~mrKrow@205.204.33.82) |
| 14:55.51 | *** join/#uphpu mahelious (~mahelious@64.0.29.254.ptr.us.xo.net) |
| 14:57.27 | Utah_Dave | mindjuju: did I tell you I was in Houston for a couple of weeks? That's where I took that picture of me at Popeye's |
| 14:58.06 | mindjuju | ah dag |
| 14:58.19 | mindjuju | are you still there? |
| 15:00.23 | Utah_Dave | No. I've home |
| 15:00.34 | mindjuju | oh was going to say, get me a shirt |
| 15:09.21 | Utah_Dave | :) Next time. What size? |
| 15:10.46 | herlo | Utah_Dave: I want a 3X |
| 15:10.50 | herlo | :P |
| 15:11.12 | herlo | although, I'll be in memphis in two weeks. Next week is Chi-town! |
| 15:11.27 | Utah_Dave | nice! |
| 15:11.38 | mindjuju | yeah get me a 3x |
| 15:11.59 | Utah_Dave | sounds good! You both want the hot pink version, right? |
| 15:12.07 | herlo | Utah_Dave: yeah, so I'm sure I'll be required to bring back popeye's for mindjuju anyway. |
| 15:12.25 | Utah_Dave | Chi-town == Chicago? |
| 15:13.03 | *** join/#uphpu macnewbold (~Adium@76.8.223.101) |
| 15:13.03 | *** mode/#UPHPU [+o macnewbold] by ChanServ |
| 15:13.14 | herlo | aye |
| 15:13.25 | herlo | gonna be hot and humid! :( |
| 15:13.46 | Utah_Dave | :) I'm going to be out there for a few days in August |
| 15:14.34 | herlo | same with mepmhis |
| 15:14.52 | herlo | Utah_Dave: ahh, nice. Chicago in August has got to be killer heat-wise. |
| 15:15.40 | Utah_Dave | Yeah. I'm not sure which is worse... Chicago in August or Chicago in January |
| 15:18.34 | herlo | I'd prefer January |
| 15:18.53 | herlo | You can *always* put more clothes on. The opposite is *definitely* not true. |
| 15:19.11 | *** join/#uphpu ninnypants (~ninnypant@69.169.155.132.provo.static.broadweavenetworks.net) |
| 15:19.20 | ninnypants | mornin |
| 15:19.48 | herlo | Utah_Dave: I was there in December last year, very cold. |
| 15:20.02 | herlo | I think March and April are great months in Chicago |
| 15:20.12 | herlo | the rest are not worth being there for :) |
| 15:20.27 | Utah_Dave | yep |
| 15:20.56 | herlo | but I still like chicago, even in late summer. Just in the evenings and mornings. |
| 15:23.03 | *** join/#uphpu mastergunns (~mastergun@216.49.181.128) |
| 15:24.04 | Utah_Dave | can't wait to get some pizza. I can't remember their names right now, but there are 2 small pizza places I love |
| 15:24.09 | Utah_Dave | there |
| 15:25.04 | mindjuju | so, i've got an employee who lives in another country that needs to send in confidential correspondence |
| 15:25.14 | mindjuju | i was thinking GPG, but i'm wondering if that's too much gun |
| 15:25.29 | mindjuju | should we be thinking dropbox or something simpler / |
| 15:25.35 | herlo | mindjuju: gpg isn't too much gun |
| 15:25.49 | herlo | gpg is a simple, effective way to send data |
| 15:26.03 | herlo | gpg --encrypt --armor < mymsg.txt |
| 15:26.05 | herlo | and you are done |
| 15:26.16 | mindjuju | what about attachemtns, etc |
| 15:26.18 | herlo | well, after entering the KeyID of the person you are encrypting for |
| 15:26.26 | herlo | mindjuju: encrypt those first |
| 15:26.30 | herlo | then attach |
| 15:27.07 | herlo | there used to be this great firefox plugin called firegpg. It would let you do all of that right in gmail, but it seems (last I checked) to no longer work. |
| 15:27.27 | herlo | but thunderbird, evolution and even mutt let you gpg encrypt inline |
| 15:27.48 | herlo | mindjuju: so while it's simple, it's effective and fast and integrated into many apps |
| 15:28.00 | herlo | but that's just my suggestion. |
| 15:28.22 | herlo | decrypting is just as simple |
| 15:28.29 | herlo | gpg --decrypt < encrypted.file.gpg |
| 15:28.55 | herlo | and if you want it to go to a file directly (and not to the terminal) |
| 15:29.03 | herlo | gpg --decrypt < encrypted.file.gpg > unencrypted.file |
| 15:31.00 | *** join/#uphpu Monnok (~monnok@205.204.33.82) |
| 15:32.06 | *** join/#uphpu xtrementl (~xtrementl@neutroninteractive-xmission.xmission.com) |
| 15:37.11 | *** join/#uphpu fungus (~olsonl@bromine.sosstaffing.com) |
| 15:37.11 | *** mode/#UPHPU [+o fungus] by ChanServ |
| 15:42.16 | *** join/#uphpu josephscott (~josephsco@104.2.233.72.static.reverse.ltdomains.com) |
| 15:42.16 | *** mode/#UPHPU [+v josephscott] by ChanServ |
| 15:42.20 | *** join/#uphpu skinner (~DSkinner@173-14-230-129-Utah.hfc.comcastbusiness.net) |
| 15:47.50 | DexterTheDragon | mindjuju: xtrementl: http://www.youtube.com/watch?v=lTx3G6h2xyA |
| 15:50.47 | mindjuju | curious |
| 15:51.58 | mindjuju | that's cool! |
| 15:53.48 | ninnypants | ~DexterTheDragon++ |
| 15:53.55 | ninnypants | for the sql help yesterday |
| 15:54.48 | DexterTheDragon | \m/ |
| 16:05.46 | *** join/#uphpu fridgesm (~fridgesm_@67-2-177-240.slkc.qwest.net) |
| 16:26.06 | *** join/#uphpu carmony (~carmony@c-24-10-180-216.hsd1.ut.comcast.net) |
| 16:26.06 | *** mode/#UPHPU [+v carmony] by ChanServ |
| 16:26.50 | *** join/#uphpu SunSparc (~jonathan@24-104-129.146.hfc.mediarain.com) |
| 16:26.50 | *** mode/#UPHPU [+v SunSparc] by ChanServ |
| 16:29.06 | *** join/#uphpu bhosie (~bhosie@192.84.171.170) |
| 16:36.26 | synic | mindjuju: have you see this? http://www.youtube.com/watch?v=SYFfgxYcDP4 |
| 16:37.04 | mindjuju | havent |
| 16:37.28 | mindjuju | that's awesome! |
| 16:37.43 | synic | pretty much, it makes me all goosebumpy |
| 16:39.22 | synic | haha, that second comment sums it all up |
| 16:39.50 | mindjuju | that's skill |
| 16:46.14 | *** join/#uphpu beandog (~sdibb@gentoo/developer/beandog) |
| 16:46.14 | *** mode/#UPHPU [+v beandog] by ChanServ |
| 16:54.25 | SunSparc | synic: that video was awesome |
| 16:55.23 | synic | yeah it is |
| 16:55.30 | synic | I wonder if there's any of this guy on grooveshark |
| 16:56.00 | synic | that would be a no |
| 16:56.25 | SunSparc | Hmmm... search results null on Turntable. :( |
| 16:56.54 | DexterTheDragon | beandog: http://www.youtube.com/watch?v=9dSB_7TPeeY |
| 16:58.17 | skinner | DexterTheDragon: I see your Charlie and raise you one http://www.youtube.com/watch?v=wZZ7oFKsKzY&feature=related |
| 16:59.03 | SunSparc | DexterTheDragon: Oh man, that is freakin evil lol |
| 17:00.00 | mindjuju | DtD, there should have been a medical warning with those links |
| 17:00.11 | SunSparc | lol |
| 17:00.32 | SunSparc | My kids showed me that one the other day. Insane. They were trying to see how long they could listen to it. |
| 17:00.35 | DexterTheDragon | bunch a wusses |
| 17:00.45 | SunSparc | I eventually helped them out and turned it off. |
| 17:00.47 | SunSparc | :) |
| 17:01.32 | mahelious | i was feeling pretty revolted by Greenspan's comments this morning. |
| 17:01.47 | mahelious | but 10 hours of badger? maybe he had a point |
| 17:01.57 | mindjuju | i just hope that when the great cataclysm of 2012 happens and everything is blown to bits, that archaeologist from the new inhabitants don't judge us by these videos |
| 17:02.32 | mindjuju | oh man, what is this http://www.youtube.com/watch?v=KHy7DGLTt8g |
| 17:04.29 | beandog | Okay guys I need some help |
| 17:04.36 | mindjuju | ya you do |
| 17:04.38 | beandog | Clients from Asia are saying that the site has latency issues |
| 17:04.41 | mindjuju | oh, you mean a tech question |
| 17:04.43 | beandog | How in the world would I test/verify that |
| 17:04.44 | mindjuju | :) |
| 17:05.07 | mahelious | beandog: asian proxy? |
| 17:06.02 | DexterTheDragon | beandog: https://wonderproxy.com/ |
| 17:07.22 | beandog | I dont get it |
| 17:07.57 | DexterTheDragon | neither do I |
| 17:07.59 | skinner | he's saying try connecting to your site using an asian proxy to see if it's laggy for you too |
| 17:09.03 | fungus | beandog, test latency locally first to ensure it's not your problem, then move outwards and test at another ISP in the US. |
| 17:09.19 | fungus | Eg. computer in the office and then a computer at home. |
| 17:09.28 | mindjuju | @beandog, try this one |
| 17:09.29 | mindjuju | http://www.webpagetest.org/ |
| 17:09.35 | fungus | that too |
| 17:09.39 | mindjuju | that has hong kong and several other countries in Asia |
| 17:12.50 | beandog | okay thanks |
| 17:22.50 | mahelious | mindjuju++ |
| 17:23.00 | mahelious | pretty slick page |
| 17:25.12 | mindjuju | ~josephscott++ |
| 17:25.21 | josephscott | WPT is very handy |
| 17:35.48 | beandog | I found this too: |
| 17:35.50 | beandog | http://pagespeed.googlelabs.com/ |
| 17:38.46 | SunSparc | Cool |
| 17:39.33 | josephscott | WPT has pagespeed integration as well |
| 17:47.03 | beandog | whats that |
| 17:47.36 | josephscott | http://www.webpagetest.org/ |
| 17:48.12 | josephscott | the video capture option is pretty cool too |
| 17:48.50 | beandog | oh |
| 17:49.00 | josephscott | here is a test I just ran to give an example: http://www.webpagetest.org/result/110714_4M_124AH/ |
| 17:49.14 | mindjuju | show off |
| 17:49.26 | mindjuju | oh, that's google |
| 17:49.32 | mindjuju | i thought that was WP.com or something |
| 17:50.06 | mindjuju | happy bday stderr! |
| 17:50.08 | josephscott | haha, not this time |
| 17:58.43 | mindjuju | DtD - interesting - https://www.eff.org/deeplinks/2011/07/fbis-next-generation-identification-database |
| 18:08.42 | *** join/#uphpu bhosie (~bhosie@192.84.171.170) |
| 18:19.47 | beandog | I dont suppose anyone has a shell script to minify css |
| 18:20.00 | josephscott | http://devour.com/video/awkward-australian-today-show-segment/ |
| 18:23.18 | herlo | Evolution: |
| 18:23.20 | herlo | ~/.. |
| 18:23.26 | herlo | gah! |
| 18:23.31 | herlo | sorry |
| 18:23.56 | beandog | whut |
| 18:23.59 | beandog | was that |
| 18:27.37 | *** join/#uphpu Utah_Dave (~boucha@72-166-51-162.dia.static.qwest.net) |
| 18:27.37 | *** mode/#UPHPU [+o Utah_Dave] by ChanServ |
| 18:50.42 | *** join/#uphpu fridgesm (~fridgesm_@fridgesm.fttp.xmission.com) |
| 19:09.06 | *** join/#uphpu fridgesm (~fridgesm_@fridgesm.fttp.xmission.com) |
| 19:30.03 | *** join/#uphpu josephscott (~josephsco@104.2.233.72.static.reverse.ltdomains.com) |
| 19:30.03 | *** mode/#UPHPU [+v josephscott] by ChanServ |
| 19:37.53 | mindjuju | seeing all the half life fan films reminds me of the remake we made of Aliens when i was in high school |
| 19:37.57 | mindjuju | them were the days |
| 19:54.22 | itimber | all. day. meetings |
| 19:54.29 | itimber | uugh |
| 19:54.54 | unum | meetings? |
| 19:54.57 | unum | what are those? |
| 19:55.47 | josephscott | unum: those are times when people all gather in the same room and try to ignore each other as much as possible via working on the laptop or phone :-) |
| 19:56.08 | unum | :) |
| 19:56.17 | itimber | haha |
| 19:56.20 | itimber | true |
| 19:56.26 | unum | meeting guy has been out of town for three weeks |
| 19:56.54 | unum | which may sound like a good thing, but you'd be suprised how hard it is to get anything done when no one will tell you what they want |
| 19:59.59 | influx | Why will no one tell you what they want? |
| 20:00.15 | jsmith | They will, they just won't be specific enough for you to do anything about it |
| 20:04.15 | josephscott | please bring about world peace, kthnxbye |
| 20:04.41 | jsmith | josephscott: And on time and under budget, too! |
| 20:05.04 | josephscott | where on time == tomorrow |
| 20:05.09 | josephscott | and budget == $1 |
| 20:05.11 | josephscott | ;-) |
| 20:06.11 | jsmith | Champagne on a beer budget -- sounds about right for us poor programmers |
| 20:09.10 | unum | supposedly no one has time for meetings |
| 20:09.16 | unum | they're too busy getting things done |
| 20:09.45 | unum | I do very well at getting things done on time and underbudegt |
| 20:09.51 | unum | just as Dr. Cannon taught me |
| 20:10.30 | jsmith | Ah, Dr. Cannon |
| 20:16.26 | unum | ? |
| 20:16.32 | unum | come on now you gotta share |
| 20:16.58 | unum | the two of the three most important things I learned in college were from him |
| 20:17.09 | ninnypants | http://www.youtube.com/watch?v=m3CcyUAHtdk |
| 20:17.19 | unum | the definition of succesfull software project is one that comes in on time and under budget |
| 20:17.24 | unum | KISS |
| 20:17.51 | unum | incentives matter would be the third one which I learned from my PoliSci professor |
| 20:19.46 | jsmith | unum: I wouldn't do it justice over IRC -- but it stunned the class enough that it was hard to think about programming after that |
| 20:23.32 | skinner | http://www.todaysbigthing.com/entertainment/2011/07/05 |
| 21:16.01 | SunSparc | ~lart jsmith |
| 21:16.01 | ibot | takes out jsmith with the trash |
| 21:16.20 | jsmith | SunSparc: What did I do this time? |
| 21:20.13 | SunSparc | jsmith: You taunted us with the possibility of an apparently great joke, and then renigged. Not cool. |
| 21:20.16 | SunSparc | ;) |
| 21:20.36 | SunSparc | ninnypants: That HP recap was disturbing. |
| 21:20.49 | SunSparc | skinner: That does not look like a very fun BBQ. |
| 21:22.37 | jsmith | SunSparc: Did I say it was great? |
| 21:23.15 | SunSparc | jsmith: It was assumed. :D |
| 21:23.36 | jsmith | Assumptions are dangerous animals |
| 21:23.39 | SunSparc | But if it was not great, then I will happily unlart you. |
| 21:23.49 | SunSparc | Yes. Yes they are. |
| 21:23.56 | SunSparc | ~unlart jsmith |
| 21:23.56 | ibot | ACTION whallops sunsparc for thinking of the idea |
| 21:24.01 | SunSparc | :D |
| 22:37.56 | SunSparc | ~magic |
| 22:37.57 | ibot | Forms based RAD language. URL: http://www.magic-sw.com |
| 22:38.11 | SunSparc | ~magic Thursday |
| 22:38.25 | SunSparc | ~soccer |
| 22:38.25 | ibot | i guess soccer is - see football. short for Association Football (assoc -> soccer), or the Greatest Game in the World! |
| 22:38.39 | SunSparc | ~soccer the world |
| 22:39.10 | fridgesm | soccer = "metric football" |
| 22:39.17 | SunSparc | lol |
| 22:41.00 | DexterTheDragon | ~football |
| 22:41.00 | ibot | [football] played with a ball shaped like an ellipsoid |
| 22:41.13 | josephscott | $google football |
| 22:41.13 | raifbot | josephscott searching http://www.google.com/search?q=football -- http://www.nfl.com/ -- http://en.wikipedia.org/wiki/American_football -- http://espn.go.com/college-football/ |
| 22:42.01 | SunSparc | ibot football is also rarely touched by the foot which makes the name confusing |
| 22:42.01 | ibot | okay, SunSparc |
| 22:43.10 | SunSparc | ~AI |
| 22:43.10 | ibot | [ai] a myth, the best they have so far is actual stupidity, or me APT!, or american idol |
| 22:43.23 | SunSparc | ~AI me |
| 22:50.45 | *** join/#uphpu fridgesm_ (~fridgesm_@fridgesm.fttp.xmission.com) |
| 22:53.49 | *** join/#uphpu fridgesm_ (~fridgesm_@fridgesm.fttp.xmission.com) |
| 22:56.29 | *** join/#uphpu fridgesm (~fridgesm_@fridgesm.fttp.xmission.com) |
| 23:05.41 | skinner | poll: best linux os to use with a dell xps laptop? Mark. Set. Go! |
| 23:07.41 | fungus | the Linux OS you are most familiar with and like the best. |
| 23:08.46 | macnewbold | skinner: FreeBSD! |
| 23:08.49 | SunSparc | Linux is Linux |
| 23:08.57 | macnewbold | FreeBSD is not Linux |
| 23:09.06 | SunSparc | lol, yeah, FreeBSD is cool too. |
| 23:09.15 | beandog | skinner: gentoo |
| 23:09.37 | fungus | yeah, but FreeBSD on a laptop sounds scarier, they've always had hardware support issues in that arena. |
| 23:10.20 | skinner | I'm familiar with Ubuntu, Centos and Fedorea |
| 23:10.22 | macnewbold | skinner: honestly, if it were me, I'd probably put ubuntu on it, attempting to minimize the amount of tweaking to make everything happy while maximizing user friendliness |
| 23:10.22 | skinner | *fedora |
| 23:10.39 | skinner | macnewbold: that's kinda what I were thinkin |
| 23:10.47 | macnewbold | josephscott: how'd that go? I've kinda wanted to sometimes, but shared fungus' point of view |
| 23:10.55 | josephscott | agreed, if I were to do it today I'd likely go with Ubuntu |
| 23:11.02 | skinner | purpose is primarily PHP development |
| 23:11.15 | SunSparc | Yeah, Ubuntu is quite friendly. |
| 23:11.20 | josephscott | took some tweaking, but I was a happy WindowMaker user for many years |
| 23:11.21 | SunSparc | Gentoo is just plain fun though. |
| 23:11.29 | skinner | my work gave me a nice xps laptop, but with Win7 |
| 23:11.42 | macnewbold | if you're daring, you could make it a hackintosh or something, and run osx, but i think that's against the licensing since it isn't apple hardware |
| 23:11.50 | skinner | lol |
| 23:12.04 | macnewbold | one of these days, android will be ready as a more general-purpose OS... |
| 23:12.07 | beandog | Does anyone know how to dump InnoDB tables |
| 23:12.13 | beandog | I'm getting foreign key issues on loading it |
| 23:13.24 | fungus | mysqldump or percona XtraBackup |
| 23:13.52 | fungus | or do you mean dump as in erasing? |
| 23:14.05 | mindjuju | ~fungus++ |
| 23:14.11 | beandog | mysqldump |
| 23:14.17 | skinner | beandog: DROP * FROM $myDB WHERE tabletype = 'InnoDB'; |
| 23:14.18 | beandog | And it's not working b/c it's innodb with foreign keys |
| 23:14.59 | fridgesm | do you have circular foreign keys? |
| 23:15.08 | skinner | DROP InnoDB WHERE problems_with_foreign_keys_exist = TRUE AND REASON = 'cause I said so' |
| 23:15.10 | fridgesm | or are the tables in the wrong order? |
| 23:15.19 | skinner | and make me a sammich |
| 23:15.23 | fridgesm | what version of MySQL? |
| 23:15.32 | fridgesm | I thought they had fixed that issue in mysqldump a long time ago |
| 23:15.47 | macnewbold | beandog: drop the foreign keys before you try to drop the table |
| 23:15.57 | macnewbold | or if you're trying to just delete certain rows, then that wouldn't work |
| 23:17.01 | fridgesm | http://dev.mysql.com/doc/refman/5.1/en/innodb-foreign-key-constraints.html |
| 23:17.01 | beandog | macnewbold: whut, srsly? |
| 23:17.15 | fridgesm | http://dev.mysql.com/doc/refman/5.1/en/innodb-foreign-key-constraints.html |
| 23:17.22 | fridgesm | To make it easier to reload dump files for tables that have foreign key relationships, mysqldump automatically includes a statement in the dump output to set foreign_key_checks to 0. This avoids problems with tables having to be reloaded in a particular order when the dump is reloaded. It is also possible to set this variable manually: |
| 23:17.22 | fridgesm | mysql> SET foreign_key_checks = 0; |
| 23:17.23 | fridgesm | mysql> SOURCE dump_file_name; |
| 23:17.23 | fridgesm | mysql> SET foreign_key_checks = 1; |
| 23:17.55 | fridgesm | so if your dump doesn't include that, just do it manually as explained |
| 23:19.12 | josephscott | that is both super handy and insanely scary at the same time |
| 23:21.05 | beandog | fridgesm: yah, that still doesnt work |
| 23:21.05 | beandog | :T |
| 23:21.18 | macnewbold | Just to make sure I understand right, are you trying to drop tables, reload a dump, or just delete rows? |
| 23:21.19 | beandog | er, I should say, I've been trying that earlier |
| 23:21.20 | beandog | no workie |
| 23:21.27 | beandog | macnewbold: just copy a database from host1 to host1 |
| 23:21.30 | beandog | er, to host2 |
| 23:21.31 | macnewbold | ah |
| 23:21.43 | macnewbold | so the error is when you're trying to reload it |
| 23:21.49 | beandog | Right, on import, errors. |
| 23:23.41 | macnewbold | so turning off foreign_key_checks doesn't help? is it erroring out on the DROP statement, the CREATE TABLE statement, or the INSERT statement? |
| 23:25.10 | beandog | Okay, it's failing on the first create table syntax |
| 23:25.15 | beandog | ERROR 1005 (HY000) at line 32: Can't create table 'pst.arttypes' (errno: 135) |
| 23:25.43 | beandog | http://pastebin.com/ag9JJhs0 |
| 23:28.47 | fridgesm | there are no foreign keys in that, are there? |
| 23:29.44 | beandog | Okay |
| 23:29.51 | beandog | We figured out it's only happening on this server |
| 23:29.56 | beandog | works in same version of MySQL on my box |
| 23:29.57 | beandog | Hmm |
| 23:29.57 | beandog | :T |
| 23:30.15 | fungus | beandog, $ perror 135 |
| 23:30.15 | fungus | MySQL error code 135: No more room in record file |
| 23:30.34 | fungus | Is your innodb table space full? |
| 23:31.05 | fridgesm | I was about to post the same perror |
| 23:31.15 | fridgesm | that'd be my guess to |
| 23:31.17 | beandog | fungus: how do I know |
| 23:31.20 | fridgesm | switch to innodb_table_per_file |
| 23:31.58 | beandog | fridgesm: huh? |
| 23:32.05 | fungus | add that parameter to your my.cnf |
| 23:32.32 | fridgesm | innodb_file_per_table |
| 23:32.35 | fridgesm | that's the right one |
| 23:32.45 | beandog | oh, mysqld |
| 23:33.02 | fridgesm | add it to /etc/my.cnf |
| 23:33.10 | beandog | no go |
| 23:33.11 | beandog | :T |
| 23:33.26 | fridgesm | what is your innodb_data_file_path set to? |
| 23:36.42 | beandog | innodb_data_file_path = ibdata1:10M:autoextend:max:128M |
| 23:37.02 | fungus | how big is that file? |
| 23:37.05 | fungus | 128M? |
| 23:37.56 | beandog | Okay |
| 23:38.04 | beandog | I commented out all the innodb settings in my.cnf, and now it's working |
| 23:38.15 | fridgesm | change that line to: innodb_data_file_path = ibdata1:10M:autoextend:max:128M;ibdata2:10M:autoextend |
| 23:38.21 | fridgesm | is it using innodb though? |
| 23:38.27 | fridgesm | show table status |
| 23:38.38 | beandog | yah it is |
| 23:38.45 | beandog | So, my innodb config settings were whacked. |
| 23:38.47 | beandog | somehow. |
| 23:39.12 | SunSparc | Laterz!!! |
| 23:41.01 | beandog | Okay |
| 23:41.03 | beandog | Yah |
| 23:41.04 | beandog | That was it. |
| 23:41.54 | beandog | fridgesm: I thought those innodb config settings were stock |
| 23:41.59 | beandog | but the ones on my box, and the server were not the same |
| 23:42.07 | beandog | so I just used the innodb config settings on my box, and it's okay now |
| 23:42.13 | fungus | It was close, but the max part was non-standard. |
| 23:42.20 | beandog | fungus: oh yah? |
| 23:42.25 | beandog | innodb_data_file_path = ibdata1:10M:autoextend:max:128M |
| 23:42.28 | beandog | that's my desktop ^^ |
| 23:42.28 | fridgesm | yeah, most people don't put a max |
| 23:42.47 | fungus | yeah, the max means it can become full |
| 23:42.55 | fungus | and a full is bad |
| 23:44.04 | fungus | Though innodb_file_per_table is really handy, each table gets it's own tablespace. |
| 23:48.59 | beandog | Oh, great. |
| 23:49.08 | beandog | Now InnoDB isn't showing up in engines list. |
| 23:49.09 | beandog | wtc. |
| 23:49.32 | skinner | wtc = What the corn? |
| 23:49.36 | skinner | j/k |
| 23:51.36 | beandog | what in the crap |
| 23:51.41 | beandog | InnoDB is completely not an option now. |
| 23:52.08 | fungus | check the logs, see if it failed to load the engine |