# BACKUP_RESTORE

Backup DB: `mysqldump -u USER -p bandungcraft | gzip > db-$(date +%F).sql.gz` nightly; simpan 7 hari, retensi 30 hari. Backup file: `storage/app/private` mingguan terpisah.

Restore: `gunzip -c db-YYYYMMDD.sql.gz | mysql -u USER -p bandungcraft`, lalu `php artisan cache:clear`. Push snapshot manual sebelum migrate production.

Testing restore: restore ke DB staging, hit endpoint `/api/settings`, cek order count, lalu hapus staging. Tidak perlu root.