Re: file privilege

s, "db" is > specific to each database. > > Carlos > > > On Mon, Jan 30, 2012 at 10:56 PM, kalin m <mailto:ka...@el.net>> wrote: > > > > hi... > > so i have this user in the user table in the mysql db that has all the > pr

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 user@l

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" >> >> ok. thanks. i thought so. it's been about 8 hrs

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 wrote: >> >> &

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. t

Re: update and times

Simcha Younger wrote: On Mon, 04 Oct 2010 16:11:08 -0400 kalin m 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: 1286216

Re: update and times

rent about the values you 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: Mo

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: subquery multiple rows

08:37:04AM -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 | shoe

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 | --

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 to

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 i

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

Re: if count

i do that?! thanks Perrin Harkins 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

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: conditional sum

ut that's not it. and the 1464 is the correct number for b.money... 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

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 o

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 p

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\040privi

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

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: http

Re: mysql 5.0.51b and ssl

there any 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/lo

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:

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 (/|index_co

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. i