MySQL databases need daily backups.
mysqldump
mysqldump -u user -p mydb > backup.sql
Standard CLI tool. Automated via cron.
phpMyAdmin
Export tab via GUI. Saves as .sql or .gz.
Plesk Backup
Plesk runs weekly backups automatically, can push to Google Drive.
Replication
For heavy sites — real-time copy on a second server.
Test restores
Periodically restore your backup — verify it actually works.