We have two servers namely serverA and serverB. I need to take mysql database backup of serverA staying at serverB. The tool I need to use is "AutoMySQLBackup".
Extracted the tar and changed the config file in /etc/automysqlbackup/automysqlbackup.conf as per my need.
As I run automysqlbackup, I get the backups on daily basis though there are warnings:
WARNING
Errors reported during AutoMySQLBackup execution.. Backup failed
Error log below..
mysql: [Warning] Using a password on the command line interface can be insecure.
mysqldump: [Warning] Using a password on the command line interface can be insecure.
mysqlshow: [Warning] Using a password on the command line interface can be insecure.
mysqldump: [Warning] Using a password on the command line interface can be insecure.
mysqldump: [Warning] Using a password on the command line interface can be insecure.
mysqldump: [Warning] Using a password on the command line interface can be insecure.
mysqldump: [Warning] Using a password on the command line interface can be insecure.
mysqldump: Got error: 1142: SELECT, LOCK TABLES command denied to user 'root'@'localhost' for table 'accounts' when using LOCK TABLES
mysqldump: [Warning] Using a password on the command line interface can be insecure.
Despite the warings, i am able to take the bakup of local machine. No worries with that.
But, I need to take the backup of remote server and don't find the way to do that using this tool. I tried using :
ssh serverA@ip-address | automysqlbackup
but nothing is happening.
i need to check this tool in production and i have asked it in dba.stackexchange too. Expecting prompt response. Thank you in advance.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
We have two servers namely serverA and serverB. I need to take mysql database backup of serverA staying at serverB. The tool I need to use is "AutoMySQLBackup".
I got the link for downloading it:
https://sourceforge.net/projects/automysqlbackup/
Extracted the tar and changed the config file in /etc/automysqlbackup/automysqlbackup.conf as per my need.
As I run automysqlbackup, I get the backups on daily basis though there are warnings:
WARNING
Errors reported during AutoMySQLBackup execution.. Backup failed
Error log below..
mysql: [Warning] Using a password on the command line interface can be insecure.
mysqldump: [Warning] Using a password on the command line interface can be insecure.
mysqlshow: [Warning] Using a password on the command line interface can be insecure.
mysqldump: [Warning] Using a password on the command line interface can be insecure.
mysqldump: [Warning] Using a password on the command line interface can be insecure.
mysqldump: [Warning] Using a password on the command line interface can be insecure.
mysqldump: [Warning] Using a password on the command line interface can be insecure.
mysqldump: Got error: 1142: SELECT, LOCK TABLES command denied to user 'root'@'localhost' for table 'accounts' when using LOCK TABLES
mysqldump: [Warning] Using a password on the command line interface can be insecure.
Despite the warings, i am able to take the bakup of local machine. No worries with that.
But, I need to take the backup of remote server and don't find the way to do that using this tool. I tried using :
ssh serverA@ip-address | automysqlbackup
but nothing is happening.
i need to check this tool in production and i have asked it in dba.stackexchange too. Expecting prompt response. Thank you in advance.