[ale] MySQL sync

[Martha Armour]

Thank you, Chuck.  I learned the hard way :-)

When replication breaks, the following MySQL
page has been a great help.  You can skip offending
commands and often get replication back up and
running by using the SQL_SLAVE_SKIP_COUNTER setting.

http://www.mysql.com/doc/en/Replication_SQL.html


- Martha

--- Chuck Huber <chuck at cehuber.org> wrote:
> On Fri, Feb 21, 2003 at 06:57:04AM -0800, Martha
> Armour wrote:
> > One note about inserting records into the slave is
> > if you have an auto-increment field and create a
> > record
> > with let's say "302", and the master then sends
> over
> > its newly created "302", replication will break.
> 
> Excellent point that I failed to mention.  Now that
> you bring it
> up, I vaguely recall reading something about that. 
> Perhaps it
> was mentioned in the MySQL docs.
> 
> Enjoy,
>     - Chuck
> 


__________________________________________________
Do you Yahoo!?
Yahoo! Tax Center - forms, calculators, tips, more
http://taxes.yahoo.com/
_______________________________________________
Ale mailing list
Ale at ale.org
http://www.ale.org/mailman/listinfo/ale