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

[LaLi]

# 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]

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

 

[cPanelLauren]

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!

 

[Jesse Distad]

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

 

[cPanelLauren]

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.