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
customer
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
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 th
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 quer
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 seco
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]
Subject
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 16
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=true&characterEncoding=UTF-8
to the db connection string solved the problem
chris
-Original Message-
From: MySQL [mailto:[EMAIL PROT
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:
x27;.
Any idea why the server crashed 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 permi
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
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 Warn
13 matches
Mail list logo
