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
leather seats and cruise control...
It may make an interesting hobby to build your own car but I hate reinventing the
wheel.
Gilbert
-Original Message-
From: Martijn Tonies [mailto:[EMAIL PROTECTED]
Sent: 28 June 2004 11:39
To: mysql
Subject: Re: triggers or stored procedures
Hi Carlos
Is it possible to use the mysqldump function from within a web application
on a Windows based server using PERL or ASP or do I have to be logged in to
the actual command line MySQL Client with Root Privileges?
Thanks in advance,
Chris
_
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
uot;UNLOCK
TABLES;" in the middle of the insertion block. Hence, the syntax error during
restoration.
Is this a mysqldump bug?
Regards,
Gilbert
-Original Message-
From: Gilbert Wu
Sent: 24 May 2004 17:10
To: Brian Reichert
Cc: [EMAIL PROTECTED]
Subject: RE: mysqldump problem
Sorr
Sorry, I am running MySQL 4.0.17-nt on Windows 2000 Server.
-Original Message-
From: Brian Reichert [mailto:[EMAIL PROTECTED]
Sent: 24 May 2004 15:42
To: Gilbert Wu
Cc: [EMAIL PROTECTED]
Subject: Re: mysqldump problem
On Mon, May 24, 2004 at 03:07:17PM +0100, Gilbert Wu wrote:
>
abase I can backup and restore?
Many Thanks.
Regards,
Gilbert Wu
[EMAIL PROTECTED]
<http://www.sabrefund.com/> http://www.sabrefund.com/
Sabre Fund Management Limited
Windsor House
55 St James's Street
London SW1A 1LA
Tel +44 20 7316 2820
Fax +44 20 7316 0180
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
Hi,
We are developing in Microsoft's C++.NET with MS SQL Server as the underlying DBMS. We
are planning to move to MySQL.Please kindly advise if there is a OLEDB provider for
MySQL? or do I have to stay with ODBC?
Many thanks.
Gilbert Wu
--
MySQL General Mailing List
For list archives:
Hi all,
I have some questions I thought people might be able to enlighten me on.
I have a database of website content that I have inherited that is
full of standards-killing html (about 500 website pages; long story). I
would like to change that, but its a job that is a little too big for
on
Try something similar to this:
ConStr = "Provider=MSDASQL;DRIVER=MYSQL ODBC 3.51
DRIVER;SERVER=ABC;DATABASE=MYDATABASE;UID=root"
Gilbert Wu
[EMAIL PROTECTED]
http://www.sabrefund.com
Sabre Fund Management Limited
Windsor House
55 St James's Street
London SW1A 1LA
Tel +
umns. In SQL SELECT
statements, you can concatenate columns using a special operator.
Depending on what DBMS you are using, this can be a plus sign (+) or two
pipes (||).
Neither seem to work.
Can anyone point me in the right direction?
Thanks.
Gilbert Wilson
--
MySQL General Mailing List
For lis
ace showed the following calls before it died:
msafd!WSPGetSockOpt
ws2_32!WSARecv
wsock32!recv
!
RtlpWaitForCriticalSection
RtlEnableEarlyCriticalSectionEventCreation.
I wonder if any of our fellow mysql users has experienced a similar problem?
Regards,
Gilbert Wu
--
MySQL General Mailing Lis
Try Microsoft's "Inside SQL Server 2000" by Delaney.
-Original Message-
From: Thomas Svenson [mailto:[EMAIL PROTECTED]
Sent: 15 August 2003 01:44
To: MySQL list
Subject: Transactions tutorial
I'm looking for any online resources/tutorials and such about transactions.
Preferable for MySQL
Is mysql still in business? Their web page is down.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
qldump is having problems in dumping out the contents properly. I
would be grateful if someone could shed some light on this. Perhaps things like what
flag to use to delimit the contents correctly before the dump etc.
Many Thanks.
Regards,
Gilbert
--
MySQL General Mailing List
For list archi
Have you considered writing your own DBMS as well?
-Original Message-
From: Patrick [mailto:[EMAIL PROTECTED]
Sent: 29 July 2003 23:03
To: Dan Nelson
Cc: mysqllist
Subject: Re: Transactions
Well said Dan. While foreign keys, cascades and built-in transactions are
convenient, atomicity a
27; to database 'tradingdata' (#1044).
Any help would be much appreciated.
Regards,
Gilbert Wu
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
The connections will still write to one or two tables. Mainly stock prices from a
price server. Hence, not so bother if any prices arrive after the dump starts are not
captured. I would like to know if mysqldump will fail to run if the tables are not
locked? Cheers. Gilbert
-Original
.
Gilbert Wu
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ve
mysql? Or is there a better way? Also do all of mysql's files have mysql
in their name?
I have just enough CL knowledge to get myself into trouble, but not enough
to pull myself out of it.
Thanks,
Gilbert Wilson
-
ux but the
database itself is on the other box wich I can
access thru it's IP address.
I am not sure to be clear enough....
Thanks
Paul Gilbert
-
Before posting, please check:
http://www.mysql.com/manual.php (the
You have written the following:
Hi!
I am running Apache on Linux and MySql database is running
on a windows200 server.
Is there a way to connect to that database using the IP address ?
Thanks for your help!
Paul
-
Before pos
On Wed, 11 Jul 2001, Gerald Clark wrote:
>> On Wed, 11 Jul 2001, Gilbert Healton wrote:
>>
>> The key commands are:
>>
>> grant all privileges on Baseball.* to gilbert identified by "first"
>> with grant option;
cut cut cut
script drops the database then recreates it from
scratch along with running some (failing) operations as the
administration user (gilbert. While I know that mySql user names are
not related to UNIX login names... but I am having login gilbert use
m ySql user gilbert).
The key commands are:
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: 12 June 2001 16:03
To: Craig Gilbert
Subject: Re: query
Your message cannot be posted because it appears to be either spam or
simply off topic to our filter. To bypass the filter you must include
one of the
just run
./configure --prefix=/usr/local/mysql
make
>Fix:
not known
>Submitter-Id: Nigel Gilbert
>Originator:Nigel Gilbert
>Organization:
>MySQL support: None
>Synopsis:le fails on MacOS X
>Severity:
>Priority: <[ low | medium | high ] (one line)>
&g
Java + mysql (windows 2000) :
When i use base64 to encode string , and then insert into database then show error
message
SQLException caught: Error during query: Unexpected Exception:
java.lang.IllegalArgumentException message given: Packet is larger than
max_allowed_packet from server c
rpm so one rotation takes 4 ms and it has a
> 4 MB cache.
A clarification: by "same sequence" I meant written
to the same disk address. If the 4 KB lies on the same
track, then a delay of one disk revolution would be
expected before you could write the next 4 KB to the
"oxide" at
: 0 bytes
Perhaps someone has an idea of which of the above settings
can be tweaked to make the write caching work better in
this case.
Doug Gilbert
--
Test program:
#include
#include
#include
#include
#include
#define NUM_BLKS 200
#d
45 matches
Mail list logo