automysqlbackup from a remote server

General support questions
Post Reply
didds2
Posts: 4
Joined: 2017/04/27 11:45:49

automysqlbackup from a remote server

Post by didds2 » 2021/08/04 12:58:05

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 doesnt run on B of course - but as Im requesting a dump from a remote server it woudnt need (?) a local mysqld service running

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

cheers

didds

Post Reply