file privilege

hi... so i have this user in the user table in the mysql db that has all the privileges but grant. now i need for that user to have the file privilege so it can do into outfile. thing is i don't see that privilege anywhere in the db table. i know that i have to do the grant file on

Re: file privilege

. Carlos On Mon, Jan 30, 2012 at 10:56 PM, kalin m ka...@el.net mailto:ka...@el.net wrote: hi... so i have this user in the user table in the mysql db that has all the privileges but grant. now i need for that user to have the file privilege so it can do into outfile

Re: MYD, MYI and TMD files

thanks. it took about 15 hrs. but right now everything seems ok. does the check last as long as the repair? On 1/24/12 3:51 AM, Johan De Meersman wrote: - Original Message - From: kalin m ka...@el.net ok. thanks. i thought so. it's been about 8 hrs so far. and the TMD file is about

Re: MYD, MYI and TMD files

hey. this list used to be pretty active. did anything change? is there another place to ask questions like these? thanks... On 1/23/12 5:02 PM, kalin m wrote: hi all.. i started a repair on a table that has an MYD file of 9.2 gigs. the MYI file is 7.7 gigs. the TMD file, which i'm

Re: MYD, MYI and TMD files

: This is still the list although more quiet than it used to be. Repairing a table is already a fragile process.. I would not try to interrupt it if the data has no backup. - michael dykman On Mon, Jan 23, 2012 at 11:04 PM, kalin m ka...@el.net wrote: hey. this list used to be pretty active

Re: update and times

Simcha Younger wrote: On Mon, 04 Oct 2010 16:11:08 -0400 kalin m ka...@el.net wrote: what i'm trying to do is update the column only of one of those times isn't yet passed. and it works. except sometimes... like these 2 unix times: this was in the table under unix time

update and times

hi all... i'm doing tests with a table that gets updated based on random unix times it contains. there is a column that has a bunch or random times that look like: +-+---+ | date_time | unix_time|

Re: update and times

have in your table. Try posting the SHOW CREATE TABLE table \G output, and a sample INSERT statement to populate the table. That way someone can try to reproduce the behavior you're seeing. -Original Message- From: kalin m [mailto:ka...@el.net] Sent: Monday, October 04, 2010 1:11 PM

subquery multiple rows

hi all... i have a bit of a problem with this: table products: -- prod | category | -| boots | winter| boots | summer | boots | spring | shoes | spring | shoes | winter| shoes | fall | shoes | summer | --

Re: subquery multiple rows

-0700, kalin m wrote: hi all... i have a bit of a problem with this: table products: -- prod | category | -| boots | winter| boots | summer | boots | spring | shoes | spring | shoes | winter| shoes | fall | shoes | summer

user expires?

hi all... i had a weired thing happened is it possible for a user privileges to expire?! suddenly today an application stopped working and i was getting the message that the user can't login. now, i did mess with it last night trying to give it file privileges but since i would have

select into outfile php problem

hi all... i have a strange problem with a simple script that is doing select into outfile... the thing just does that. it does a select into an outfile. if i print the query that's passed to mysql_result in the script and then copy it and paste it z`into the mysql client it works fine but

Re: if count

right null did it... thanks... Leonardus Setyabudi wrote: try something like : count(if(a.type = 'SBR', 1, null)) count will ignore null value .. and only count the one with 'SBR' value br, Leo On 24/09/08 12:09, kalin m wrote: no, not really... sum is part of the query: count

if count

hi all... can somebody explain why a conditional count like this one doesn't work: count(if(a.Type = Signature Based Return, a.amount,'')) group by order by or if(a.Type = Signature Based Return, count(a.amount),'') group by order by... thanks... -- MySQL

Re: if count

wrote: On Tue, Sep 23, 2008 at 9:29 PM, kalin m [EMAIL PROTECTED] wrote: count(if(a.Type = Signature Based Return, a.amount,'')) group by order by I think you're looking for sum(). - Perrin

conditional sum

hi... how do i do conditional sums? like: select a.job, sum(if b.amount 0 then amount end if ) from t1 as a left join t2 as b on a.account=b.accoun where a.account = b.account group by a.job; or select a.job, if b.amount 0 then sum(b.amount) end if from t1 as a left join t2 as b on

Re: conditional sum

... any ideas?!. thanks. kalin m wrote: hi... how do i do conditional sums? like: select a.job, sum(if b.amount 0 then amount end if ) from t1 as a left join t2 as b on a.account=b.accoun where a.account = b.account group by a.job; or select a.job, if b.amount 0 then sum

mysql cli 5.0.51b

hi all... i just build from source 5.0.51b on a freebsd 7... works fine. but the cli displays \40 for white space on remembered commands. like in flush\040privileges;. pretty annoying specially for long ones. how to fix? thanks -- MySQL General Mailing List For list archives:

Re: mysql cli 5.0.51b

i use the cli exclusively... how can i fix this?! kalin m wrote: hi all... i just build from source 5.0.51b on a freebsd 7... works fine. but the cli displays \40 for white space on remembered commands. like in flush\040privileges;. pretty annoying specially for long ones. how to fix

Re: mysql cli 5.0.51b

the \40 is all over the .mysql_history?!? kalin m wrote: i use the cli exclusively... how can i fix this?! kalin m wrote: hi all... i just build from source 5.0.51b on a freebsd 7... works fine. but the cli displays \40 for white space on remembered commands. like in flush\040privileges

Re: Database for a library

assuming this is for books/pages to be displayed on line... how about if you just keep just important stuff in mysql like chapter titles and how many pages the book has, author, edition, etc then you keep files for each page (or book) in the filesystem - xml, txt, etc - and you just make a

mysql 5.0.51b and ssl

hi all... i just installed openssl 0.9.8h and trying to build mysql 5.0.51b with it on a freebsd 7 machine. i get this: /usr/bin/ld: /usr/local/ssl/lib/libssl.a(t1_srvr.o): relocation R_X86_64_32 can not be used when making a shared object; recompile with -fPIC /usr/local/ssl/lib/libssl.a:

Re: mysql 5.0.51b and ssl

flags i can change in the Makefile for the mysql build? does it have to be a 'shared'? static?! thanks... kalin m wrote: hi all... i just installed openssl 0.9.8h and trying to build mysql 5.0.51b with it on a freebsd 7 machine. i get this: /usr/bin/ld: /usr/local/ssl/lib/libssl.a

indexes and speeds

hi all... just wondering what is the performance difference between: PRIMARY KEY [/|index_type|/] (/|index_col_name|/1,/|index_col_name|/2) at the time of the table creation or create index index_name1 on table_name (/|index_col_name|/1); create index index_name2 on table_name

default my.cnf?

hi all... i have a 5.0.33 build from source on a freebsd 4.10 machine... i'm looking for a my.cnf file. ps tells me that the base dir is /usr/local but there is no my.cnf there. and i cant find one anywhere. i can get all the variables set up from the cli but i need to change some of them.