mysqldump: Got error: 1042: Can’t get hostname for your address when trying to connect


Warning: Undefined array key "socialize_RedditWidget" in /home/phpacd/websites/shkodenko.com/wp-content/plugins/socialize/frontend/socialize-services.php on line 166

If you getting error: 1042: Can’t get hostname for your address when trying to connect when trying to dump remote database using mysqldump it can be fixed by adding configuration directive:

skip-name-resolve

into section [mysqld]

Also, MySQL service should be restarted using command:

# /etc/init.d/mysqld restart
Stopping mysqld: [ OK ]
Starting mysqld: [ OK ]