Install automysqlbackup by entering the following commands in the terminal:
sudo apt update sudo apt install automysqlbackup
Description:
daily, weekly and monthly backup for your MySQL database
automysqlbackup creates backup every day, week and month for all of your MySQL database, to a configured folder. There's nothing to do but to install this package, and you'll rest assured that you have a way to go back in the history of your database. . This package may be unsafe if untrusted users may create databases and if no check on the syntax of the name of them is performed.
Homepage: http://sourceforge.net/projects/automysqlbackup/
Version: 2.6+debian.4-1
Section: universe/admin