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
automysqlbackup from a remote server
General support questions
Return to “CentOS 7 - General Support”
Jump to
- CentOS General Purpose
- ↳ CentOS - FAQ & Readme First
- ↳ Announcements
- ↳ CentOS Social
- ↳ User Comments
- ↳ Website Problems
- CentOS 8 / 8-Stream / 9-Stream
- ↳ 8 /8-Stream / 9-Stream - General Support
- ↳ 8 /8-Stream / 9-Stream - Hardware Support
- ↳ 8 /8-Stream / 9-Stream - Networking Support
- ↳ 8 /8-Stream / 9-Stream - Security Support
- CentOS 7
- ↳ CentOS 7 - General Support
- ↳ CentOS 7 - Software Support
- ↳ CentOS 7 - Hardware Support
- ↳ CentOS 7 - Networking Support
- ↳ CentOS 7 - Security Support
- CentOS Legacy Versions
- ↳ CentOS 5
- ↳ CentOS 5 - General Support
- ↳ CentOS 5 - Software Support
- ↳ CentOS 5 - Hardware Support
- ↳ CentOS 5 - Networking Support
- ↳ CentOS 5 - Server Support
- ↳ CentOS 5 - Security Support
- ↳ CentOS 5 - Oracle Installation and Support
- ↳ CentOS 5 - Miscellaneous Questions
- ↳ CentOS 6
- ↳ CentOS 6 - General Support
- ↳ CentOS 6 - Software Support
- ↳ CentOS 6 - Hardware Support
- ↳ CentOS 6 - Networking Support
- ↳ CentOS 6 - Security Support