Casey,
in a Terminal window, type
ps -ef | grep -i mysql
and see if there is a mysqld process actually running and not a zombie
(defunct).
See if you can connect on the localhost.
See if the socket exists.
I'd bet that one of those three will find your problem. Please let
us know if this
Hi,
Use this :
ps awux | grep mysqld -i
On 2/4/06, Casey Rhodes [EMAIL PROTECTED] wrote:
Casey,
in a Terminal window, type
ps -ef | grep -i mysql
and see if there is a mysqld process actually running and not a zombie
(defunct).
See if you can connect on the localhost.
See if the
Otherwise, you could try to use the binlog. The filesystem sure would be
easy though...
for mysql 5.0
show table status
--
Pooly
Webzine Rock : http://www.w-fenec.org/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
As my posting before, i still not found a primary key replacement for
auto_increment field.
Since whein inserting on auto_increment value, application will lock
table (LOCK AUTO-INC).
Sometime, i found that many process is waiting for this lock for what? I
don't know since ever thread on my
Hi,
I would like to write an application in C# to let someone to manage
users of a MySQL database. It should be able to create, edit and
delete users. Can someone point me out to how I can do that? I really
want to *write* such an application; I don't want to use an existing
client or something.
I would like to write an application in C# to let someone to manage
users of a MySQL database. It should be able to create, edit and
delete users. Can someone point me out to how I can do that? I really
want to *write* such an application; I don't want to use an existing
client or something.
Hi, I'm new to the list and not sure whether my question belongs here or
not. I'm looking for an open source program, that runs on JSP, to
generate reports on data in MySQL databases. I've found a few myself but
they run on PHP. Any thoughts or advice would be very appreciated.
-Chuck Craig
SELECT MAX(id) FROM history
WHERE account_id = 216 GROUP BY asset_id
...works. Returns, e.g.: 1234, 3456, 5483, 8382.
SELECT history.* FROM history
WHERE history.id IN (1234, 3456, 5483, 8382 )
...works too. But if I try to combine them using a subquery, a la...
SELECT history.* FROM
With a name like Rene Fournier, shouldn't the subject line be Je don't
think so? ;-)
Okay, the first thing we need to know to help you is what version of MySQL
you are using. If I am not mistaken, subqueries aren't supported until
Version 4.1; if you are using 4.0 or earlier, your subquery
René Fournier wrote:
SELECT MAX(id) FROM history
WHERE account_id = 216 GROUP BY asset_id
...works. Returns, e.g.: 1234, 3456, 5483, 8382.
SELECT history.* FROM history
WHERE history.id IN (1234, 3456, 5483, 8382 )
...works too. But if I try to combine them using a subquery, a la...
SELECT
On 4-Feb-06, at 5:36 PM, Michael Stassen wrote:
René Fournier wrote:
SELECT MAX(id) FROM history
WHERE account_id = 216 GROUP BY asset_id
...works. Returns, e.g.: 1234, 3456, 5483, 8382.
SELECT history.* FROM history
WHERE history.id IN (1234, 3456, 5483, 8382 )
...works too. But if I try to
11 matches
Mail list logo
