IRC log for #gllug on 20070607

06:01.20*** join/#gllug jon_n (n=jonn@82-43-61-7.cable.ubr04.croy.blueyonder.co.uk)
08:54.10*** join/#gllug mumperer (n=don@rose963.demon.co.uk)
08:55.27mumpererG'mornin! :)
09:00.52*** part/#gllug mumperer (n=don@rose963.demon.co.uk)
09:10.40z00daxmoin
09:11.54wethrinhi
09:15.11*** join/#gllug SlayerXP (n=martin@gw-colt.fotango.com)
09:52.01*** join/#gllug geospart (n=geospart@adsl-154-30-196.clt.bellsouth.net)
11:30.00*** join/#gllug dick_turpin (n=dick_tur@host81-139-81-20.in-addr.btopenworld.com)
12:05.55LeedsHKoops
12:59.31boudiccas<PROTECTED>
14:06.44*** join/#gllug clive-h (n=ch@chills.demon.co.uk)
14:10.21clive-hgood afternoon
14:10.49cpufreakit is.
14:10.52cpufreakexceedingly good
14:10.54cpufreak_o\ .o\ \o\ \o| |o| |o/ /o/ /o. /o_
14:13.46wethrinBoat race?
14:15.19*** join/#gllug dick_turpin (n=dick_tur@host81-139-81-20.in-addr.btopenworld.com)
14:15.57dick_turpinI can fix anything. Just ..... Do a fresh install :-D
14:16.30cpufreakwethrin: mexcian wave
14:16.35cpufreakI'm expressing happyness
14:17.53dick_turpincpufreak: You're happy thats brilliant
14:18.08cpufreakyeh, just bought a racecar.
14:18.12cpufreak:]
14:18.23dick_turpincpufreak: Go on
14:18.37cpufreak1995 BMW M3 GT
14:18.46cpufreak<PROTECTED>
14:18.50*** join/#gllug mumperer (n=don@rose963.demon.co.uk)
14:19.22dick_turpincpufreak: Nice although I'm not a fan of beamers
14:19.50cpufreakI am... got a 2004 M3 CSL as my road car.
14:20.05cpufreakbtw anyone want to sponsor me next year? :)
14:44.29*** join/#gllug huw-l (n=scmhl2@valiant.cs.cf.ac.uk)
15:02.45*** part/#gllug dick_turpin (n=dick_tur@host81-139-81-20.in-addr.btopenworld.com)
15:45.08SlayerXPcpufreak: i'll give you 50p and a packet of rollos if you put an antibodymx sticker on your car
15:45.42LeedsHKSlayerXP: now that's what I call an affiliate programme :-)
15:46.37cpufreakhow about a custom url, and 50p for every click through to it :P
15:47.16LeedsHKhow about 10% of sales resulting from a click-through
15:48.11boudiccasis it worth putting an url on a racing car? i thought the general idea was to go fast! too fast to read an url
15:49.10LeedsHKit hit the wall after about 2 minutes - everyone saw it crashing
16:01.02cpufreakboudiccas: there's the pre-race stuff, seeing it in park ferme folloing a race
16:01.16cpufreakand plus when you take a photo of a car
16:01.24cpufreakyou can see that too.
16:01.55boudiccaspark ferme? sorry!
16:02.16cpufreakthe place cars go to following a race
16:02.19cpufreakfor scruiteneering
16:02.41boudiccasah right, ty. its a technical term that i haven't come across before
16:05.11LeedsHKthe paddock?
16:07.08boudiccasthats for horses! even i know that :)
16:07.19LeedsHKsame difference!
16:07.44boudiccas:)
17:08.00*** part/#gllug Dominic (i=dominic@bluebottle.epicwebservices.net)
17:53.30*** join/#gllug mylesbraithwaite (n=mylesbra@CPE0050181121d5-CM0012254493da.cpe.net.cable.rogers.com)
17:53.40mylesbraithwaitehello
17:54.24boudiccashi
17:57.48clive-hhi
17:58.13*** join/#gllug ceronman (n=ceronman@ACC88B65.ipt.aol.com)
17:59.25mylesbraithwaitehello sorry for reply so slow, i am looking for a vps in the uk can anyone help?
18:04.46clive-hPlenty of companies that do that
18:04.56clive-hI'd suggest looking at forum2
18:04.56boudiccas"not I" said the pig
18:05.54clive-hhttp://www.forum2.org
18:07.26mylesbraithwaitethanks
19:17.00*** join/#gllug ceronman (n=ceronman@ACC88B65.ipt.aol.com)
19:20.09*** join/#gllug PussInBoots (i=PussInBo@gateway/tor/x-5e3389122b1bda7e)
19:23.08*** join/#gllug dick_turpin (n=dick_tur@dsl82-163-112-79.as15444.net)
19:24.00dick_turpinclive-h:
19:24.24clive-hhi dick_turpin
19:25.09dick_turpinI wiped the FC7 (Test) and did a Network install of stable overnight
19:25.47clive-hI don't do debian
19:26.26dick_turpinlol FC7 Moonshine AKA stable (supposedly)
19:26.34clive-hoh Moonshine
19:26.40clive-hIt works for me
19:26.55clive-hWith one gotcha
19:27.30dick_turpinAnyway more to the point, any idea where mysql stores its databases on CentOS 5 ?
19:27.51clive-hin /var/lib/mysql
19:28.04clive-hIf it's like RHEL 4
19:28.26dick_turpinhm, I'm sure I looked there but didn't see it
19:29.43dick_turpinI've made the damaged website/hdd even worse trying to fix it however mysqld still works with the rescue
19:30.32dick_turpinI'm hoping I can do it the lazy way and get the database off, or read up on how to export the database
19:31.15clive-hThis is moonshine
19:31.26mylesbraithwaitedick_turpin: that might not work
19:31.37clive-hAnd that databases are in /var/lib/mysql
19:31.55dick_turpinclive-h: I know I'm changing the subject/distro
19:32.23dick_turpinmylesbraithwaite: Don't tell me that I'm in deep dodo
19:32.25clive-hCentos 4 used /var/lib/mysql too
19:32.37mylesbraithwaitecan you connect to the db?
19:32.41clive-hby default
19:32.46dick_turpinmylesbraithwaite: Yes
19:32.59dick_turpinmylesbraithwaite: And see the tables
19:32.59mylesbraithwaitemysqldump working?
19:33.03clive-hYou my want to look to see if there's a /etc/my.cnf
19:33.10clive-hs/my/might/
19:33.20dick_turpinclive-h: There is
19:33.48clive-hIn which case that might define where the db files are stored
19:34.47dick_turpinmylesbraithwaite: My mysql skills run to starting, logging on, show databases, list tables and \q and thats about it
19:34.49clive-hFor a consistent export you need to lock the tables before you start
19:35.04dick_turpinclive-h: Aaaaaaaaahhhhh
19:35.10clive-hand unlock them after
19:35.18mylesbraithwaitemysqldump --all-databases
19:35.22clive-hclearly
19:35.51dick_turpinmylesbraithwaite: OK I follow that. Where will it dump them?
19:35.55clive-hI'd lock the tables and tar up the files
19:36.05clive-hto stdout
19:36.18mylesbraithwaitei would do a mysqldump --all-databases > db_backup.sql
19:36.23mylesbraithwaitethen gz it
19:36.41mylesbraithwaitedepending on who big the db's are it may take some time
19:36.41dick_turpinmylesbraithwaite: Thats what I want
19:37.19mylesbraithwaiteon a unrelated note check out automysqlbackup good script for daily/weekly/monthly backups
19:38.17dick_turpinmylesbraithwaite: clive-h I have a book here MySQL by Larry Ullman one of those 'Teach Yourself' things I'm hoping that might help
19:38.35clive-hi did master-slave mysql replication at my last contract
19:38.49mylesbraithwaitei like postgresql much better
19:38.50clive-hThat was quite fun
19:38.51dick_turpinGotta go for a bit brb
19:38.56clive-has well as backups
19:39.32clive-hBut not suited for everything
19:40.22clive-hI used to dba some Ingres II db's whicj are related to postgres
20:17.14dick_turpinI'm back
20:20.09morsingdick_turpin
20:20.10morsing!
20:20.27dick_turpinmorsing
20:20.53dick_turpinclive-h: you still around?
20:21.15clive-hYeah
20:21.51dick_turpinclive-h: Good, sorry about that I had to turn into Pete's Taxis
20:21.58clive-hno probs
20:22.25dick_turpinclive-h: Is it possible to export into say an xml format
20:22.46clive-herrr not that I know of
20:23.06dick_turpinhm
20:23.33clive-hMysqldump exports a series of SQL commands to recreate the database(s) and table(s) and their contents
20:24.05dick_turpinso what about passwords?
20:24.17halimine is toaster99
20:24.48dick_turpinWhat I mean is do I have to have the same password on the new MySQL ?
20:24.57clive-hAhh okay
20:25.14haliif you export the mysql db you get the passwords/users as well
20:25.19clive-hThere's an --xml option to dump in xml format
20:25.26halihashed obviously
20:26.08*** join/#gllug PussInBoots (i=PussInBo@gateway/tor/x-a803f829c50c6964)
20:26.12dick_turpinum  in the newbie style can I havethe command then pretty please
20:26.31clive-hwhat command?
20:27.10dick_turpinto  dump the database to an xml file
20:27.24clive-hmysqlsdump --xml
20:27.36clive-hbut whatever other options you need
20:28.12dick_turpinmysqldump  --xml centrosales >  centrosales.xml
20:28.44clive-hI'd expect a -u root and -p in their somewhere
20:29.17dick_turpinUh so I don't actually log in to mysql then?
20:29.25clive-hErrr no
20:29.34dick_turpinOK
20:29.38clive-hmysqldump is an external command
20:30.03dick_turpinSorry no skill with this
20:30.22dick_turpinBut I understand what you are saying
20:31.09clive-hSomething like mysql -u root -p --all-databases --xml > backup.xml
20:31.35dick_turpinI was just about to type something similar
20:32.19clive-hdepending on how big the databases are
20:32.31dick_turpinI notice there is no dump in that?
20:32.39clive-hoops
20:32.44clive-hI mean mysqldump
20:33.10dick_turpinAh ok, currently writing  it out in crayon
20:33.22clive-hcrayon?
20:34.00dick_turpinI'm not clever enough to use pens
20:34.29clive-h!
20:34.46clive-hI rarely use pens
20:34.52halinote that backing up databases in mysql locks the tables one by one and you may get an inconsitant dump
20:34.52clive-hThey're a tad quaint
20:35.16clive-hI've mentioned locking the db before hand
20:35.24haliok, forgot to scroll up
20:35.41halibut i would assume someone using mysql is aware of the risks ;)
20:35.46dick_turpinone more thing, I take it I need give the password after the -p option
20:35.51clive-hYes
20:35.55hali--password=foo
20:36.01clive-hThat prompts for the password
20:36.24clive-hPutting the password in plain text on the command line isn't a good idea
20:36.51halicreating a .my.cnf file for the user might be better...
20:37.04dick_turpinAh thats alright then. actually I'm only after one table
20:37.11morsingBeer
20:37.46halieob
20:38.03halijust came back from a lovley evening outside the pillars of hercules in soho
20:38.14morsinghali: And you didn't invite us?
20:38.18halidrank nice cellar cold IPA today
20:38.30clive-hThat's a pub in soho I don't know
20:38.34haliforgot to post on irc, i thought everyone was busy hobnobbing with the pm's :)
20:38.40dick_turpinclive-h: The HDD is knackered its hooked up to an old PII machine once  the data is removed it'll go in the bin so doing the password in plain is not a problem
20:38.41morsingclive-h: It's a good one
20:38.46haliclive-h: wot, it's a geek pub :)
20:38.53clive-hIPA is nice if it's well kept
20:38.58haliclive-h: greek street, just after the gay husar indian place
20:38.59morsingAnd it's not in Soho
20:39.27clive-hIf it's greek street it's soho
20:39.47haliindeed, it's about 50 fet from soho square
20:39.58clive-hSoho is bounded by Charing X Road to the east
20:40.00halift*
20:40.11clive-hregent street to the west
20:40.30clive-hshaftesbury avenue to the south
20:40.42clive-hand oxford street to the north
20:41.30clive-hThat's a pub I've never been in
20:41.40clive-hThough I rarely drink in Soho
20:41.54clive-hgarlic and shots mostly
20:42.04clive-hand the moon and sixpence
20:42.08haliclive-h: i recommend going there on a wednesday, they have DJ Wheelie bag playing on wednesdays
20:42.23clive-hwhat music is that?
20:42.53haliclive-h: he plays all sorts of music, jazz,blues,swing,bossanova (when i request it), rock, etc... mostly from the 50's60's
20:43.00clive-hHmmm
20:43.04haliit's excellent
20:43.13clive-hThe borderline is more my thing
20:43.20halidecent selection of beer
20:43.29halinever been there
20:43.35halihave you been to the ship?
20:43.45clive-hI wonder
20:43.47halithe ship has more of a rock/punk crowd
20:43.57haliit's on wordour street
20:44.05clive-hI haven't
20:44.08halijust before soho hotell
20:44.12haliit's excellent as well
20:44.14hali*rant* :L)
20:44.19clive-hI used to go to the Marguee
20:44.29halimarguee of granbury?
20:44.32clive-hmarquee
20:44.44clive-hThe old rock club
20:44.50halithere are two of those now
20:44.54clive-hI know the marquis of granby
20:45.05clive-hIt's in Covent Garden
20:45.12haliyes, one of them is :)
20:45.29halithe second one is in noho, straight up from soho street up towards the bt tower
20:45.41haliabout 3 minutes up from oxford sreet
20:45.56clive-hThat's Fitzrovia
20:46.15halinoho :)
20:46.37halino hoe's and north of soho
20:46.40clive-hI used to drink in that goth pub in wells street
20:47.35clive-hwhose name escapes me temporarily
20:47.49halithe champion?
20:47.53clive-hnah
20:48.01halinot very gothy perhaps
20:48.06clive-hpart of the eerie chain
20:48.10halithats the only one i know on wells street
20:51.27clive-hIt's about 100 yards up Wells St
20:52.32clive-hben crouches tavern
20:52.50dick_turpinclive-h: Cheers for the advice I'll let you know how I get on. TTFN
20:53.01*** part/#gllug dick_turpin (n=dick_tur@dsl82-163-112-79.as15444.net)
21:04.25clive-hdid i say something wrong
21:06.52halinot that i can see
21:07.20halihowever giving advice on mysql is sort of like telling people how to commit suicide, we should have introduced him to postgresql instead
21:07.39clive-hi like mysql
21:07.45halii find it broken
21:07.59clive-hIf I'm gonna advocate a database I'll choose Oracle
21:08.11clive-hor possibly sapdb
21:09.18halii like oracle the best, but people tend to find it a bit to complicated at first, so i usually recommend pg
21:09.58clive-hI've done the DBA courses, been an Oracle DBA
21:10.11clive-hIt doesn't scare me
21:11.39clive-hThough so far it seems to hate F7 64bit
21:24.54hali9i does at least
21:25.02halisince 9i is built without any nptl support
21:25.21hali10gr2 should be ok with compat libs... i haven't tried it though
21:25.40hali11g is out in a month though *yeay*
21:25.52halii've scheduled 2 days of "oracle play time" in our timesheet system :)
21:26.00clive-hI'd have to look at backups for 9i
21:29.52clive-hI tried oracle-xe and then oracle 10g
21:32.11clive-hI don't actually need either on my home desktop
21:38.17halii have my centos4 vm in vmware, nice and portable
21:39.13clive-hunder linux?
21:39.57halii dual boot vista and ubuntu
21:40.00halithe vm works in boot
21:40.02haliboth*
21:40.18clive-hIf I have to run windows I run it under linux
21:49.18*** join/#gllug mylesbraithwaite (n=mylesbra@bas10-toronto12-1177577221.dsl.bell.ca)
22:21.56*** join/#gllug adminjs (n=ba1020@83.233.183.86)
22:41.51z00daxok, so I now have this massive 16amp capable power plug thing
22:42.08z00daxwhich looks like a long clue thing, often seen in the DC's etc where lots of power needs pushing
22:42.28z00daxnow, i want to run this on a conventional plug, anyone know of a converter or something ?
22:42.53clive-herrk
22:43.15clive-hThat's likely to blow fuses
22:43.47clive-hUnless you have a 16 amp supply
22:44.16clive-hI'd look in pc world
22:44.20clive-hor maplins
22:45.25z00daxits a remote power thing, kinda like an APC masterswitch
22:45.33z00daxwhich can handle upto 8 machines, with 2 amp to each machine
22:45.50z00daxI have 4 machines, and average consumption is well under an amp, i think its more like 0.75amp per machine
22:46.09z00daxnot sure how much of an overhead this thing might have of its own - but i dont think it should be a lot
22:46.43rhowehttp://www.youtube.com/watch?v=WcU4t6zRAKg
22:47.26clive-hNot a lot I'd think
22:47.47clive-hBut they come normally with some weird US style plug
22:50.11z00daxrhowe: hillarious
22:51.55z00daxam trying to google this thing, but i dont know what that massice plug is called
23:00.13clive-hI always call it this thing
23:02.34z00daxhehe yea, i know
23:03.35clive-hI've no idea what the correct name is
23:10.27z00daxah well, will carry this into maplins tomorrow
23:10.34z00daxfor now, sleep time
23:10.35z00daxnite

Generated by irclog2html.pl Modified by Tim Riker to work with infobot.