Alter table only on the master?

2004-11-09 Thread harm 
Hello,

I want to convert a table from innodb to myisam on the _master only_, not
on the slaves. Is there a secret 'do this alter table only on the
master' command, or do I really have to do some 
voodoo-replication-queries-skipping 
on the slaves?

Thanks,
Harmen

-- 
   The Moon is Waning Crescent (10% of Full)

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Alter table only on the master?

2004-11-09 Thread Gary Richardson 
Hey,

As I found out on the list, you want to SET SQL_LOG_BIN=0 in your
session. The user making the changes needs have the SUPER privilege.

http://dev.mysql.com/doc/mysql/en/SET_SQL_LOG_BIN.html

On Tue, 9 Nov 2004 20:35:22 +0100, harm [EMAIL PROTECTED] wrote:
 Hello,
 
 I want to convert a table from innodb to myisam on the _master only_, not
 on the slaves. Is there a secret 'do this alter table only on the
 master' command, or do I really have to do some 
 voodoo-replication-queries-skipping
 on the slaves?
 
 Thanks,
 Harmen
 
 --
The Moon is Waning Crescent (10% of Full)
 
 --
 MySQL General Mailing List
 For list archives: http://lists.mysql.com/mysql
 To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
 


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]