Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2013

    Unanswered: mysql replication not work when db name appended

    Hi guys
    I updated db through phpmyadmin but it does not replicate to slave. But when i use command line let's say
    use dabname
    update query
    it works fine
    So i think replication not works when db name appends to table name
    any idea?

  2. #2
    Join Date
    Sep 2009
    San Sebastian, Spain
    Just to clarify what you are saying here. When you use phpmyadmin to update a row this does not get replicated. However, if you run the same update statement using mysql command line prompt then this works?

    If this is the case, have a look at autocommit. It is likely that the update you issue in phpmyadmin is not committed to the database and as a result does not get replicated. To verify this, run your update statement and the issue a "COMMIT;" and go to make sure it is written to the database. Then see if this gets replicated.
    Ronan Cashell
    Certified Oracle DBA/Certified MySQL Expert (DBA & Cluster DBA)
    Follow me on Twitter

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts