| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
Comments:
<0> we talk latter... i have to join this channel more often!
<1> whats ur real name?
<0> Filipe
<1> cool
<1> mine i nilesh
<2> yo
<1> btw do tell me abt ur hot frind gupta
<1> lol
<2> Nilesh, try www.onlinedating.com
<2> :)
<1> lol
<1> lali_
<2> Yes
<1> is it free
<2> Not sure, but your in india so i doubt it will cost you anything
<2> even if you download music, its not like the us government can do anything about it :)
<3> SELECT l.Id, l.ListName, COUNT(a.Id) AS CountMessages FROM lists AS l LEFT JOIN archive AS a ON l.Id=a.ListId GROUP BY l.Id ORDER BY l.Id ASC <---- How acn I make it only return rows where CountMessages > 0?
<2> and hey, why not just give it a crack :)
<1> how do u know lali_
<1> ?
<2> ur host name
<2> :)
<1> ??
<0> Nilesh, PVT
<4> these need to go today 2 laptops, both made by good manufacturers. price is 500$ each for them and include shipping, case and wireless router. message me if interested on aim at ogd443 or msn at mcsltd2@hotmail.com
<5> oh i want one!
<1> ok
<5> can i have a stolen laptop plz?
<2> n=yagnesh@203.193.154.21
<1> PVT
<2> Nilesh its very simple
<2> do a whois query
<2> on ur ip
<1> okz
<6> arjenAU hey, ya there?
<7> spudnick: no
<6> cool, well, just wanted to let ya know that I fixed my prob last night and also wanted to thank you for your ***istance
<1> patafurdio: PM
<1> lali_ ur from?
<2> usa
<2> virginia
<1> okz
<1> r u m/f?
<2> m
<1> lol
<1> sounds f
<2> bro i told u, www.onlinedating.com
<6> i was able to reset my mysql p***wd and then able to figure out why phpmyadmin wasn't working - turns out i merged in a newer version and it the config.inc.php file I ended up creating had the default controluser in place
<1> naaa
<1> i do not belive in online dating
<6> once I fixed that back to the one I created, everything worked fine
<2> if ur looking for some action nearest to you
<2> well if u keep asking people about women and you seek women on irc
<2> its almost the same thing
<2> ;)
<1> lol
<1> i am for technical knowlegde here
<0> Nilesh, i'm talking to you on PVT... you not getting nothing??
<6> anyone running mysql-5.xx on a gentoo machine?
<2> it doesn't seem like it ;)
<1> i repliede to u
<1> plz check
<0> nothing... :S
<1> yeah
<1> i am preparing my daily report
<1> :)
<1> patafurdio: we will chat some day
<1> may be tomarow
<1> very nice talking with you
<1> u r such nice n generous person
<1> bbye
<1> :)
<1> TC
<1> i am heading for home now
<0> U too!
<0> Bye!
<8> is it possible, and where should I read up on, to set connection timeouts on a per-user basis
<9> does mysql not follow symbolic links?
<9> sudo /etc/init.d/mysqld start <- works
<9> sudo /etc/init.d/mysqld stop <- works
<9> sudo mv /var/lib/mysql/mysql/ /home/mysql/
<9> sudo ln -s /home/mysql/mysql/ /var/lib/mysql/mysql
<9> sudo /etc/init.d/mysqld start <- fails
<9> (Timeout )
<9> Fatal error: Can't open and lock privilege tables: Can't find file: './mysql/host.frm' (errno: 13)
<9> any ideas?
<10> !perror 13
<11> System error: 13 = Permission denied
<12> sudo chmod -R 777 /
<13> SpComb: that's mean
<12> s proper umask and no more permission denied errors
<12> klync: it's called windows!
<14> hello :)
<14> is there a way to limit the number of mysqld process ??
<13> SpComb: well, if you weren't trying to play a cruel joke, but are going to compare it to windows (rightfully), then that's just dumb
<13> ;)
<12> both?
<12> as in, first, second as an afterthought
<13> SpComb: oh well, at least it's not that cute little perl script that does `exec(echo rm -rf /)`
<9> SpComb : sudo chmod 777 -R /home/mysql/ didn't fix the problem
<12> it's just interesting to think that something that "severely breaks, requiring a reinstall" one OS, is seen as the norm on another OS
<12> :o
<15> lets not get into that right.
<15> now.
<12> I shall be getting to sleep
<9> SpComb: thanks for your help anyway
<14> damned i have at least 10 process mysqld launched ?!!
<16> hi. i am running mysql 5.0.18 and create table foo(a blob default '' not null); succeeds with STRICT_ALL_TABLES despite the manual says no default for BLOB. What am I missing?
<16> nobody :( ?
<9> chx: sorry... I'm used to Postgres
<9> chx: here for a problem of my own, actually
<14> rhaaa noway to find decent docs on my.conf ?!!
<9> chx: do you happen to be running mysql with a non-default data-directory?
<9> CapNemo: I've looked... I find lots of problem posts
<14> yup no doc !
<17> hiya. hopefully this is a channel for mysql questions.. I'm getting inconsistant results from the host portion of the USER() function; I had been using it to grab the client's IP, where the client is a windows program i wrote using a mysql client library. what's happened is that, after using this in a ton of locations and on a ton of customers, i ran into one who has 4 machines where the hostname part of USER() actually returns the full windows hostn
<17> so my question is basically, how can I make user() always return the actual IP of the sql client instead of occaisionally the hostname, or, how else can I get mysql to tell me the client's IP other than the user() function
<9> epictetus: maybe a Windows domain name?
<17> LimeKMag: huh?
<17> LimeKMag: i mean, i could try to set it up so my mysql server machine talks to the domain's DNS server and then code the rest of my app so that it resolves any hostnames p***ed into IPs...
<17> LimeKMag: but i would much rather not do that
<17> LimeKMag: if there is a way to make mysql tell me the client's ip address that would be much handier. user() worked this way quite well until I ran into these 4 machines that behave differently.
<9> epictetus: well, good luck. Unfortunately, I don't know much at all about mysql
<17> the other option is i figure out what is different about these 4 and change it, but i'd rather fix my code so that it just works without needing fixing of other things
<17> hehe
<9> epictetus: have you ever run mysql with the data stored in a non-default directory?
<17> no
<9> epictetus: I'm trying to keep my data out of the system partition
<9> epictetus: but mysql isn't helping
<18> Hey all.. WHERE BINARY is case sensitive, right? But it's also the best way to prevent an SQL injection in my field. So how can I make it ignore the case?
<9> jbrimble: you're doing some server-side filtering?
<9> jbrimble: which language are you using for your filtering?
<18> My software is written in VB.NET
<19> is it possible for an sql statement to crash mysql/apache?
<9> devians: anything is possible
<9> devians: find a nice bug?
<9> devians: maybe your query is just hogging CPU for a long long time?
<20> jbrimble: Using parameters should take care of your SQL injection problems.
<18> thanks mhillyer
<19> SELECT DISTINCT ID_key , tag , key.name AS keyname , owner.name AS ownname, area.name as aname FROM key , owner, area WHERE key.ID_owner = owner.ID_owner and key.ID_area = area.ID_area
<19> that just stops apache dead in its tracks, have to stop and restart it
<18> mhillyer - Hey, are you the author of vbmysql.com?
<19> running it from phpmyadmin
<20> I am.
<18> :) I've read all your articles
<20> Did you like them?
<18> Yes, they've really helped a lot with my project.
<20> Good to hear.
<21> why does a 'DROP DATABASE "name"' on a large database cause all other threads to wait?
<22> Hello everyone!
<9> hey nitebyte
Return to
#mysql
or
Go to some related
logs:
opopanax gentoo
#centos
fluxbox edgesnapthreshold
#perl
#sdl
#php
#php
ubntus
#web
#postfix
|
|