The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

[Case 99141] MySQL upgrade removes valid entries from my.cnf

Discussion in 'General Discussion' started by WanderingZombie, May 6, 2014.

  1. WanderingZombie

    Joined:
    Oct 23, 2007
    Messages:
    7
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Horsham, England
    cPanel Access Level:
    Root Administrator
    "To specify more than one table to ignore, use this option multiple times, once for each table."
    https://dev.mysql.com/doc/refman/5....tml#option_mysqld_replicate-wild-ignore-table

    The MySQL upgrade script removes all but one of the following from my.cnf, which causes replication issues during upgrades.

    # skip all the WHM/cPanel tables that should be server specific
    replicate-wild-ignore-table="cphulkd.%"
    replicate-wild-ignore-table="eximstats.%"
    replicate-wild-ignore-table="horde.%"
    replicate-wild-ignore-table="leechprotect.%"
    replicate-wild-ignore-table="logaholicDB.%"
    replicate-wild-ignore-table="modsec.%"
     
  2. vanessa

    vanessa Well-Known Member
    PartnerNOC

    Joined:
    Sep 26, 2006
    Messages:
    817
    Likes Received:
    22
    Trophy Points:
    18
    Location:
    Virginia Beach, VA
    cPanel Access Level:
    DataCenter Provider
  3. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,762
    Likes Received:
    662
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    Hello :)

    Yes, internal case number 99141 is open to address this issue. Feel free to monitor our change log for this case number to determine when a resolution has been implemented. The workaround for servers that have already upgraded is to manually add those lines back to your /etc/my.cnf file.

    Thank you.
     
Loading...

Share This Page