[Automysqlbackup-users] automysqlbackup from a remote server

[Ian D. <ian...@d4...>]

I am clearly missing something ...



mysql db host "A" - centos 7 - runs mysqld

server "B" - centos 7 - does not run mysqld



I wish to run automysqlbackup on server B to extract mysql dumps from server A.



I have my automysqlbackup.conf on B containing the line

CONFIG_mysql_dump_host='A"

and with correct grants set, server name resolves etc etc etc.



I can run mysqldump on B to dump from A (using -hA) no problems.



But when I try and run automysqlbackup on B the log shows



Parsed config file "/etc/automysqlbackup/automysqlbackup.conf"



# Checking for permissions to write to folders:

base folder /opt/mysql/backup ... exists ... ok.

backup folder /opt/mysql/backup/automysqlbackup ... exists ... writable? yes. Proceeding.

checking directory "/opt/mysql/backup/automysqlbackup/daily" ... exists.

checking directory "/opt/mysql/backup/automysqlbackup/weekly" ... exists.

checking directory "/opt/mysql/backup/automysqlbackup/monthly" ... exists.

checking directory "/opt/mysql/backup/automysqlbackup/latest" ... exists.

checking directory "/opt/mysql/backup/automysqlbackup/tmp" ... exists.



# Testing for installed programs

mysql ... found.

mysqldump ... found.

gzip ... found.



# Parsing databases ... Note: Parsed config file /etc/automysqlbackup/automysqlbackup.conf.

Error: The mysql server is empty, i.e. no databases found. Check if something is wrong. Exiting.



###### WARNING ######

Errors reported during AutoMySQLBackup execution.. Backup failed

Error log below..

mysql: [Warning] Using a password on the command line interface can be insecure.

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)



mysqld doesn't run on B of course - but as I'm requesting a dump from a remote server it wouldn't need (?) a local mysqld service running



Or have I (likely!) totally misunderstood the usage of "CONFIG_mysql_dump_host='A"". can this even be done eg run automysqlbackup on B to dump schemas residing on A onto B'?



cheers



didds



Disclaimer: This message is intended for the addressee only. It may contain information of a confidential or legally privileged nature. If you have received this message in error please notify the sender and destroy the message immediately. All attachments have been scanned for viruses. However D4t4 Solutions Plc cannot accept liability for any loss or damage you may incur as a result of virus infection.