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

LaLi

Registered
May 19, 2018
3
1
3
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
 

Jcats

Well-Known Member
PartnerNOC
May 25, 2011
806
156
168
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
 

cPanelLauren

Product Owner
Staff member
Nov 14, 2017
13,296
1,262
313
Houston
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

Member
Mar 23, 2019
6
0
1
MN, USA
cPanel Access Level
Root Administrator
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