| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
Comments:
<0> don't know where an equivalent "mysql start" command exists
<1> zaydana: yes
<2> flupps - how would I do it?
<1> GROUP CONCAT(col1 ORDER BY col2)
<1> for example
<2> ah, thanks
<3> KoRnouille, try to use --skip-opt --quick
<0> do I need to start mysql as the mysql *user*? ie: "sudo -u mysql mysql start"
<4> Ok, final question - if I am certain no data is being written to a particular table, is it really necessary to shut down MySQL or lock the tables before I do this restore?
<5> bemson: If you want to start mysql as a user other than the current user - mysql -u username. See mysql --help for more info
<4> I think I need to ask my questions ***ier or something. :P
<0> thx wobbles - I wanted to know if I have to or *should* start mysql as the *mysql* user
<5> bemson: If you are talking about mysql as opposed to mysqld - no
<6> bemson Do you mean the daemon or the client ?
<0> teh daemon
<6> thats mysqld
<0> what about "mysqld_safe" - should I start this as the mysql user?
<4> so, hot hot hotties of #mysql on this steamin' sultry freenode server, tell me.... (pause for dramatic effect) Any of you honies got the goods on whether or not a horny babe needs to lock tables or even shut down mysql prior to a "hard" restore?
<7> Jy: dumping 1.8GB, thanks, it's seems to do the trick, I'll let you know when it's finished... :)
<3> okie cool
<8> wtf is a hard restore
<4> copying data files directly.
<5> bemson: mysql usually comes with some sort of statup script which does all the work for you - even if you start it as root
<8> probably better to shut it down
<8> you might get away with locking the tables, but it might do bad things
<6> probably ... LOL
<0> k - I have been able to start it, but i haven't been able to connect with a client, other than logging on via mysql
<6> you shouldn't move/replace data files while anyprogram is running
<6> it might try to write while the files are moving
<0> Using mysqladmin (from mysql.org), it complains that my .sock file is in the wrong place
<5> bemson: So, you get some kind of error when you try to connect?
<8> I3ooI3oo: if you read lock the tables, it should be fine
<8> ***uming it's myisam
<9> is there any way to connect to mysql server other than localhost, qith a client? in a LAN by example?
<8> it's basically down to whether you have nuts of steel, or not
<0> not with the command-line client, but with my gui app
<10> hey
<10> http://pastebin.ca/62949
<0> I figured it was because I launched it as the wrong user
<10> strange result i cant figure out -- i have 2 user request fields on 2 tables.. i include both in a left join
<6> no horses here m-00kie
<10> hmm thats my line
<10> whered you hear that :)
<0> i've been starting the server with "sudo -u mysql mysqld_safe &"
<6> the internet... or life or.. tv or... that bum down the street
<8> m00kie: where func(row)=foo are bad
<10> spungles - what?
<8> explain select that
<11> m-00kie: Since "NULL" means unknown, an inequality does not return true or false, it returns NULL: NULL != 53805 => NULL
<0> well, nowit won't run - something about these friggin pid files...
<7> Jy: ok, it's all dumped correctly !! thanks !
<10> I3ooI3oo - interesting. I have never seen it anywhere.. I tend to respond to people who buzz me on AIM/ICQ/etc with "hey" tho ;)
<10> "hey" .. " is for horses!"
<10> spungles - doesnt seem to answer my question though - are you saying that NULL is causing the problem?
<3> KoRnouille, nice
<10> i want results that ARE NOT 53805.. NULL would logically be true in that case
<11> m-00kie: I think spungles' comment relates to a performance issue, not to the error in question.
<12> Xgc: hmmm yes thanks
<11> You'll need to use (s_req.UID != 53805 OR s_req.UID IS NULL) then
<10> hmm let me try that then hd
<10> hmm yeah that did it
<10> weird.
<10> why would NULL cause that kind of problem? it doesnt make sense
<10> this could mean i have bugs all over my website heh
<6> null is not = to anything so it can't be != to anything also
<11> It's not a problem, it's a documented feature.
<11> http://dev.mysql.com/doc/refman/5.0/en/working-with-null.html
<6> bug or feature that is the question gr***hopper
<13> a design feature even
<13> rather than a feature that occurs as a result of a bug
<14> m-00kie: It's standard behavior in SQL.
<6> i know... it's just what you deal with alot while debuggin programs... ok this act this way .. is it a bug ot a feature...
<15> there is this symbol which can compare null <16>
<15> ops
<15> it is < = >
<14> m-00kie: Oracle is the only one who causes a little trouble here with: '' being treated as NULL.
<16>
<16>
<6> IS NULL is the only evalutaion for nulls. ( so would IS NOT NULL) Right ?
<12> strib: lol
<14> <16> is a recent thing. I don't think it's in the 2003 specification.
<6> !m I3ooI3oo operators
<17> I3ooI3oo: (Operators) : http://dev.mysql.com/doc/mysql/en/Non-typed_Operators.html
<10> ok well glad this has been resolved. thanks for the help!
<12> So colA <16> null is same as colA IS null?
<14> Narada: No.
<12> How it is used out of curiosity?
<14> Narada: Well, yes.
<12> Heh :)
<15> it is the same as = plus is null
<14> Narada: It means, I believe, a = b or a is null and b is null
<6> columnA is null
<13> ah :D
<6> good def Xgc
<12> where did b come from
<11> neat. So, you could use NOT(s_req.UID <16> 53805)
<12> ah
<18> I've got a question about the open source nature of mysql: can anyone contribute to the development of the software or how does that work?
<14> Narada: I was referring to a <16> b
<12> Xgc: yeah i now realise
<12> that's quite handy actually
<19> Vger: Anyone can submit patches, yes. Due to the dual-license of MySQL any accepted patches would need to have copyright released.
<15> Vger: you can contribute but code contribution need to be up to the quality acceptable by mysql ab and you have to share the copyright ownership with mysql ab
<18> I see. is there any financial incentive to the submition of patches then?
<20> vger: financial incentive?
<18> :)
<12> hehe
<6> yeah you servers might be up longer or work more efficently
<6> thus saving your money
<20> you are dealing with opensource software.. even if it is a little encumbered.. let go of the concept of financial incentive son.
<19> Vger: Only if your goal is a job as a MySQL developer.
<18> I'm just trying to figure out how mysql development works :)
<21> i can insert multiple entries into a database with insert statement, but just doing multiple VALUES(a,b) entires, like INSERT INTO tablename VALUES('a',b'), VALUES('c','d'); is that right?
<11> leave out the second VALUES word
<21> oh, so just INSERT INTO tablename VALUES('a','b'),('c','d'); like that?
<11> right
<21> cooll, thank you very muhc :)
<19> Vger: We hire a bunch of developers (around 100). We tell them to write code, then we release their work under the GPL. In addition we incorporate some patches that come in from external developers.
<18> thanks mhillyer
<12> woah apparently using SQL_CALC_FOUND_ROWS disables order by and limit optimisations; has anyone found this? there are two bugs about it
<12> i'm using that all over the place
<12> #18454 # 19553
<22> It has to disable limit optimisations, I'm sure.
<2> is it possible to use temporary tables in subqueries?
<6> sure
<11> zaydana: as in create temporary x, select * from y where (select * from x); ? Sure.
<6> they are tables
<2> hmm... i'm getting a weird error, and I wondered if that might of been the reason, but it seems not
<2> think you could see if you can see whats wrong, if I pastebin it?
<6> maybe.
<22> pastebin the error message too?
<2> yeah, will do
<6> you have used subqueries before
<23> anyone using nfs mounted datadir? is there some more detailed opinion than "don't do it"?
<19> You really shouldn't do it.
<23> heh
<24> i'd recommend against it, because nfs isn't too stable
<22> grmbl: I used to do it
<22> Solaris client; Netapps server.
<23> we're using it very stable with sybase. netapp server, linux client
<2> http://pastebin.com/765285
<2> can you use a temporary twice in a query, if its in seperate subqueries?
<15> zaydana: why not? even in the same query or subquery, yuo can do self join
<23> but i have just read http://forums.mysql.com/read.php?123,43227,74506
<25> grmbl: Be very, very, very sure that locking works as you expect with your NFS server and all clients. Write programs to test that it actually works.
<26> how can i read the contents of a file foo.frm in mysql ???
<25> That said, I wouldn't do it. Can you get block-level network storage instead, like a SAN?
<19> Use MySQL?
Return to
#mysql
or
Go to some related
logs:
#perl
ati libexpat fedora
#oe
forget ubuntu password
#perl
FT232BM gentoo
#python
UdontKnow ircop
epochseconds in python
#linux
|
|