---
Lenin Lakshminarayanan wants to stay in better touch using some of
Google's coolest new
products.
If you already have Gmail or Google Talk, visit:
http://mail.google.com/mail/b-d0236098dc-db751a3970-a39b8136ed758afc
You'll ne
Hi,
I just installed MySQL in my Windows 2003 server and I ran the configuration
wizard. All seems to work correctly up to the point where it tries to start
the service (almost at the end of the configuration) for which it fails and
spits out an error message:
"Error No. 2003
Can't connect to M
On Fri, Apr 4, 2008 at 6:30 AM, Shanmugam, Dhandapani <
[EMAIL PROTECTED]> wrote:
Hi,
Hi,
>
> Any idea wat replicate-rewrite-db does with example..
>
>
>
>
It takes statements for one database, and rewrites them into another.
An example of the syntax would be this line in the my.cnf file of your
Hello guys
if i have for example
a simple table call person
with 'id' and 'name' how columns
i can do a backup and get some file (A.sql)
with all the inserts statements
here, all fine
but
how i can do this?
for each insert statement generated in A.sql
create a new B.sql, with update stateme
It appears that since updating from mysql 5.0.44 to 5.0.54 I have also
lost my DEFAULT "" option on all my varchar columns.
For colums which are also NOT NULL this is causing a bunch of problems
in my existing app (trying to insert NULLS)
Anyone can explain what happened and why this has chan
On Thu, 3 Apr 2008, Hiep Nguyen wrote:
hi all, i have a question on insert ... select statement.
tbl_1(fld1,fld2,fld3, )
fld1 int primary key auto_increment not null
tbl_2(fld_a,fld_b,fld_c,...)
how do i construct my select statement so that fld1 is auto increment?
insert into tbl_1(fld
Hello,
Excuse my ignorance please but I must not understand something about
this post that I sent two weeks ago. It received NO responses and that
usually means that I don't understand something about the content of
it. Can anyone enlighten me on why? I thought it was a straight
forward question?
Hi,
Any idea wat replicate-rewrite-db does with example..
thank u very much
On 4/4/08, Krishna Chandra Prajapati <[EMAIL PROTECTED]> wrote:
>
> Master-->Slave1/Master>Slave2 (Chain 1
> to 1)
> Slave1 should have --log_slave_updates
>
>
> Master->Slave1/Slave2/Slave3.
> (Parallel 1 to
Master-->Slave1/Master>Slave2 (Chain 1
to 1)
Slave1 should have --log_slave_updates
Master->Slave1/Slave2/Slave3.
(Parallel 1 to many)
--log_slave_updates is not required
If all the slaves are in a single chain model then --
so, we should not have --log-slave-update on slaves on setup with one master
and multiple slaves...right.
regards
anandkl
On 4/4/08, Krishna Chandra Prajapati <[EMAIL PROTECTED]> wrote:
>
> In case of master is down. Slave 1 has to be made as master and
> --log_slave_updates has to be removed. S
In case of master is down. Slave 1 has to be made as master and
--log_slave_updates has to be removed. Slave2 will act as slave. There will
be no "duplicate key"
On Thu, Apr 3, 2008 at 1:02 PM, Ananda Kumar <[EMAIL PROTECTED]> wrote:
> But, it also says, that if slave1 is made master and if log-s
12 matches
Mail list logo
