| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16
Comments:
<0> ThomasM, do you know of any (semi-easy) way to take all of the CREATE statements out of a .sql, so its only the INSERT statements?
<0> keep in mind, sed'n it would be difficult, as the CREATE statements are multiple lines
<1> Steakk: cat mysql.sql | grep -v "^CREATE" > mynew.sql
<1> Oh.
<0> I knew you would go there, heh
<1> And the INSERT statements are also multi-line?
<0> some, yes
<1> multi-line regex replace for "CREATE.*;" (exact syntax depends on tool)
<0> then there are the ALTER statements too...damn
<0> and REFRENCES
<1> Steakk: It might be a lot easier to add a bunch of DROP TABLE foo; statements to the top. I had to do that fighting to install somebody else's SQL. (Mambo or one of those.)
<0> ThomasM, thats a good idea
<2> cat mysql.sql | sed 's/;/;\n;g' | grep -v "^CREATE" > mynew.sql
<0> sed: -e expression #1, char 9: unterminated `s' command
<0> I dont know regexp's that well
<2> cat mysql.sql | sed 's/;/;\n/g' | grep -v "^CREATE" > mynew.sql
<0> only simple ****
<2> whoops missed a /
<0> after g ?
<1> Steakk: Log in to the console client. Select your DB. Type "pager less", then "show tables;" and then use the s key to have it save a log file. Some quick regex in VIM (or command line grepping and sedding) will give you your DROP TABLE statements.
<2> before the g
<1> Or whatever the mysql syntax is to execute and output and exit, pipes through sed. -e or something.
<0> scary, eh?
<3> Could be worse
<1> Okay. I'm AFK for a smoke, and then I need to call it a night.
<0> nite ThomasM ... you got my #, keep in touch
<1> Will do. Talk to you fine folks sometime soon.
<0> m0000000000000000000000
<4> hus using suse here
<5> dogbert2: hmm?
<6> I've lost 1/2 of my ISDN service (and have NO way to contact the ISDN group until tomorrow morning), so i'm leeching off my neighbor's open AP via my ThinkPad
<0> "Damnit woman! You broke my heart. Do you know how many women I had to sleep with to get over you?!?"
<3> LOL
<3> Steakk: ... how many?
<0> Pizbit, i just heard that on a show, thought it was hilarious
<3> Hehe
<7> tsokolat!
<8> OldMonk
<9> heh
<10> Anonymous login successful
<10> Domain=[WORKGROUP] OS=[Windows 5.0] Server=[Windows 2000 LAN Manager]
<10> tree connect failed: NT_STATUS_ACCESS_DENIED
<10> what problem
<11> hi.... is there any channel regarding programming under linux?
<11> nobody has idea?
<12> anybody here every tried to installing linux?
<12> i mean
<12> anybody here every tried to installing ucarp in linux?
<13> nah I don't think anyone in here tried installing linux :-P
<12> LOL
<12> what about ucarp?
<13> not I looks cool though
<14> what are some good programs to download of apple?
<15> ucarp is for HA right?
<16> well, I'm now the proud owner of an Athlon 64 dual core
<17> how is it?
<16> Liandrin: I don't have it yet
<17> so you actually are the owner-to-be of an Athlon 64 dual-core
<16> ahh
<16> point
<16> hopefully I'll get it in a day or two
<16> bought open box stuff from NCIX.. saves me $50
<16> or $60
<15> dual cores are nice ... you can actually do "./configure; make -j 2"
<18> Strider-: they're nice processors, I love my x2 4200 :)
<17> I do -j3 on my dual-CPU SMP system
<15> any speed improvements to that?
<19> Lian, AFAIR the kernel build system in 2.6 detects cpu number and compiles appropriately
<17> -j2 wasn't necessarily enough to keep a system busy with the old build system
<16> Liandrin: X2 3800 here
<17> I know little about 2.6, but it seems that it propagates -j3 better than 2.4 did, and you can actually build modules with -j3 now and in parallel with the rest of the kernel
<5> Liandrin
<17> Nanuq
<5> Liandrin: how goes?
<17> that's a long walk.
<19> nanuq, wait until january sometime when it really will be brisk outside
<19> the bracing feeling of -40
<19> or something
<5> Liandrin: to $flat and back. my box isn't responding.
<17> Nanuq, do you need something off it that desperately?
<5> Liandrin: nope
<5> Liandrin: it's just bugging me
<5> 90 minutes there, 90 minutes back
<17> surely you must have something better to do with three hours
<5> browse reggae cds?
<5> Liandrin: I don't, actually.
<17> well then, knock yourself out, I suppose ;)
<16> well, bedtime for bonzo
<5> Liandrin: why, what else do you recommend?
<17> Nanuq, well, I dunno, really, I don't know what's on your To Do list
<5> Liandrin: it's very long, I can tell you that much ;)
<20> anyboby knows the fix for fedora install error saying it cant read repodata/repomd.xml
<21> Moronic: www.debian.org
<5> the hell?
<5> OOo Draw. Okay.
<20> Shadur: i dont like debian :)
<5> Where the **** are the zoom buttons/is the zoom option?
<5> ahh, completely obscured with a ****e icon
<3> Nanuq: :D
<3> Nanuq: Doesn't do graphs properly either damnit
<22> morning
<3> For some reason it doesn't want to plot my data
<3> Jostein: Moo
<5> bwahahaha
<5> this is ****ing retarded
<5> OC Transpo's automated travel planner has me walking out of my way
<5> taking one bus
<5> and then taking the same # bus in the opposite direction
<22> lol
<5> to be fair, I think it's because the early morning routes are right ****ed
<3> Nanuq: Bloody heck, when are you /foreigners/ going to come to your senses and use NZDT?
<17> Pizbit, when are you Antipodean types gonna come to your senses and use UTC? :P
<3> Liandrin: Bull****, ours is first!
<22> :P
<22> lol
<22> now thats -evil-
<3> Jostein: They want to call you 'daddy'.
<22> right
<3> You'll need it
<22> so... slow morning here, eh?
<3> yup
<22> at least I woke up one guy :P
<23> lol
<24> ow FU!!*@$$%#$#%
<3> ewww, digusting
<22> Viking667: right
<24> hey! Don"T d0 74At...ATH)
<22> :P
<5> hmm
<22> trying to fake your death here, Viking667?
<3> Insurance fraud!
<5> buahaha
<22> lol
Return to
#linux
or
Go to some related
logs:
foodstamps.gov
#linux
#windows
arcadegirls
#php
#teens
gamioles
jukafe
#c++
Gaia microsiga
|
|