. ;)
Rob
> -Original Message-
> From: Rob Gormley [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, 28 February 2006 12:36 PM
> To: mysql@lists.mysql.com
> Subject: Elementary replication
>
> Hi,
>
> Not having a lot of luck with replication.
>
> Have 2 4.1x bo
Hi,
Not having a lot of luck with replication.
Have 2 4.1x boxes
Slave is configured, via my.cnf, to only replicate three tables:
replicate-do-table = db.table1
replicate-do-table = db.table2
replicate-do-table = db.table3
SHOW SLAVE STATUS; (sanitised) output is as follows:
mysql> show slave
Short of running two MySQL instances on the same server... What I would
like to do is have a table which exists on disk in InnoDB format, and a
Memory table which clients make requests for.
Lest that sound more convuluted than it really is, the situation is
thus:
Limited (financial) resources cli
Windows 2003 - try 'net stop mysql' from a commandline.
Rob
> -Original Message-
> From: sol beach [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, 31 January 2006 12:47 PM
> To: [EMAIL PROTECTED]
> Cc: mysql@lists.mysql.com
> Subject: Re: How to login to MYSQL as "root" without knowing
> th
Am hoping someone can give me the safest advice here.
Using 4.1 and InnoDB, someone in an attempt to be helpful set up a lot
of foreign key constraints. However...
ON DELETE CASCADE
When we needed RESTRICT.
Net effect? Some editing today lead to cries of "Where has half the data
gone?"
We have