Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

[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:
    51
    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.1/en/replication-options-slave.html#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:
    834
    Likes Received:
    29
    Trophy Points:
    178
    Location:
    Virginia Beach, VA
    cPanel Access Level:
    DataCenter Provider
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. cPanelMichael

    cPanelMichael Technical Support Community Manager
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    45,167
    Likes Received:
    1,933
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    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.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice