#mysql
18 October 2007
Total 25 pages. You are browsing page 1/25.
First :: Prev :: [1] [2] [3] [4] [5] [...] :: Next :: Last
--- Log opened Thu Oct 18 00:00:26 2007
--- Day changed Thu Oct 18 2007
00:00 <****> CrazyTux: please do not suggest that anymore.
00:00 <****> the thing u said works thanks
00:00 <****> chadmaynard, hmmm, never had that problem, but I won't :)
00:00 <****> thanks : )
00:01 <****> chadmaynard, however technically no one should allow root access remotely, should just assign a super user priv to some altern user :)
00:01 <****> Therion, omg, your alive.
00:02 <****> CrazyTux: well we just created a new user. It just happens to be called root.
00:05 <****> Hi! I've got a master server in a replication set up which is running low on disk space. I want to remove some of the 93 G of bin logs
00:05 <****> How do I do that safely?
00:05 <****> I remember when I've done so historically that it's whined that it can't find them, even if their number is like 000005 and I'm on 0000312
00:07 <****> Seconds_Behind_Master: 74190
00:07 <****> hooray!
00:07 <****> clergyman: read http://dev.mysql.com/doc/refman/5.0/en/binary-log.html
00:07 <****> Single threaded replication, yay!
00:07 <****> Thanks chadmaynard
00:08 <****> Oh, yeah, what's DDL ?
00:08 <****> And that other DD?
00:09 <****> DML
00:09 <****> ddl is editing table structure. dml is editing data.
00:09 <****> data definition language, data manipulation language
00:10 <****> aah, thanks!
00:10 <****> snoyes: isn't it a bit late for you?
00:10 <****> In MySQL 4.1, is there something wrong with the following?: CREATE PROCEDURE dorepeat()
00:10 <****> BEGIN SET @x = 0; END
00:10 <****> yes
00:11 <****> loquitus_of_borg:
00:11 <****> loquitus_of_borg: yes
00:11 <****> loquitus_of_borg: procedures didn't exist until 5.0
00:12 <****> damn
00:13 <****> I was trying to do compound statements in 4.1 (like described in http://dev.mysql.com/doc/refman/4.1/pt/repeat-statement.html)... can I do them in 4.1 without SP's?
00:13 <****> like a while loop in 4.1
00:14 <****> CrazyTux: BRAAAAAAAAAAAINZZZZZZZZZ
00:14 <****> Therion, hows it going man, long time :)
00:14 <****> Therion, I think I may cry :)
00:14 <****> lol
00:14 <****> CrazyTux: Same as always, poorly!
00:14 <****> hehe
00:14 <****> Therion, aww :( haha.
00:14 * CrazyTux demands Therion's personal cell for emergencies :)
00:14 <****> lol
00:15 <****> You have to pay a lot for that :P
00:15 <****> Hi, simple question, how to select a row if a field is empty? SELECT * FROM table.users where id = 1 and id2 = null ?
00:15 <****> is null
00:15 <****> Therion, :)
00:15 <****> Ny0, IS NULL
00:15 <****> id2 IS NULL
00:15 <****> ok
00:16 <****> thx
00:16 <****> chadmaynard: So just to make sure, I can run PURGE MASTER LOGS; and it won't break the running instance?
00:16 <****> Definitely
00:16 <****> or = '' if it's an empty string
00:16 <****> Therion Therion Therion Therion Therion Therion
00:16 * Therion humps seekwill's leg
00:16 <****> lol
00:16 <****> Therion, seriously where the hell have you been hiding?
00:17 <****> CrazyTux: Just been too busy
00:19 <****> i hate it when people can't spell dammit
00:19 <****> Is there a way to repeat a command X times?
00:19 <****> chadmaynard: You mean the name "dammit" or the phrase "damn it" or was that merely ironic?
00:20 <****> Like execute a given insertion command X times?
00:20 <****> Therion: Beat me to it :)
00:20 <****> Therion: irony.
00:21 <****> it's not as funny when people ask questions though : (
00:21 <****> What kinds of questions?
00:21 <****> Is it the sheer amount of questions, or just the principle?
00:22 * chadmaynard ignores the last two lines
00:22 <****> :(
00:22 <****> lol
00:23 <****> YOU DON'T TALK TO NICOTREL LIKE THAT
00:24 <****> loquitus_of_borg: with a script!
00:25 <****> Therion: i can't change anything on hashmysql.org.
00:26 <****> chadmaynard: That is because you are a vile spammer
00:26 <****> chadmaynard: Or something
00:26 <****> Therion: that's beside the point.
00:27 <****> dejvid and seekwill have been admining it, dunno what restrictions may be in place now
00:28 <****> Chadmaynard: ok... script. fine. tell me something. it is off topic, but in bash how would I really quickly execute something like "insert into foo(id) values(now())" X times?
00:28 <****> Front page probably requires administrator rights though
00:28 <****> well that's kind of a restriction in general ;)
00:28 <****> And I probably have it requiring auth
00:28 <****> nils_: Lots of spam problems
00:28 <****> loquitus_of_borg: for((i=1; ....)); do mysql -e "query"; done;
00:28 <****> I've considered killing it and letting forge replace it, but I have conflicting thoughts on that subject
00:29 <****> Therion: yeah even with registration, the bots are very good these days...
00:31 <****> can i do a mysqldump with a specific date range for a table? if so, what is the syntax?
00:31 <****> eTiger13: you can specify a where clause
00:31 <****> eTiger13: as nils_ said. flag is ---where or -W
00:31 <****> eTiger13: -w or --where
00:32 <****> -w, sorry
00:32 <****> damn you chadmaynard!
00:32 * chadmaynard hides
00:33 <****> nils_: you mean dammit
00:34 <****> sql.sql <<<<-------- whats wrong with this
00:34 <****> ouch
00:34 <****> eTiger13: it isn't valid
00:34 <****> eTiger13: you need to quote it for the shell
00:35 <****> sql.sql
00:35 <****> http://www.garaget.org/?car=16741 <--- thats an ugly car...
00:36 <****> FluGanz: ?
Total 25 pages. You are browsing page 1/25.
First :: Prev :: [1] [2] [3] [4] [5] [...] :: Next :: Last