Backup-Data Failing with S50mysql-dump-tables FAILED

Ok, now follow this procedure:

grep password .my.cnf

Copy this password and then launch this commands:

service mysqld stop
mysqld_safe --skip-grant-tables &
mysql
FLUSH PRIVILEGES;
set password for 'root'@'localhost' = PASSWORD('yourcopiedpwd');

And then:

systemctl stop mysqld
systemctl start mysqld

If from service interface mysql remains stopped launch this other commands:

mysqladmin shutdown
systemctl start mysqld

Then I suggest you to create an admin account with all privileges with this mysql command:
GRANT ALL PRIVILEGES ON *.* TO 'admin'@'localhost' IDENTIFIED BY 'adminpassword';
You can use it for application like phpmyadmin.

Try to reboot the server and check if it works properly by log into mysql with mysql command. Process starts automatically only if you did systemctl enable mysqld before.

Then you can check if backup works properly with command
backup-data -b backup-data

Wait for your feedback.
Regards.

1 Like