MailWizz Backup and Disaster Recovery — What to Back Up and How to Restore

A complete MailWizz backup strategy covers three components: the database (subscriber data, campaign history, configuration), the application files (custom templates, extensions, configuration files), and the related infrastructure configuration (DNS records, SSL certificates, SMTP relay settings).

Database Backup

#!/bin/bash
# Daily MailWizz database backup
DATE=$(date +%Y%m%d)
BACKUP_DIR=/backup/mailwizz

mkdir -p $BACKUP_DIR

mysqldump -u mailwizz -p mailwizz \
  --single-transaction \
  --quick \
  --lock-tables=false \
  | gzip > $BACKUP_DIR/mailwizz-db-$DATE.sql.gz

# Verify backup completed
echo "Backup size: $(du -sh $BACKUP_DIR/mailwizz-db-$DATE.sql.gz)"

# Remove backups older than 30 days
find $BACKUP_DIR -name '*.sql.gz' -mtime +30 -delete

Application Files Backup

#!/bin/bash
# Back up custom MailWizz files (config, templates, extensions)
tar czf /backup/mailwizz/mwz-custom-$(date +%Y%m%d).tar.gz \
  /var/www/mailwizz/apps/common/config/main.php \
  /var/www/mailwizz/apps/customer/config/main.php \
  /var/www/mailwizz/apps/backend/config/main.php \
  /var/www/mailwizz/apps/common/extensions/ \
  /var/www/mailwizz/apps/frontend/themes/

Restoration to a New Server

• Install PHP, MySQL, and web server with same versions as original
• Create database and user with same credentials as original
• Restore database: gunzip < mailwizz-db-DATE.sql.gz | mysql -u mailwizz -p mailwizz
• Extract MailWizz files to web root
• Restore custom config files from backup
• Update DNS to point domain to new server IP
• Reconfigure cron job configuration under the correct user on new server

What Cannot Be Backed Up

• Sending IP reputation (tied to IP addresses, not server)
• ISP relationship history (enrollment in Microsoft SNDS, JMRP, FBL programs)
• PowerMTA license (server-bound — requires new license for new server IP)

Troubleshooting Common Issues

Production MailWizz deployments encounter predictable issues at predictable stages. Understanding the diagnostic workflow for the most common problems in this configuration area saves time and prevents the escalating complexity that comes from applying fixes to a misdiagnosed problem. The diagnostic approach is always the same: identify the symptom precisely (not just "it's not working"), isolate the layer where the failure occurs (MailWizz application, delivery server connection, DNS, ISP rejection), and fix at the correct layer.

Systematic Diagnosis Approach

Check MailWizz logs first (available in Backend → Misc → Application Logs), then check the delivery server SMTP logs, then check the PowerMTA accounting log. Most issues surface in one of these three places. A problem that does not appear in any of these logs is almost always a configuration issue — the system is not attempting what you expect it to attempt.

# MailWizz diagnostic log locations:
# Application logs: Backend → Misc → Application Logs
# Delivery logs: Backend → Campaigns → [Campaign] → Delivery Logs
# Bounce logs: Backend → Bounce Servers → [Server] → Logs

# Server-side logs:
# MailWizz application: /path/to/mailwizz/apps/common/runtime/application.log
# PowerMTA delivery: /var/log/pmta/pmta.log
# PowerMTA accounting: /var/log/pmta/accounting.csv

Performance Optimization for Production Scale

MailWizz performance at scale depends on three infrastructure layers: the web application server (PHP/nginx or Apache), the database (MySQL — query optimization is critical at high subscriber counts), and the delivery infrastructure (PowerMTA connection pool sizing). Performance problems in any of these layers manifest as slow campaign sends, delayed processing, or timeouts that appear unrelated to the specific configuration area being managed.

The most common performance constraint in production MailWizz environments is MySQL query efficiency. As subscriber lists grow beyond 500,000 records, unoptimized database queries for segmentation, bounce processing configuration, and campaign statistics become significant bottlenecks. Ensure that subscriber tables have appropriate indexes on email, status, date_added, and any custom field columns used for segmentation.

# MySQL optimization for large MailWizz installations
# Check slow query log:
SHOW VARIABLES LIKE 'slow_query_log%';
SET GLOBAL slow_query_log = 'ON';
SET GLOBAL long_query_time = 1;  # Log queries over 1 second

# Key indexes to verify exist:
SHOW INDEX FROM mailwizz_lists_subscribers;
# Should have indexes on: email, status, date_added, list_id

# Add missing index if needed:
ALTER TABLE mailwizz_lists_subscribers 
  ADD INDEX idx_email_status (email, status);
  
# Campaign sends table — index on campaign_id + subscriber_id:
ALTER TABLE mailwizz_campaigns_tracking_opens
  ADD INDEX idx_campaign_sub (campaign_id, subscriber_id);

Security Considerations

MailWizz installations handling production sending volumes are valuable targets. Key security practices: use HTTPS for all MailWizz access (including tracking and unsubscribe links), restrict Backend access to authorized IP ranges via web server configuration, rotate API keys periodically and revoke unused keys, maintain regular database backups (automated, offsite), and ensure PHP and MailWizz are kept current with security patches.

The tracking domain (used for open and click tracking) requires special attention: it must have a valid SSL certificate (Let's Encrypt is acceptable), and its DNS records must point exclusively to your MailWizz server. A compromised tracking domain can redirect recipients to malicious sites or reveal subscriber click data to third parties.

Campaign Analytics Integration

Track this MailWizz configuration area through two complementary metric layers: MailWizz campaign statistics (open rate, click rate, bounce rate, unsubscribe rate) and PowerMTA accounting log data (ISP-specific deferral rate, bounce classification, queue depth). Gaps between the two layers reveal delivery problems invisible to MailWizz statistics alone — high MailWizz "sent" counts with elevated PowerMTA deferral rates indicate a queue buildup that campaign dashboards don't surface.

Review campaign metrics against your own historical baselines rather than industry benchmarks. Your list composition, acquisition source, and engagement history define what normal looks like for your environment. Use rolling 7-day and 30-day averages to distinguish trend changes from campaign-specific variance.

Implementation Checklist

Before deploying this configuration to production MailWizz, verify: delivery server connection test passes in Backend → Servers → Delivery Servers, cron jobs are running on the correct schedule, bounce server mailbox is accessible and IMAP credentials are valid, tracking domain has valid SSL and loads within 500ms, and PHP memory limit is set to at least 256MB.

After deploying, send a test campaign to a controlled list of seed addresses across Gmail, Outlook, and Yahoo. Verify Authentication-Results headers show dkim=pass and spf=pass in the received messages. Check that open and click tracking are registering correctly in MailWizz statistics. Confirm bounce processing is updating subscriber status within 15 minutes of a test bounce event.

For managed MailWizz environments operated by Cloud Server for Email, these verification steps are performed automatically after any configuration change. The managed service includes continuous monitoring of delivery server health, cron job execution, and tracking domain availability. Contact infrastructure@cloudserverforemail.com for information about managed MailWizz hosting.

Production Backup Strategy for MailWizz

The database is your most critical backup target — it contains all subscriber data, campaign history, and configuration. Schedule incremental database backups every 4 hours for active sending environments. The MailWizz application files change infrequently; daily backups are sufficient. DKIM private keys must be in a separate, encrypted backup — these cannot be regenerated if lost.

Recovery Testing

A backup procedure that has never been tested is not a backup procedure. Quarterly restoration tests on a staging environment confirm that backups are complete and restorable. The test should verify: database restoration, cron job functionality, delivery server connectivity, and tracking domain SSL.