R u trying to connect as user owning all the database.
Looks like there is permission issue.
Please make sure, the user ur logging in has all rights on all the database
in mysql.
regards
anandkl
On Thu, Aug 19, 2010 at 8:37 PM, jitendra ranjan
jitendra_ran...@yahoo.comwrote:
Here is few lines
Gavin,
Thanks for the great reply, this is actually what I was looking for.
However, do you have any suggestions on how to order the fixtures / teams ?
Basically the query is returning the teams grouped together like :
'2', '1'
'3', '1'
'4', '1'
'1', '2'
'3', '2'
'4', '2'
'1', '3'
'2', '3'
2010/8/20 Elim PDT e...@pdtnetworks.net
There are so many versions of 5.1, Is there some review or recommendations
for a stable one? thanks
As far as I know, 5.1 is considered a stable branch, and you can safely take
the most recent release as it should contain mostly fixes.
--
Bier met
Hi!
Elim == Elim PDT e...@pdtnetworks.net writes:
Elim There are so many versions of 5.1, Is there some review or
Elim recommendations for a stable one? thanks
Just download the latest MySQL 5.1 or MariaDB 5.1 release for your
platform. Both should be stable enough for your usage.
Regards,
On 20/08/2010 4:43 a, Elim PDT wrote:
There are so many versions of 5.1, Is there some review or recommendations
for a stable one? thanks
I hear 5.1.50 has been released; should be stable. Just out of interest,
what OS are you using to host your mysql database?
--
Jangita | +256 76 91 8383 |
On 20/08/2010 2:45 a, George Larson wrote:
I hope I've come to right place, and I'm asking in the right way -- please
accept my apologies if not.
We have some dates missing and I need to populate those fields with dates
from the record just before them. I've gotten this far:
SELECT UUid,
Hi all!
Johan De Meersman wrote:
2010/8/20 Elim PDT e...@pdtnetworks.net
There are so many versions of 5.1, Is there some review or recommendations
for a stable one? thanks
As far as I know, 5.1 is considered a stable branch, and you can safely take
the most recent release as it
The account has full permission on all the databases.
--- On Fri, 20/8/10, Ananda Kumar anan...@gmail.com wrote:
From: Ananda Kumar anan...@gmail.com
Subject: Re: MySQL Server has gone away
To: jitendra ranjan jitendra_ran...@yahoo.com
Cc: Krishna Chandra Prajapati prajapat...@gmail.com,
On 8/19/2010 8:45 PM, George Larson wrote:
I hope I've come to right place, and I'm asking in the right way -- please
accept my apologies if not.
We have some dates missing and I need to populate those fields with dates
from the record just before them. I've gotten this far:
SELECT UUid,
On 8/19/2010 11:07 AM, jitendra ranjan wrote:
Here is few lines from log:
100703 22:12:48 mysqld ended
100703 22:23:39 mysqld started
100703 22:23:40 [Warning] option 'max_join_size': unsigned value
18446744073709551615 adjusted to 4294967295
100703 22:23:40 [Warning] option 'max_join_size':
Hello everyone,
I've actually a database (MySAM) which is growing very quickly (1,3Go/hour).
I would like to limit the size of the database but with a log rotation after
the size is reached. Do you know a way to do it ?
I thought of maybe a script who would delete the oldest entry when it reach
a
I am trying to produce charts for large amounts of data. I already limit
the user to a smaller time frame in order to reduce the possible data
points, but still can end up with far more data points than are clearly
plottable on a chart. Does anyone have an idea of how I can drop
insignificant
On 20/08/2010 5:12 p, Bryan Cantwell wrote:
I am trying to produce charts for large amounts of data. I already limit
the user to a smaller time frame in order to reduce the possible data
points, but still can end up with far more data points than are clearly
plottable on a chart. Does anyone
Yes, but I DON'T want eh spikes smoothed out
On Fri, 2010-08-20 at 17:16 +0200, Jangita wrote:
On 20/08/2010 5:12 p, Bryan Cantwell wrote:
I am trying to produce charts for large amounts of data. I already limit
the user to a smaller time frame in order to reduce the possible data
points,
On 20 Aug 2010, at 16:24, Bryan Cantwell wrote:
Yes, but I DON'T want eh spikes smoothed out
Display the max and min of each successive set of 10 (or 100 or 1000) elements
from the data ?
--
TTFN.
Philip Riebold, p.rieb...@ucl.ac.uk
--
MySQL General Mailing List
For list archives:
I am not too good with charting (even though I would like to be), but what
about getting the max, min and avg, if the max/min is greater than x% of the
avg, show that... ?
Just throwing out ideas... prolly not useful... but may cause a better idea ;)
Steven Staples
-Original
On 20/08/2010 5:24 p, Bryan Cantwell wrote:
Yes, but I DON'T want eh spikes smoothed out
On Fri, 2010-08-20 at 17:16 +0200, Jangita wrote:
On 20/08/2010 5:12 p, Bryan Cantwell wrote:
I am trying to produce charts for large amounts of data. I already limit
the user to a smaller time frame in
On another thought, what about if you group it by whatever, if the MIN()/MAX()
is greater than X times STDDEV(), show MIN() or MAX() ?
I just recalled a conversation with my boss the other week about the STDDEV()
Steven Staples
-Original Message-
From: Steven Staples
Well, it wouldn't exactly limit the size of your tables, but you may want to
look into creating a partitioned table to store your data. You could define
your partition ranges to store a single day's worth of data or whatever
granularity works best for you. Then, when you need to remove older
I've been watching our mysqld procs in htop and the root thread is
using 75-100% of a CPU most of the time. I'm trying to understand
what that is being used for, and so I was hoping someone could tell me
what that thread does that might be using a lot of CPU.
We are using 5.5.4-m3, we use MyISAM
Carl you don't wish go offer so sample code ?
On 19 Aug 2010, at 19:18, Carl c...@etrak-plus.com wrote:
I have written this in both C and Java. It is very complex as, in
real
life, you want to balance home and away, sequence the games so that
the home
or away games are spread throughout
In regards to this issue, I submitted a bug.
http://bugs.mysql.com/56157
nixofortune wrote:
Hi ALL,
I just start using Workbench 5.2.26 CE and this is a problem I have.
When I try to run a query with a case statement, columns with datetime
Type shown as BLOB in output window.
To see the
I am hoping that I can do this with one query, I have a table, Domains
with 3 columns
accountID, domainID, mailname
what I am trying to do is find all accountID's for domainID of 12345 and
see if a second row with domainID of 54321 exists for that
accountID,mailname. If it doesn't exist, I
23 matches
Mail list logo