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!

mysqldump: [ERROR] unknown option '--skip-name-resolve'

Discussion in 'Database Discussion' started by LaLi, Jul 28, 2018.

  1. LaLi

    LaLi Registered

    Joined:
    May 19, 2018
    Messages:
    3
    Likes Received:
    1
    Trophy Points:
    3
    Location:
    Skopje
    cPanel Access Level:
    Root Administrator
    # Skip reverse DNS lookup of clients skip-name-resolve=1 #mysqltunner.pl


    i added this line into my.cnf and i am having problem with mysqldump

    mysqldump: [ERROR] unknown option '--skip-name-resolve'

    mysqldump: [ERROR] unknown variable 'skip-name-resolve=1'


    i tryed both and same error
     
  2. Jcats

    Jcats Well-Known Member

    Joined:
    May 25, 2011
    Messages:
    718
    Likes Received:
    122
    Trophy Points:
    168
    Location:
    New Jersey
    cPanel Access Level:
    DataCenter Provider
    skip-name-resolve wouldn't be used for mysqldump.

    Go into /etc/my.cnf

    remove it from under the [mysqldump] section.

    and add

    Code:
    skip_name_resolve
    to the [mysqld] section

    As far as
    Code:
    --skip-name-resolve
    this would be used via command line as an option, it doesn't go into the conf in that format.

    MySQL :: MySQL 8.0 Reference Manual :: 5.1.6 Server Command Options

    Code:
    Command-Line Format    --skip-name-resolve
    System Variable    skip_name_resolve
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. cPanelLauren

    cPanelLauren Forums Analyst
    Staff Member

    Joined:
    Nov 14, 2017
    Messages:
    2,212
    Likes Received:
    159
    Trophy Points:
    143
    Location:
    Houston
    cPanel Access Level:
    DataCenter Provider
    HI @LaLi

    @Jcats is correct on this. I would go one step further though and just remove it from the my.cnf entirely the benefits to skipping DNS resolution are minor and can cause issues with cPanel.

    Thanks!
     
    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