services disabled including the MySQL DBMS. Is there a way for the other two
MySQL DBMS to continue to replicate to each other if the third is down
without manual attention?
--
Mark Hennessy
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
I just rebuilt mysql 3.23.55 on FreeBSD 5.0, and I am trying to start
mysqld with my databases, and all of a sudden I'm getting this error. I
was wondering if anyone has seen this and might know where I should start
looking?
--
Mark P. Hennessy [EMAIL
]
On Fri, 28 Feb 2003, Mark Hennessy wrote:
Date: Fri, 28 Feb 2003 16:57:11 -0500 (EST)
From: Mark Hennessy [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: mysqld: Can't lock file (errno: 45)
I just rebuilt mysql 3.23.55 on FreeBSD 5.0, and I am trying to start
mysqld with my databases, and all
Check the permissions on the files in /var/lib/mysql, they have to be
readable and writable by the user that mysql runs as (usually mysql) if I
recall correctly.
--
Mark P. Hennessy [EMAIL PROTECTED]
On Wed, 30 Oct 2002, Jason Thiesse wrote:
Date:
But root user is able to perform the write to file w/o issue.
I wonder what the problem could be.
I will upgrade to 3.23.52 but I don't think it will fix the problem.
Is there anything else it could be?
--
Mark P. Hennessy [EMAIL PROTECTED]
On Tue, 1
+-+
| Grants for [EMAIL PROTECTED]
| |
I'm using FreeBSD 4.6 and MySQL 3.23.36
I keep trying to grant file privileges to a user, but no matter what I do,
it seems that the customer keeps getting access denied errors.
They are trying to execute the following:
select * into outfile '/tmp/list.txt' fields terminated by | lines
[EMAIL PROTECTED]
On Sat, 7 Sep 2002, Jeremy Zawodny wrote:
Date: Sat, 7 Sep 2002 11:20:27 -0700
From: Jeremy Zawodny [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Mark Hennessy [EMAIL PROTECTED]
Cc: Jeremy Tinley [EMAIL PROTECTED], [EMAIL PROTECTED]
Subject: Re: Master MySQL server
I have a Master MySQL server which does not listen publicly, and it
distributes a database to my publicly accessible MySQL servers via
rdist/ssh every 15 mins or so by copying the table files. Is there any
flushing that has to be done for the newly rdist'd files to be used by
the public MySQL
Clark wrote:
Date: Fri, 06 Sep 2002 15:15:30 -0500
From: Gerald Clark [EMAIL PROTECTED]
To: Mark Hennessy [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: Master MySQL server rdist db to public MySQL servers
Just shut down all the servers before copying the files.
Check out live
time
there's an update.
--
Mark P. Hennessy [EMAIL PROTECTED]
On Fri, 6 Sep 2002, Jeremy Tinley wrote:
Date: Fri, 6 Sep 2002 15:17:09 -0500
From: Jeremy Tinley [EMAIL PROTECTED]
To: 'Mark Hennessy' [EMAIL PROTECTED]
Subject: RE: Master MySQL server
[EMAIL PROTECTED]
To: 'Mark Hennessy' [EMAIL PROTECTED]
Subject: RE: Master MySQL server rdist db to public MySQL servers
Use replication then. It's the best way of ensuring you have the most
current data.
-J
-Original Message-
From: Mark Hennessy [mailto:[EMAIL PROTECTED]]
Sent
From pg 149 of the New Riders Press book
MySQL by Paul DuBois (ISBN 0-7357-0921-1):
CREATE TABLE new_tbl_name SELECT * FROM tbl_name WHERE 1=0
--
Mark P. Hennessy [EMAIL PROTECTED]
On Mon, 24 Jun 2002, Phil Schwarzmann wrote:
Date: Mon, 24 Jun
13 matches
Mail list logo