Database & Backup (MySQL, Import/Export, JetBackup, Restore)

cPanel → MySQL Databases:

1. Section Create New Database → isi nama (misal app1) → Create. Nama final akan jadi cpaneluser_app1.
2. Section Add New User → isi username & password → Create User.
3. Section Add User to Database → pilih user & DB → grant ALL PRIVILEGES.

cPanel → phpMyAdmin → klik DB tujuan → tab Import → pilih file .sql atau .sql.gz → Go.

Untuk file > 50 MB pakai SSH:

mysql -u user -p dbname < dump.sql

Atau via cPanel File Manager → upload .sql ke folder home → import via terminal cPanel.

phpMyAdmin → pilih DB → tab Export → Quick → SQL → Go. File akan di-download.

Via SSH (lebih cepat untuk DB besar):

mysqldump -u user -p dbname | gzip > dump.sql.gz

cPanel → JetBackup 5. Saung Hosting otomatis backup:

• Daily — retain 7 hari
• Weekly — retain 4 minggu (paket Bisnis ke atas)

Restore granular: pilih full account, hanya files, hanya DB, hanya email akun, atau bahkan file individual.

1. JetBackup 5 → menu sesuai jenis restore (Files / Databases / Email Accounts / Full Account)
2. Pilih tanggal snapshot
3. Pilih item → klik Restore Selected
4. Tunggu notifikasi selesai (5–30 menit tergantung ukuran)

cPanel → Backup:

• Full Backup → download .tar.gz lengkap (untuk migrasi/arsip)
• Partial Backup → home directory / databases / email forwarders / filters

Best practice 3-2-1: 3 copy, 2 media berbeda, 1 offsite. Pakai plugin UpdraftPlus (WordPress) untuk backup ke Google Drive / Dropbox / S3.

cPanel → Cron Jobs:

# Backup DB harian jam 2 pagi
0 2 * * * mysqldump -u USER -pPASS DBNAME | gzip > ~/backups/db-$(date +\%F).sql.gz
# Hapus backup > 14 hari
0 3 * * * find ~/backups -name "*.gz" -mtime +14 -delete