Backup Script
mysqldump -u root -pPassword mydb | gzip > /backups/mydb-$(date +%Y%m%d).sql.gzRestore
gunzip < backup.sql.gz | mysql -u root -p mydb⚠️ Store backups off-server — if your server is compromised, local backups are gone too.
Automated MySQL Backups on VPS: Full Guide
VDS / VPS Servers
·
25.01.2026