automatic crontab for automatic mysql/mariadb backup/mysqldump on linux

automatic_crontab.sh

# Access crontab -e
crontab -e

# Create a CRON like this
30 10 * * * ~/autobackup.sh

# Create autobackup file
touch ~/autobackup.sh

# autobackup.sh content
#!/bin/bash
sudo mysqldump wordpress > db_backup/db_$(date +%m-%d-%Y_%H-%M-%S).sql
sudo find db_backup -mtime +10 -type f -delete

# Set file permission
chmod +x ~/autobackup.sh

# Set mysqlddump default user to /etc/mysql/my.cnf
[mysqldump]
user = user
password = your_password