Bash script for MySQL database backup
#!/bin/sh
# Backup of MySQL Databases
mysqldump -uUSERNAME -pPASSWORD -h192.168.0.100 TABLENAME > /backups/YOURBKUP-$(date +%Y%m%d).sql
Past Works
#!/bin/sh
# Backup of MySQL Databases
mysqldump -uUSERNAME -pPASSWORD -h192.168.0.100 TABLENAME > /backups/YOURBKUP-$(date +%Y%m%d).sql