#mysql
10 October 2007
Total 18 pages. You are browsing page 1/18.
First :: Prev :: [1] [2] [3] [4] [5] [...] :: Next :: Last
--- Log opened Wed Oct 10 00:00:05 2007
00:03 <****> Is there any really low-level way to drop a table? I can't drop my tables - mysql crashes every time I try to drop them. I've even set innodb_force_recovery=1 in my.ini
00:03 <****> Why is this wrong? IF NEW.arrival IS 1 THEN
00:05 <****> `m0, IS is not a synonym for =
00:05 <****> #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IF NEW.arrival = 1 THEN
00:05 <****> SET date_of_arrival=now()' at line 2
00:05 <****> sorry for the paste
00:06 <****> `m0, use a pastesite, and post a more complete example
00:08 <****> okay
00:10 <****> I am doing the following: http://rafb.net/p/h9f7sn84.html
00:10 <****> no BEGIN ?
00:11 <****> hmm
00:11 <****> Do I have to do FOR EACH ROW BEGIN ?
00:11 <****> of course
00:12 <****> hello
00:12 <****> can some one tell me can i do master 2 master repliation on mysql 4.1.x
00:12 <****> and i think you must qualify the columns names with NEW or OLD
00:12 <****> http://www.howtoforge.com/mysql_master_master_replication
00:13 <****> gnari : you talking with me ?
00:13 <****> gnari: would this be proper? http://rafb.net/p/bzlWb469.html
00:13 <****> `m0, as i said, i would qualify the column names
00:14 <****> Okay
00:14 <****> gnari: Like this? http://rafb.net/p/bVV5FK63.html
00:14 <****> L|NUX, no, sorry i was talking to m0
00:14 <****> np
00:15 <****> any one answer my question ?
00:15 <****> gnari: I am getting , #1193 - Unknown system variable 'date_of_arrival'
00:15 <****> `m0, no this is not what i meant. are you not still getting errors?
00:16 <****> `m0 when i say quality column names, i meant you must say in what table they are
00:16 <****> `m0 , in this case it is either OLD or NEW
00:17 <****> So I only have to change, IF NEW.arrival != OLD.arrival THEN
00:17 <****> `m0, not only that one
00:17 <****> gnari: the examples in the manual didn't qualify the variables for SET
00:19 <****> `m0, really?. well i would not know. i do not use mysql, but the error you quoted sure sounds that way
00:22 <****> `m0, i think you should do what i say before protesting, as i am usually right
00:23 <****> #1227 - Access denied; you need the SUPER privilege for this operation
00:23 <****> lol
00:23 <****> nice for wasting time doing triggers
00:26 <****> stupd dreamhost
00:38 <****> anyone use mysqlcc?
00:56 <****> hi - i have a bash/mysql question, i'm trying to dump my db using mysqldump in a cronjob but my password has '!!' in it and bash isn't escaping that correctly
00:57 <****> what's the right way to do this
00:57 <****> db.name.sql
00:58 <****>$BACKUPDIR/$DB/$ARCHIVNAME
00:59 <****> or similar :)
00:59 <****> maybe it works this way
01:00 <****> verblendet: cat $PASSWORDFILE?
01:01 <****> ferric, yepp
01:01 <****> verblendet: why would ineed cat $PASSWORDFILE?
01:02 <****> ferric, i dont know :) this is when you store your password in a file for unattended backups
01:02 <****> ah
01:02 <****> ok
01:02 <****> i find this solution much more handy than entering te password to every script
01:03 <****> so you have to change it only once :)
01:03 <****> but i dont know if its escaped correctly then
01:03 <****> you have to try :)
01:04 <****> ferric, i got a cool shellscript, want it?
01:08 <****> here it is, maybe useful: http://pastebin.com/d604cd3ff
01:09 <****> verblendet: thank you. but that doesn't get around the fact that there are special characters in the passwordfile
01:09 <****> verblendet: the script is super helpful, though!
01:10 <****> ferric, the script misses one important thing ;)
01:10 <****> is there anyway to oder results by: everything with more then 10 chronologically, then everything less then 10?
01:11 <****> ferric, before: l=$(cat $DBLIST.tmp | $wc -l) , please add:
01:11 <****> $DBLIST.tmp
01:11 <****> this will generate the needed list of all databases mysql is running
01:12 <****> (i stripped all unneeded comments and lines, accidently this line too)
01:12 <****> good night everyone :)
01:24 <****> is there anyway to oder results by: everything with more then 10 chronologically, then everything less then 10?
01:33 <****> megasquid, group by, order by
01:45 <****> When MySQL says, e.g., "Duplicate entry '' for key 4", what exactly does the '4' refer to?
01:54 <****> davidmccabe: that's the key value
01:58 <****> jbalint: The key value?
01:58 <****> davidmccabe: The key value is ''. That 1 is which key was violated.
01:58 <****> So I thought.
01:58 <****> davidmccabe: Sorry. I meant 4 is the key number/name.
01:58 <****> Right. How is that counted? The order in the table? The order in the query?
01:59 <****> oops, sorry
01:59 <****> probably from, show indexes from table
01:59 <****> they are numbered in that iirc
01:59 <****> No, they're not numbered.
01:59 <****> davidmccabe: It's determined by the DDL, not the query.
02:00 <****> I think I have found the problem, though. One second.
02:01 <****> Alright, I found it. Thanks, folks.
02:01 <****> is it 4th in show create table maybne?
02:01 <****> counting all the KEYs
02:01 <****> I still don't know what it is.
02:01 <****> Also, the wonderful mysql documentation reveals nothing.
02:02 <****> What happened was, I am in the process of removing a deprecated column, so I changed the insertion query to no longer insert a value. It is null, but unique, so the second time this happened, the value null was a duplicate entry.
02:02 <****> Thanks agan.
02:26 <****> Hi. I'm getting this error when I start my MySQL Administrator interface on my 2003 Server box..."Access violation at address 0042A986 in module 'MySQLAdministrator.exe'. Read of address 00000004" Can anyone tell me what's wrong?
02:33 <****> starbucks101: you're running 2003 server
02:38 <****> proqesi: Yes, I'm running 2003 server...
02:38 <****> are you running the latest version?
02:38 <****> I setup a fulltext index on two fields, however there is no cardinality. Any ideas on how to fix this?
02:39 <****> jbalint: Yes, I am.
02:39 <****> starbucks101: if it's repeatable, report a bug
02:52 <****> heya all
02:52 <****> how can i do a count of all rows in a table at the same tme as using a where clause? eg. select count(*) as total,id,name from table where id = 1;
02:53 <****> is there anyway to oder results by: everything with more then 10 chronologically, then everything less then 10?
02:56 <****> need to flesh this out in my head a bit more but I'll ask anyway... is there a function that'll do the following - I have a boolean field, true & false.... if ONE or the OTHER value is in the result returned, this would equate to "TRUE", but if the result returned is mixed" (i.e. both True AND False, it'll return "FALSE"
Total 18 pages. You are browsing page 1/18.
First :: Prev :: [1] [2] [3] [4] [5] [...] :: Next :: Last