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.27 | mumperer | G'mornin! :) |
09:00.52 | *** part/#gllug mumperer (n=don@rose963.demon.co.uk) |
09:10.40 | z00dax | moin |
09:11.54 | wethrin | hi |
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.55 | LeedsHK | oops |
12:59.31 | boudiccas | <PROTECTED> |
14:06.44 | *** join/#gllug clive-h (n=ch@chills.demon.co.uk) |
14:10.21 | clive-h | good afternoon |
14:10.49 | cpufreak | it is. |
14:10.52 | cpufreak | exceedingly good |
14:10.54 | cpufreak | _o\ .o\ \o\ \o| |o| |o/ /o/ /o. /o_ |
14:13.46 | wethrin | Boat race? |
14:15.19 | *** join/#gllug dick_turpin (n=dick_tur@host81-139-81-20.in-addr.btopenworld.com) |
14:15.57 | dick_turpin | I can fix anything. Just ..... Do a fresh install :-D |
14:16.30 | cpufreak | wethrin: mexcian wave |
14:16.35 | cpufreak | I'm expressing happyness |
14:17.53 | dick_turpin | cpufreak: You're happy thats brilliant |
14:18.08 | cpufreak | yeh, just bought a racecar. |
14:18.12 | cpufreak | :] |
14:18.23 | dick_turpin | cpufreak: Go on |
14:18.37 | cpufreak | 1995 BMW M3 GT |
14:18.46 | cpufreak | <PROTECTED> |
14:18.50 | *** join/#gllug mumperer (n=don@rose963.demon.co.uk) |
14:19.22 | dick_turpin | cpufreak: Nice although I'm not a fan of beamers |
14:19.50 | cpufreak | I am... got a 2004 M3 CSL as my road car. |
14:20.05 | cpufreak | btw 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.08 | SlayerXP | cpufreak: i'll give you 50p and a packet of rollos if you put an antibodymx sticker on your car |
15:45.42 | LeedsHK | SlayerXP: now that's what I call an affiliate programme :-) |
15:46.37 | cpufreak | how about a custom url, and 50p for every click through to it :P |
15:47.16 | LeedsHK | how about 10% of sales resulting from a click-through |
15:48.11 | boudiccas | is 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.10 | LeedsHK | it hit the wall after about 2 minutes - everyone saw it crashing |
16:01.02 | cpufreak | boudiccas: there's the pre-race stuff, seeing it in park ferme folloing a race |
16:01.16 | cpufreak | and plus when you take a photo of a car |
16:01.24 | cpufreak | you can see that too. |
16:01.55 | boudiccas | park ferme? sorry! |
16:02.16 | cpufreak | the place cars go to following a race |
16:02.19 | cpufreak | for scruiteneering |
16:02.41 | boudiccas | ah right, ty. its a technical term that i haven't come across before |
16:05.11 | LeedsHK | the paddock? |
16:07.08 | boudiccas | thats for horses! even i know that :) |
16:07.19 | LeedsHK | same difference! |
16:07.44 | boudiccas | :) |
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.40 | mylesbraithwaite | hello |
17:54.24 | boudiccas | hi |
17:57.48 | clive-h | hi |
17:58.13 | *** join/#gllug ceronman (n=ceronman@ACC88B65.ipt.aol.com) |
17:59.25 | mylesbraithwaite | hello sorry for reply so slow, i am looking for a vps in the uk can anyone help? |
18:04.46 | clive-h | Plenty of companies that do that |
18:04.56 | clive-h | I'd suggest looking at forum2 |
18:04.56 | boudiccas | "not I" said the pig |
18:05.54 | clive-h | http://www.forum2.org |
18:07.26 | mylesbraithwaite | thanks |
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.00 | dick_turpin | clive-h: |
19:24.24 | clive-h | hi dick_turpin |
19:25.09 | dick_turpin | I wiped the FC7 (Test) and did a Network install of stable overnight |
19:25.47 | clive-h | I don't do debian |
19:26.26 | dick_turpin | lol FC7 Moonshine AKA stable (supposedly) |
19:26.34 | clive-h | oh Moonshine |
19:26.40 | clive-h | It works for me |
19:26.55 | clive-h | With one gotcha |
19:27.30 | dick_turpin | Anyway more to the point, any idea where mysql stores its databases on CentOS 5 ? |
19:27.51 | clive-h | in /var/lib/mysql |
19:28.04 | clive-h | If it's like RHEL 4 |
19:28.26 | dick_turpin | hm, I'm sure I looked there but didn't see it |
19:29.43 | dick_turpin | I've made the damaged website/hdd even worse trying to fix it however mysqld still works with the rescue |
19:30.32 | dick_turpin | I'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.15 | clive-h | This is moonshine |
19:31.26 | mylesbraithwaite | dick_turpin: that might not work |
19:31.37 | clive-h | And that databases are in /var/lib/mysql |
19:31.55 | dick_turpin | clive-h: I know I'm changing the subject/distro |
19:32.23 | dick_turpin | mylesbraithwaite: Don't tell me that I'm in deep dodo |
19:32.25 | clive-h | Centos 4 used /var/lib/mysql too |
19:32.37 | mylesbraithwaite | can you connect to the db? |
19:32.41 | clive-h | by default |
19:32.46 | dick_turpin | mylesbraithwaite: Yes |
19:32.59 | dick_turpin | mylesbraithwaite: And see the tables |
19:32.59 | mylesbraithwaite | mysqldump working? |
19:33.03 | clive-h | You my want to look to see if there's a /etc/my.cnf |
19:33.10 | clive-h | s/my/might/ |
19:33.20 | dick_turpin | clive-h: There is |
19:33.48 | clive-h | In which case that might define where the db files are stored |
19:34.47 | dick_turpin | mylesbraithwaite: My mysql skills run to starting, logging on, show databases, list tables and \q and thats about it |
19:34.49 | clive-h | For a consistent export you need to lock the tables before you start |
19:35.04 | dick_turpin | clive-h: Aaaaaaaaahhhhh |
19:35.10 | clive-h | and unlock them after |
19:35.18 | mylesbraithwaite | mysqldump --all-databases |
19:35.22 | clive-h | clearly |
19:35.51 | dick_turpin | mylesbraithwaite: OK I follow that. Where will it dump them? |
19:35.55 | clive-h | I'd lock the tables and tar up the files |
19:36.05 | clive-h | to stdout |
19:36.18 | mylesbraithwaite | i would do a mysqldump --all-databases > db_backup.sql |
19:36.23 | mylesbraithwaite | then gz it |
19:36.41 | mylesbraithwaite | depending on who big the db's are it may take some time |
19:36.41 | dick_turpin | mylesbraithwaite: Thats what I want |
19:37.19 | mylesbraithwaite | on a unrelated note check out automysqlbackup good script for daily/weekly/monthly backups |
19:38.17 | dick_turpin | mylesbraithwaite: 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.35 | clive-h | i did master-slave mysql replication at my last contract |
19:38.49 | mylesbraithwaite | i like postgresql much better |
19:38.50 | clive-h | That was quite fun |
19:38.51 | dick_turpin | Gotta go for a bit brb |
19:38.56 | clive-h | as well as backups |
19:39.32 | clive-h | But not suited for everything |
19:40.22 | clive-h | I used to dba some Ingres II db's whicj are related to postgres |
20:17.14 | dick_turpin | I'm back |
20:20.09 | morsing | dick_turpin |
20:20.10 | morsing | ! |
20:20.27 | dick_turpin | morsing |
20:20.53 | dick_turpin | clive-h: you still around? |
20:21.15 | clive-h | Yeah |
20:21.51 | dick_turpin | clive-h: Good, sorry about that I had to turn into Pete's Taxis |
20:21.58 | clive-h | no probs |
20:22.25 | dick_turpin | clive-h: Is it possible to export into say an xml format |
20:22.46 | clive-h | errr not that I know of |
20:23.06 | dick_turpin | hm |
20:23.33 | clive-h | Mysqldump exports a series of SQL commands to recreate the database(s) and table(s) and their contents |
20:24.05 | dick_turpin | so what about passwords? |
20:24.17 | hali | mine is toaster99 |
20:24.48 | dick_turpin | What I mean is do I have to have the same password on the new MySQL ? |
20:24.57 | clive-h | Ahh okay |
20:25.14 | hali | if you export the mysql db you get the passwords/users as well |
20:25.19 | clive-h | There's an --xml option to dump in xml format |
20:25.26 | hali | hashed obviously |
20:26.08 | *** join/#gllug PussInBoots (i=PussInBo@gateway/tor/x-a803f829c50c6964) |
20:26.12 | dick_turpin | um in the newbie style can I havethe command then pretty please |
20:26.31 | clive-h | what command? |
20:27.10 | dick_turpin | to dump the database to an xml file |
20:27.24 | clive-h | mysqlsdump --xml |
20:27.36 | clive-h | but whatever other options you need |
20:28.12 | dick_turpin | mysqldump --xml centrosales > centrosales.xml |
20:28.44 | clive-h | I'd expect a -u root and -p in their somewhere |
20:29.17 | dick_turpin | Uh so I don't actually log in to mysql then? |
20:29.25 | clive-h | Errr no |
20:29.34 | dick_turpin | OK |
20:29.38 | clive-h | mysqldump is an external command |
20:30.03 | dick_turpin | Sorry no skill with this |
20:30.22 | dick_turpin | But I understand what you are saying |
20:31.09 | clive-h | Something like mysql -u root -p --all-databases --xml > backup.xml |
20:31.35 | dick_turpin | I was just about to type something similar |
20:32.19 | clive-h | depending on how big the databases are |
20:32.31 | dick_turpin | I notice there is no dump in that? |
20:32.39 | clive-h | oops |
20:32.44 | clive-h | I mean mysqldump |
20:33.10 | dick_turpin | Ah ok, currently writing it out in crayon |
20:33.22 | clive-h | crayon? |
20:34.00 | dick_turpin | I'm not clever enough to use pens |
20:34.29 | clive-h | ! |
20:34.46 | clive-h | I rarely use pens |
20:34.52 | hali | note that backing up databases in mysql locks the tables one by one and you may get an inconsitant dump |
20:34.52 | clive-h | They're a tad quaint |
20:35.16 | clive-h | I've mentioned locking the db before hand |
20:35.24 | hali | ok, forgot to scroll up |
20:35.41 | hali | but i would assume someone using mysql is aware of the risks ;) |
20:35.46 | dick_turpin | one more thing, I take it I need give the password after the -p option |
20:35.51 | clive-h | Yes |
20:35.55 | hali | --password=foo |
20:36.01 | clive-h | That prompts for the password |
20:36.24 | clive-h | Putting the password in plain text on the command line isn't a good idea |
20:36.51 | hali | creating a .my.cnf file for the user might be better... |
20:37.04 | dick_turpin | Ah thats alright then. actually I'm only after one table |
20:37.11 | morsing | Beer |
20:37.46 | hali | eob |
20:38.03 | hali | just came back from a lovley evening outside the pillars of hercules in soho |
20:38.14 | morsing | hali: And you didn't invite us? |
20:38.18 | hali | drank nice cellar cold IPA today |
20:38.30 | clive-h | That's a pub in soho I don't know |
20:38.34 | hali | forgot to post on irc, i thought everyone was busy hobnobbing with the pm's :) |
20:38.40 | dick_turpin | clive-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.41 | morsing | clive-h: It's a good one |
20:38.46 | hali | clive-h: wot, it's a geek pub :) |
20:38.53 | clive-h | IPA is nice if it's well kept |
20:38.58 | hali | clive-h: greek street, just after the gay husar indian place |
20:38.59 | morsing | And it's not in Soho |
20:39.27 | clive-h | If it's greek street it's soho |
20:39.47 | hali | indeed, it's about 50 fet from soho square |
20:39.58 | clive-h | Soho is bounded by Charing X Road to the east |
20:40.00 | hali | ft* |
20:40.11 | clive-h | regent street to the west |
20:40.30 | clive-h | shaftesbury avenue to the south |
20:40.42 | clive-h | and oxford street to the north |
20:41.30 | clive-h | That's a pub I've never been in |
20:41.40 | clive-h | Though I rarely drink in Soho |
20:41.54 | clive-h | garlic and shots mostly |
20:42.04 | clive-h | and the moon and sixpence |
20:42.08 | hali | clive-h: i recommend going there on a wednesday, they have DJ Wheelie bag playing on wednesdays |
20:42.23 | clive-h | what music is that? |
20:42.53 | hali | clive-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.00 | clive-h | Hmmm |
20:43.04 | hali | it's excellent |
20:43.13 | clive-h | The borderline is more my thing |
20:43.20 | hali | decent selection of beer |
20:43.29 | hali | never been there |
20:43.35 | hali | have you been to the ship? |
20:43.45 | clive-h | I wonder |
20:43.47 | hali | the ship has more of a rock/punk crowd |
20:43.57 | hali | it's on wordour street |
20:44.05 | clive-h | I haven't |
20:44.08 | hali | just before soho hotell |
20:44.12 | hali | it's excellent as well |
20:44.14 | hali | *rant* :L) |
20:44.19 | clive-h | I used to go to the Marguee |
20:44.29 | hali | marguee of granbury? |
20:44.32 | clive-h | marquee |
20:44.44 | clive-h | The old rock club |
20:44.50 | hali | there are two of those now |
20:44.54 | clive-h | I know the marquis of granby |
20:45.05 | clive-h | It's in Covent Garden |
20:45.12 | hali | yes, one of them is :) |
20:45.29 | hali | the second one is in noho, straight up from soho street up towards the bt tower |
20:45.41 | hali | about 3 minutes up from oxford sreet |
20:45.56 | clive-h | That's Fitzrovia |
20:46.15 | hali | noho :) |
20:46.37 | hali | no hoe's and north of soho |
20:46.40 | clive-h | I used to drink in that goth pub in wells street |
20:47.35 | clive-h | whose name escapes me temporarily |
20:47.49 | hali | the champion? |
20:47.53 | clive-h | nah |
20:48.01 | hali | not very gothy perhaps |
20:48.06 | clive-h | part of the eerie chain |
20:48.10 | hali | thats the only one i know on wells street |
20:51.27 | clive-h | It's about 100 yards up Wells St |
20:52.32 | clive-h | ben crouches tavern |
20:52.50 | dick_turpin | clive-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.25 | clive-h | did i say something wrong |
21:06.52 | hali | not that i can see |
21:07.20 | hali | however giving advice on mysql is sort of like telling people how to commit suicide, we should have introduced him to postgresql instead |
21:07.39 | clive-h | i like mysql |
21:07.45 | hali | i find it broken |
21:07.59 | clive-h | If I'm gonna advocate a database I'll choose Oracle |
21:08.11 | clive-h | or possibly sapdb |
21:09.18 | hali | i like oracle the best, but people tend to find it a bit to complicated at first, so i usually recommend pg |
21:09.58 | clive-h | I've done the DBA courses, been an Oracle DBA |
21:10.11 | clive-h | It doesn't scare me |
21:11.39 | clive-h | Though so far it seems to hate F7 64bit |
21:24.54 | hali | 9i does at least |
21:25.02 | hali | since 9i is built without any nptl support |
21:25.21 | hali | 10gr2 should be ok with compat libs... i haven't tried it though |
21:25.40 | hali | 11g is out in a month though *yeay* |
21:25.52 | hali | i've scheduled 2 days of "oracle play time" in our timesheet system :) |
21:26.00 | clive-h | I'd have to look at backups for 9i |
21:29.52 | clive-h | I tried oracle-xe and then oracle 10g |
21:32.11 | clive-h | I don't actually need either on my home desktop |
21:38.17 | hali | i have my centos4 vm in vmware, nice and portable |
21:39.13 | clive-h | under linux? |
21:39.57 | hali | i dual boot vista and ubuntu |
21:40.00 | hali | the vm works in boot |
21:40.02 | hali | both* |
21:40.18 | clive-h | If 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.51 | z00dax | ok, so I now have this massive 16amp capable power plug thing |
22:42.08 | z00dax | which looks like a long clue thing, often seen in the DC's etc where lots of power needs pushing |
22:42.28 | z00dax | now, i want to run this on a conventional plug, anyone know of a converter or something ? |
22:42.53 | clive-h | errk |
22:43.15 | clive-h | That's likely to blow fuses |
22:43.47 | clive-h | Unless you have a 16 amp supply |
22:44.16 | clive-h | I'd look in pc world |
22:44.20 | clive-h | or maplins |
22:45.25 | z00dax | its a remote power thing, kinda like an APC masterswitch |
22:45.33 | z00dax | which can handle upto 8 machines, with 2 amp to each machine |
22:45.50 | z00dax | I have 4 machines, and average consumption is well under an amp, i think its more like 0.75amp per machine |
22:46.09 | z00dax | not sure how much of an overhead this thing might have of its own - but i dont think it should be a lot |
22:46.43 | rhowe | http://www.youtube.com/watch?v=WcU4t6zRAKg |
22:47.26 | clive-h | Not a lot I'd think |
22:47.47 | clive-h | But they come normally with some weird US style plug |
22:50.11 | z00dax | rhowe: hillarious |
22:51.55 | z00dax | am trying to google this thing, but i dont know what that massice plug is called |
23:00.13 | clive-h | I always call it this thing |
23:02.34 | z00dax | hehe yea, i know |
23:03.35 | clive-h | I've no idea what the correct name is |
23:10.27 | z00dax | ah well, will carry this into maplins tomorrow |
23:10.34 | z00dax | for now, sleep time |
23:10.35 | z00dax | nite |