Anti-SPAM: mysql, query Gurus
I'm new to replication. Set it up this weekend and has worked flawlessly for several days. Then I used the command: TRUNCATE TABLE tbl; That worked in master, but was not replicated in slave. No mention of this in manual. Using version 3.23.49 on master and slave. Master is Solaris and slave is NT. The truncate command is much, much faster than DELETE FROM tbl; I can see why some clever person invented it. BTW, no mention of any problems in ref. manual or books. Any thoughts? David --- David E Lopez Org: SPS->ASP->SOC ATIC->CSAM Phone: 480-413-6251 email: [EMAIL PROTECTED] --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
