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

LaLi

• July 28, 2018 18:34

# 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

• 

  Jcats

  • July 29, 2018 13:22

  skip-name-resolve wouldn't be used for mysqldump. Go into /etc/my.cnf remove it from under the [mysqldump] section. and add skip_name_resolve
  to the [mysqld] section As far as --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 Command-Line Format --skip-name-resolve System Variable skip_name_resolve
  

  0
• 

  cPanelLauren

  • July 30, 2018 20:10

  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!

  0
• 

  Jesse Distad

  • March 24, 2019 13:19

  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!

  
  @cPanelLauren Is this still the case? I posted a new thread over the weekend but haven't heard back... Are there still issues with cPanel when doing this? If so, what are those issues? Thanks in advance

  0
• 

  cPanelLauren

  • March 25, 2019 17:01

  Hello @Jesse Distad This is indeed still the case. I do apologize for any delay in response to your thread, we are working to get to them in order of being received.

  0

Please sign in to leave a comment.