search

sixhop / AutoMySQLBackup

A fork and further development of AutoMySQLBackup from sourceforge. http://sourceforge.net/projects/automysqlbackup/
GNU General Public License v2.0
341 stars 103 forks source link

WARNING: Forcing protocol to TCP due to option specification. Please explicitly state intended protocol. #56

Open rwyarbrough opened 3 years ago

rwyarbrough commented 3 years ago

I just started getting this warning message since upgrading slackware current. I ran bash -x and bash -v and can't find why this is triggered.

filipnet commented 3 years ago

The warning message does not appear if you use the value "127.0.0.1" instead of "localhost" inside the configuration file:

# Host name (or IP address) of MySQL server e.g localhost
CONFIG_mysql_dump_host='127.0.0.1'

Read here: https://mariadb.com/kb/en/mysql-command-line-client/

Chapter: Linux/Unix If hostname is not specified or hostname is localhost, then Unix sockets are used. In other cases (hostname is given and it's not localhost) then a TCP/IP connection through the port option is used. Note that localhost is a special value. Using 127.0.0.1 is not the same thing. The latter will connect to the mysqld server through TCP/IP.

romanstech commented 2 years ago

The warning message does not appear if you use the value "127.0.0.1" instead of "localhost" inside the configuration file:

# Host name (or IP address) of MySQL server e.g localhost
CONFIG_mysql_dump_host='127.0.0.1'

Read here: https://mariadb.com/kb/en/mysql-command-line-client/

Chapter: Linux/Unix If hostname is not specified or hostname is localhost, then Unix sockets are used. In other cases (hostname is given and it's not localhost) then a TCP/IP connection through the port option is used. Note that localhost is a special value. Using 127.0.0.1 is not the same thing. The latter will connect to the mysqld server through TCP/IP.

Thanks. Helped.