wrote:
Hello.
Check that you don't have problems with filesystem. Start mysqld
directly, specify the corresponding variables in the command line.
If it doesn't produce errors switch to the debug version of the server
and use the trace files to find where the problem is.
Ron Gilbert <[EM
After almost a year of being up, my RH9 server lost power and rebooted.
When it came back up, mysql was not running. I went in and ran
safe_mysql to start it back up (I also tried the init.d script) but it
failed to start. No errors, nothing in the log. After some
investigation, it appears
do a subquery to count the
clicks,
then left join that with the views.
HTH
Bill
From: Ron Gilbert <[EMAIL PROTECTED]>
Subject: Yet another LEFT JOIN question
Date: Sat, 4 Dec 2004 12:08:43 -0800
I have three tables, 'Ads' is a list of ads, 'Clicks' is a simple list
of
I have three tables, 'Ads' is a list of ads, 'Clicks' is a simple list
of every time a Ad was clicked on with the Ads ID, and 'Views' is a
simple list of views that ad got, with the Ads ID.
I am trying to SELECT a list of all the ads, with a count for clicks
and a count for views, but my LEFT J
rom the MySQL downloads page
<http://dev.mysql.com/downloads/mysql/4.1.html>.
Michael
Ron Gilbert wrote:
I just installed debian (test) and am trying to get mysql 4.1
working. The only deb package for 4.1 that I could find was
"experimental", which might explain the problem I am hav
I just installed debian (test) and am trying to get mysql 4.1 working.
The only deb package for 4.1 that I could find was "experimental",
which might explain the problem I am having.
When I start the server, I get the following in my syslog:
Oct 31 01:35:22 cove1 mysqld_safe[2523]: started
Oct
Thanks, that did the trick.
On Aug 17, 2004, at 12:34 PM, [EMAIL PROTECTED] wrote:
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I am trying to run this query...
select distinct E.Title, E.ID, C.DateAdded from
Entries E, Comments C
where C.EntryID = E.ID
order by C.DateAdded desc
limit 10
...to get the last 10 entries that had comments added to them, but the
DISTINCT is not returning distinct results. What I get is 10 entr
I am going to upgrade my MySQL server from 3.23 to 4.1, but I have a C
program that needs to continue to connect to the new server, and it
can't be recompiled. Is the old API 100% backwards compatible with a
4.1 server? I assume the performance is the same?
Ron
--
MySQL General Mailing List
Here is my problem. I want to create a simple message posting system so
users can post comments to news stories. I would like the comments to
be nested, and not appear as a single long list.
Is there away to retrived all the comments from a table order by the
date the parents were added, but n
When you connect to a MySQL server remotely (from the C API, in my
case), is your MySQL password sent in clear text?
I've looked but I can find an answer to this question in the
docs...maybe I'm missing it.
Ron
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To un
th it.
Other than whats in the docs, are there other issues to think about when
upgrading from 3.23? Can I go straight from 3.23 to 5.0? According to
the docs, it just seem to be the GRANT tables.
Ron
Josh Trutwin wrote:
On Sun, 16 May 2004 13:51:29 -0700
Ron Gilbert <[EMAIL PROTECTED]>
I am going to upgrade from 3.23 and was wondering if 4.1.1 is stable
enough? This is just for some personal websites, nothing mission
critical, but on the other hand, I don't want to deal with endless
problems.
The reason that I'd like to go to 4.1.1 is for sub-selects, otherwise
I'd stick to
I have a table that is:
CREATE TABLE GPSData (
ID int(10) unsigned NOT NULL auto_increment,
Lat decimal(9,5) default '0.0',
Lon decimal(9,5) default '0.0',
TDate datetime default NULL,
PRIMARY KEY (ID),
UNIQUE KEY ID (ID),
KEY ID_2 (ID)
) TYPE=MyISAM;
When I insert a GPS log i
Is there a way to create a GRANT for a DB so that only one user can
access to the database? The only way I can see to do it involves taking
every user and GRANT them access to every other database, but not this
one.
The problem I face is that I share a server with three friends, and we
all cr
I am trying to get a distinct dates (not time) from a column. I am
currently doing this:
SELECT DISTINCT DATE_FORMAT(DateAdded, '%Y-%m-%d') FROM Bla
Is this the best way to be doing this? Seems very inefficient do to the
call to DATE_FORMAT for every row. Is there a way to have a query only
Is there a way to create a GRANT for a DB so that only one user can
access to the database? The only way I can see to do it involves taking
every user and GRANT them access to every other database, but not this
one.
The problem I face is that I share a server with three friends, and we
all create
I am wondering what the best backup strategy is for my database.
The database is used to store a very large number of binary files,
ranging from a few K to 20MB's. The database stores thousands of these
files. I can not put this data on the file server, it needs to be in
the database.
Curren
18 matches
Mail list logo
