laptop
On Thu, Oct 18, 2012 at 1:19 AM, kalin mailto:ka...@el.net>> wrote:
thanks amanda... the "local" worked for some reason...
in about 10 years of using mysql i have never had to do that.
i still wonder why would the thing not stat it.
file and dir are both
27 PM, Rick James mailto:rja...@yahoo-inc.com>> wrote:
SELinux ?
> -Original Message-
> From: Lixun Peng [mailto:pengli...@gmail.com
<mailto:pengli...@gmail.com>]
> Sent: Tuesday, October 16, 2012 9:03 PM
> To: k
have a file in /a/b/file, dir a is 644, even though file
is 777, we can't access file, too.
On Wed, Oct 17, 2012 at 10:31 AM, kalin wrote:
hi all..
this hasn't happe...
--
Senior MySQL Developer @ Taobao.com
Mobile Phone: +86 18658156856 (Hangzhou)
Gtalk: penglixun(at)gmail.
On 10/16/12 10:44 PM, Lixun Peng wrote:
Hi,
What's the dir permissions?
was 755. now 777. same result.
For example, if we have a file in /a/b/file, dir a is 644, even though
file is 777, we can't access file, too.
On Wed, Oct 17, 2012 at 10:31 AM, kalin mailto:ka...@el.n
hi all..
this hasn't happened before...
i'm in as root on the command line cleint. trying to load data infile
'/path/to/file'
file is owned by mysql and it has 777 permissions. the directory where
the file is is also owned by mysql.
when i do:
mysql> load data infile '/path/to/file' etc.
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
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
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
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:
>>
>>
&
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
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
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
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|
+-+--
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
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 |
--
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
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
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
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
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
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
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
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
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
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
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
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
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:
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
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
> You should be fine. 100 000 000 is not that much.
> Just make sure you set the right keys (and then query by them) on the
> table
> and even more importantly, set caches and buffers to utilize your RAM
> appropriately.
thanks.
> Olaf
>
>
> On 6/12/07 11:09 A
acceptable query execution time for
> you is.
> Also, what else does the machine do, are there other databases or tables
> that are queried at the same time, do you have to join other tables in
> for
> your queries, etc?
>
> Olaf
>
> On 6/12/07 3:24 AM, "kalin mintc
acceptable query execution time for
> you is.
> Also, what else does the machine do, are there other databases or tables
> that are queried at the same time, do you have to join other tables in
> for
> your queries, etc?
>
> Olaf
>
> On 6/12/07 3:24 AM, "kalin mintc
rds - are 90 mgb.
are the .MYI files kept in ram or both .MYD and .MYI?
multiplying 90x100 is what the size of the MYI + MYD will be, right?
is that all living in ram?
thanks
> Olaf
>
>
> On 6/12/07 3:24 AM, "kalin mintchev" <[EMAIL PROTECTED]> wrote:
>
>&g
means that i have to have about 8 gigs of ram to
successfully use a table like that. either that or cluster 2 machines with
4 gigs each and split the table. does this sound reasonable? is my logic
flawed somehow?
i'll appreciate any comments on this subject thanks...
> On 6/1
mber 5893786 - a unique id...
> trying to answer only based upon row count is NONSENSICAL, IMO.
>
>
> On 6/11/07, kalin mintchev <[EMAIL PROTECTED]> wrote:
>>
>> hi all...
>>
>> from http://dev.mysql.com/doc/refman/5.0/en/features.html:
>>
>
hi all...
from http://dev.mysql.com/doc/refman/5.0/en/features.html:
"Handles large databases. We use MySQL Server with databases that contain
50 million records. We also know of users who use MySQL Server with 60,000
tables and about 5,000,000,000 rows."
that's cool but i assume this is distrib
>
> Search speeds and CPU with MyISAM is quite good. I tried InnoDb and insert
> speeds was far too slow because of its row locking versus MyISAM's table
> locking. Some people have been able to fine tune InnoDb but it requires
> even more RAM because InnoDb works best when the entire table fits i
> Put as much memory in the machine as possible. Building indexes for a
> table
> of that size will consume a lot of memory and if you don't have enough
> memory, building the index will be done on the hard disk where it is 100x
> slower. I've had 100M row tables without too much problem. However
columns.
>
> Thanks
> ViSolve DB Team.
> - Original Message -
> From: "kalin mintchev" <[EMAIL PROTECTED]>
> To:
> Sent: Monday, February 05, 2007 9:14 AM
> Subject: mysql limits
>
>
>> hi all...
>>
>> i just wanted to ask here if someb
hi all...
i just wanted to ask here if somebody has experience in pushing the mysql
limits... i might have a job that needs to have a table (or a few tables)
holding about a 100 million records. that's a lot of records is there
any limitation of some kind that wouldn;t allow mysql to handle t
>
> but that will get you all records for that category not just the most
> recently updated.
>
that's the main problem, isn't it?
what i'm looking for is the last record for EACH of the categories in the
table. i'm aware of the aformentioned options.
my problem with group by is that ignores th
>
> Basically you can't do what you want either without temporary tables or
> using a subselect. Subselects are only available in mysql 4.1+ (I think
> - check the docs) so that may or may not be an option.
thanks... pardon my ignorance - how would i do that using subselects?
>
--
MySQL Gen
hi all...
i have an issue with group by and ordering. apparently group by ignores
'order by id DESC'?!
an example is a table that has an id and a category fields. there are a
few categories under which records can be filed. so what i want is the
latest record from each category by doing somet
>
> select id,title from content where id IN(10,20,30);
cool thanks.. what if i want it to be random ordering like:
select id,title from content where id IN(20,10,30);
and i would like the order of the ids and the in() to be kept in the
result array. what 'order by' would i use?!
>
>
--
My
hi all...
how can i do a query on a list of ids without doing individual queries
for each one of them?
something like:
select id,title from content where id = 100,106,109;
of course this doesn't work... is it possible somehow?
thanks
--
MySQL General Mailing List
For list arch
>
> http://dev.mysql.com/doc/refman/5.1/en/charset-binary-op.html
>
> It has some good examples.
got it thanks...
>
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
hi all...
i found this on the mysql dev manual site:
"MySQL 4 and later string comparisons, including DISTINCT, aren't case
sensitive unless the field is declared as BINARY or you use BINARY in your
comparison."
so here i tried it but no good. any ideas?! the field is not declared
binary but i do
hi all...
i can't see the mysql 5 version for freebsd 6.0 on the mysql developer
site?
am i blind or it's on purpose?!?!
curious... and actually need it...
thanks...
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql
hi all...
what's the best way to periodically back up mysql data?
so that databases and tables can be still usable even after a mysql upgrade?
thanks...
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
hi all...
whats the problem with this:
load data infile 'stores.txt' into table useyourcash_sports_us (chain,
store, address1, address2, city, state, zip,web) FIELDS TERMINATED BY '\t'
i get:
You have an error in your SQL syntax; check the manual that corresponds
to your MySQL server versi
>>
>>
> Yes you're right! you can safely delete those - but first make some
> changes... as it seems you've set up root password only for :
> [EMAIL PROTECTED] - right? that's why you can't login using
> localhost (mysql without -h host option assumes -h localhost and if you
> only changed passwor
> Sorry I first misread yor question (I hope I cancelled prev. post on
time). I thought you have problems connecting to mysql while actual
problem is: Why it is so easy for everyone (even from outside) to
connect?
> Yes this is normal: default user is root *without password*
> if you wan't to secur
system freebsd 4.10
mysql is binary: mysql-standard-5.0.15-freebsd4.7-i386
after mysql installation and root password set up i can type:
/usr/local/mysql/bin/mysql -u no_matter_what_user_here
and i get right in. even if i type -p. i do get the password prompt but
doesn't matter what
hi all...
is there a simple way to export data from mysql tables? like the opposite
of 'load data infile'? i was looking around in the manual but without
success...
thanks.
--
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists
n one things from 'that':
insert into table_name (place, address, number,number_too) select
"stuff","stuff2", this, this_too from that where one=two;
thanks...
>
> i may yet have the syntax wrong, but its close.
>
>
> kalin mintchev wrote:
>> hi all
hi all...
i need some help. can somebody explain why is this insert/select not working?
insert into the_db (place,address,number) values("stuff","stuff2",select
this from that where one=two);
i tried ()s around the 'select' too but it didn't work.
thanks.
--
--
MySQL General Mailing Li
e to
> run it right after you run
> your query (or LOAD DATA). That may be why you can't use it.
>
> Also, try looking under instead of a log file. That might
> help out.
>
> J.R.
>
> -Original Message-
> From: kalin mintchev [mailto:[EMAIL PROTECTED]
>
stead of a log file. That might
> help out.
there is no such file on this machine...
thanks
>
> J.R.
>
> -Original Message-
> From: kalin mintchev [mailto:[EMAIL PROTECTED]
> Sent: Thursday, December 09, 2004 7:29 PM
> To: J.R. Bullington
> Subject: RE: Dele
sql-standard-4.0.13 to old for show warnings!?
(J.R., sorry about the double post...)
>
> J.R.
>
> -Original Message-
> From: kalin mintchev [mailto:[EMAIL PROTECTED]
> Sent: Thursday, December 09, 2004 6:53 PM
> To: [EMAIL PROTECTED]
> Subject: Deleted: 0 Skipped
hi all...
where can i see what these warnings are. i get them when i do load data
infile.
i was looking for some kind of log under /var/logs/ or mysql/var/log but
there isn't a log file for mysql at any of those locations. and the
mysql/var/ doesn't exist at all.
i created it and redid the load bu
>
> - Original Message -
> From: "kalin mintchev" <[EMAIL PROTECTED]>
> To: "Adam" <[EMAIL PROTECTED]>
> Cc: "MySQL General" <[EMAIL PROTECTED]>
> Sent: Sunday, November 14, 2004 11:33 PM
> Subject: Re: syntax quest
> Kalin,
>
> Kalin> thanks to all... yes, Rhino - i'm new. my first
> Kalin> post. the version is the problem indeed. it's
> Kalin> 4.0.13-standard. how would i achieve the same
> Kalin> query in this version?...
>
> You'll need to provide th
an earlier version.
> you may also cause a conflict by using the database alias (t1) as the
name
> of the result
> Peter
>> -----Original Message-
>> From: kalin mintchev [mailto:[EMAIL PROTECTED]
>> Sent: 14 November 2004 23:06
>> To: [EMAIL PROTECTED]
&g
hi everybody..
can somebody please explain what is wrong with this command:
select t1.data from table1 as t1 where t1.zip=(select * from table2 as t2
where t2.chain like "%carmike%");
thank you...
--
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscri
hi all,
load data infile doesn't work with escaped by '\\' line
terminated by '\r'
the problem is the '\r' . doesn't work with '\r\n' either.
if i replace the \r with \n in the the text file itself then it works
fine the files i'm trying to load are tab delimited txt files generated
by xc
ven need "-h localhost" in this case.
>
> Best regards
>
> Nils Valentin
> Tokyo/Japan
>
>
>
> 2003年 6月 3日 火曜日 11:31、Kalin Mintchev さんは書きました:
> > hi everybody...
> >
> > i just installed mysql 4.0.13 on a redhat linux 8.0
> > when i creat
hi everybody...
i just installed mysql 4.0.13 on a redhat linux 8.0
when i create a database as root and then grant privileges to another user
like this:
GRANT ALL ON somedb.* TO [EMAIL PROTECTED] IDENTIFIED BY "passwd";
everything seems to be fine but then if i log in as "user" and try to get
t
68 matches
Mail list logo
