You could daisy chain the servers together,
this would be ineffiecient and not robust, but it would work.
shop1 master to shop2
|
customers1
|
V
shop2 master to shop3
|
customers1
customers2
|
V
shop3 master to office
|
customers1
customers2
As I understand it...
The SQL must be executed in sequence, otherwise you'll end up with
incosistency between master and slave.
an example: If thread 1 is inserting data, and thread 2 is running
updates based on the inserted data then you could end up with different
results on the slave than on
If you want an enum to have the possible values of NULL or 1
alter table `Associate` modify `Active` enum('1');
from the mysql manual
http://dev.mysql.com/doc/mysql/en/ENUM.html
If an ENUM column is declared to allow NULL, the NULL value is a legal
value for the column, and the default value is
when asking a question, it always helpful to post you code/queries so we
can see what is happening.
but tbh, this sounds like it's a php code problem.
you have established that both queries work, on there own
I'm don't know anything about php, but it sounds like you are not
executing the first
I also use tinyint(1) unsigned
and I provide a mysqlBooleanFormat() function in my application that will
return 1 or 0 for storing the value in the DB
-Original Message-
From: Michael J. Pawlowsky [mailto:[EMAIL PROTECTED]
Sent: 04 November 2004 20:44
To: [EMAIL PROTECTED]
Subject: Re:
Hi,
We log all sessions on our webserver to a table, and then periodically run a
batch process to analyze the visitors ip addresses to determine the
city/region/country of origin.
we use MySQL 4.1.1-alpha-standard-log on Redhat AS, installed from the mysql
RPM.
The query below takes about 1
not sure you can do this just with mysql, I think your gunna need to select
the html from the db then send it to something like perl or php and use a
regex parser on it.
-Original Message-
From: Bob Ramsey [mailto:[EMAIL PROTECTED]
Sent: 03 October 2004 12:45
To: [EMAIL PROTECTED]
slightly off topic, but you can sort of build apache with mysql support.
mod_auth_mysql allows you to authenticate users and groups against a DB
http://sourceforge.net/projects/modauthmysql/
chris
-Original Message-
From: andy thomas [mailto:[EMAIL PROTECTED]
Sent: 15 September 2004
Not sure whether this is applicable to your version of mysql, or to PHP.
I had the same problem using Macromedia's Coldfusion, and adding this:
useUnicode=truecharacterEncoding=UTF-8
to the db connection string solved the problem
chris
-Original Message-
From: MySQL [mailto:[EMAIL
If you base64 encode your binary, it will be valid inside the xml. As far
as I know this is the accepted way to transfer binary objects using xml.
chris
-Original Message-
From: Karam Chand [mailto:[EMAIL PROTECTED]
Sent: 13 August 2004 05:09
To: Keith Ivey; [EMAIL PROTECTED]
Subject:
Hi,
I have been running 4.1.3 on redhat9,
installed from the mysql rpm package. It has been running great until the
server crashed for an unknown reason 2 days ago.
now when ever i try to start mysql i get the
following error in log
040812 09:52:34 mysqld
started040812 9:52:34 Warning:
was causing the problem :/
chris
-Original Message-
From: Egor Egorov [mailto:[EMAIL PROTECTED]
Sent: 12 August 2004 10:26
To: [EMAIL PROTECTED]
Subject: Re: MySQL won't start... was runnnig fine
Chris Blackwell [EMAIL PROTECTED] wrote:
now when ever i try to start mysql i get
in the first place? That's not the sort of
thing you want just randomly happening, I'd imagine. Although it might make
life a bit more interesting...
Cheers.
--V
Chris Blackwell wrote:
I have resolved this issue now, it was actually the permission on
/tmp that had become corrupted as a result
13 matches
Mail list logo