| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
Comments:
<0> safe_mysqld --log="/path/to/logfile"
<0> ^Migs^, normally you join on IDs instead of names
<1> wrong button :)
<2> hmm, good point
<0> but depending on what you want to do that looks like a valid query.
<1> BartVB: if someone try to connect to mysql and for example p***word or username are not correct, this connection will be logged to mysql.err?
<2> I was trying to tech support someone last night (he contacted me right before I was leaving). I'll have to get more info when he logs on later this morning
<2> he got an ambiguous clause error
<0> dob1, not sure? Try it :)
<1> BartVB: because i am trying to write a little program to connect to mysql and this program doesn't work but i don't see anything in the logs :)
<3> ^Migs^: yes, what's wrong is that both principas and sip will have a username field, and without specifying principals.*, sip.* after the select, it won't know which field goes with what table
<3> ^Migs^: hence ambiguous field name
<2> gotcha
<2> okay, makes sense. Thanks.
<3> ^Migs^: and select * (even select sip.*) is evil
<3> !tell us about evil
<4> shabbs asked me to tell you this: Evil is clearly defined at http://www.parseerror.com/sql/select*isevil.html
<2> to fix it, all I'd have to do is "SELECT sip.*, principals.* FROM sip left join principals on sip.username = principals.username"
<2> ?
<3> ^Migs^: yes, that should fix it
<2> what does that site say? It's filtered from where I am for "Jokes, Nudity, ***"
<0> shabbs, good point :) I ***umed that mysql would know that the fields are the same so it doesn't really matter which one it shows :) But I rarely use * because of these issues.
<0> ^Migs^, lol :)
<2> I don't normally use * either, unless it's just one table, mostly just because it seems to cause more problems than it solves
<2> but meh. I just want to resolve the issue for this guy.
<5> Migs, where are you that they don't allow jokes?
<6> hi, how can I lock all the tables from one particular database on my mysql server?
<6> (I need to myisamcheck them)
<7> Hi. There is changes in API behaviour. We use mysql_ping() to reenable connection with mysqld.
<7> From mysql 5.0.3 mysql_ping by default does not reconnects. So we have to use mysql_options(.., MYSQL_OPT_RECONNECT, ..);
<7> MYSQL_OPT_RECONNECT is available from mysql-5.0.13.
<7> But what is the right way to check if MYSQL_OPT_RECONNECT available and use it if availavle?
<7> What is the right way to check this with #if ?
<7> Shall I check for MYSQL_SERVER_VERSION or PROTOCOL_VERSION ?
<8> i have root access to a pc and i need to access the mysql database. i cannot figure out the login, is there anything i can do?
<0> davidbest, yes, read the manual :D
<9> is it possible to use WHEN somefield>5 && somfield<10 in a CASE ?
<10> Hello. Where is the log file for mysql stored by default?
<7> Ok. Seems that I shall use MYSQL_VERSION_ID. :)
<8> BartVB: what?
<0> davidbest, http://www.google.com/url?sa=t&ct=res&cd=1&url=http%3A//dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html&ei=runxQ-_DE5GUiAKbwLyuDA&sig2=5GonWU_1U_3PvZm8criJgA
<0> *grmbl*
<0> davidbest, http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html
<11> When I do the statement "SELECT id,subject FROM news WHERE id>5 ORDER BY id DESC LIMIT 5" I get the rows with id 15-11, which isn't what I want, I want the rows with id 6-10, which I get when I order it ASC, but then they come in the wrong order, anyone know what I might do to get the desired results?
<5> LIMIT allows an OFFSET argument, too
<5> try, LIMIT 5,5
<5> you could also say and id <= 10 ;)
<10> does anyone know where logs are kept for mysql so i can find out why its not starting?
<8> thanks
<3> FBH^: /var/lib/mysql/yourhostname.err or the syslog
<12> see in my.cnf or data.dir
<10> thanks
<3> generally
<10> sory, i should have specified "by default"
<10> because i havent changed it ;)
<13> :)
<10> i cant find it.. i dont have a /var/lib
<13> ZOMG!
<13> ;)
<5> /var/db/mysql is default on freebsd, if you are using it.
<8> BartVB: could i also use this method to create a new user, so i do not mess up anything that is relying on that root account login?
<10> yeah, i wasnt thinking.. i need to be root to cd to that dir ;)
<0> davidbest, most probably. But it's _very_ bad practice to use the root account anywhere except for admin tasks.
<14> recover: if you want results with from ive to ten, you don't do >10 ( more than ten ), you do less that ten :D
<0> So if I where you I would reset the p***word and move everything that breaks to a normal (non-root) account.
<15> hi
<15> MYSQL: (root@localhost) [mysql]> create function hasBit returns integer SONAME "bitMask.so";
<15> ERROR 1126 (HY000): Can't open shared library 'bitMask.so' (errno: 0 Service unavailable)
<15> Anyone ever seen that error message?
<11> draxas: I don't know for sure all the id's 6-10 exists when I do the query... It must be able to do somehow...
<16> morning all
<15> quite cool error number ;)
<15> morning
<14> recover: select * from somewhere where id >5 AND id < 11 ?
<3> recover: do you want exactly 5, such as 6,7,8,9,10 or if numbers are missing 5,7,9,10,11,12? or always between 5 and 10?
<3> doh I can't count
<3> but you get my point
<11> shabbs: Yea, I want to get 5 rows if some id's is missing
<15> recover: LIMIT 5
<11> LoonaTick: I guess you haven't read my question...
<15> mm
<15> you want 5 results even if only 4 match to those criteria?
<3> recover: as infi pointed out, limit 5,5 will return 5 results from the offset 5
<3> recover: this of course only works for 6-10 if you actually have 1-5
<8> how can i shutdown mysql from remote desktop when i dont have root on mysql?
<17> heh
<3> if you have root on the box you could kill the process
<17> kill -9 if you have root
<3> but that's ugly
<8> kill -9 in cmd menu?
<12> never -9 use -15
<17> uhh no
<0> kill -9 shouldn't be needed
<8> kill -15 mysqld
<8> ?
<0> killall -15 mysqld
<0> or try msqladmin first
<17> but why?
<0> mysqladmin shutdown
<8> mysqladmin is asking for a login
<3> he needs mysql root for that which he doesn't have
<12> -9 never reaches mysqld so it can shutdown cleanly
<18> hey
<0> sjrussel, it stopts mysql dead in it's track.
<8> killall: unrecognized command
<8> sorry
<17> BartVB - sry, meant for david
<8> should i mention this is on a win 2k system
<0> -9 doesn't give it time to close up anything
<17> hah
<18> what measures do you chaps have in place for dealing with persistent connections? do you just set something up to kill any connection that's idle for more than 10 minutes or something?
<3> hah
<3> yes, you should
<0> davidbest, :) yeah :)
<8> heh
<8> is there a cmd for windows i can use
<17> Edward123, why would you want to do that?
<3> davidbest: go to your services and shut it down from there
<8> when i do ctrl-alt-delete it just pulls up my processes, since i'm using remote desktop
<3> davidbest: right click on My Computer and select Manage
<18> sjrussel: otherwise connections will increase constantly until max allowed connections is exceeded
<3> davidbest: then go to Services and find mysql and hit stop. this ***umes that you installed mysql as a service
<17> do you mean application persistent connections?
<17> like from scripts running under Apache or something?
<17> 'don't use them'
<18> yeah that's what i mean
<3> Edward123: there is an idle timeout variable you can set, but generally as sjrussel pointed out, you don't really 'need' persistant connections
<18> i'm just trying to be prepared for every eventually
<18> idle timeout
<18> i'm sure you guys know how it is - you inherit a server packing tons of apps all using persistent connections, and it just isn't practical to change all the scripts
<8> thanks guys
<0> Edward123, iirc you can disable persistent connections on the server
<18> BartVB: then all the scripts will break, won't they?
<0> noope
<18> or will mysql_pconnect just act like mysql_connect in scripts?
<0> indeed
<17> Edward123 - unless programmed by idiots, there's probably one or only a few places to change the connectiontype
<18> to my understanding most of these scripts just include the connection stuff anyway
<12> dont use pconnect
<18> on every page
<18> so mysql_connect should work instead, right BartVB?
<17> manually?
<18> no
<0> Edward123, yup
<18> from what i've seen most of these scripts use 1 include file containing db l/p and make the connection
<18> for the project, that is
<17> Edward123 - there is very little difference from an application standpoint, pconnect vs. connect
<17> and the things that are different (temporary tables, etc) are bad
<18> truth be told it's been ticking along fine on it's default configuration but i'm looking into this now because it's actually the asp.net apps that have started killing mysql
<19> What would my select statement look like if I wanted to display all mercedes cars in my table, but not the ones that are blue? SELECT carid FROM cars WHERE type='mercedes' NOT color='blue' doesn't work.
<18> which is odd - maybe there's something in apache config that's stopping all this madness
Return to
#mysql
or
Go to some related
logs:
#python
#fedora
#openssh
PHPEclipse include_path
gentoo glxinfo libgl verbose
gday debian
power edge 2400 kernel panic sync install
#fedora
invalid module format bnx2
trwbw quote
|
|