Announcement

Collapse
No announcement yet.
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • mysql replication

    working on setting up mysql replication so we can run reporting off a second system without impacting the server. after following the docs we're getting an error on the slave system that is keeping replication from working.

    Slave: Error 'Cannot add or update a child row: a foreign key constraint fails...'

    does anybody who has successfully set up replication have any insight on this?

    thanks in advance!

    matt

  • #2
    I have followed these directions using the dump method to transfer the data. I believe I had to have MySQL dump the master log position with the dump and pull it out of the dump and enter it by hand, however.

    How To Set Up Database Replication In MySQL | HowtoForge - Linux Howtos and Tutorials

    Comment

    Working...
    X