🛡️ Database Backup & Recovery

Create and download secure backups of your website's database. Simple, reliable, one-click backup solution.

← Back to Admin Dashboard

🛡️Secure Admin Session - Backup Access

📊 Database Overview

Loading database statistics...

📊 Backup Statistics & Monitoring

🤖 Automatic Backup Status

Loading automatic backup status...

💾 Storage Usage

Loading storage information...

💾 Create Database Backup

💡 How it works: Click the button below to create a complete backup of your database. The backup will automatically download to your device when ready.

This backup includes all your website data: products, categories, subcategories, images, and tags. The backup file will be in JSON format, making it easy to restore later.

📁 Backup History

No backups found locally.

💡 Note: In serverless deployments (like Vercel), backups are downloaded directly and not stored on the server. Create a backup above to download it immediately to your device.

📖 How to Use This Backup System

💡 Easy Backup Process: Create and download your database backups with one click.

🎯 Step-by-Step Instructions

Test Connection: Click "🔄 Test Database Connection" to verify your database is accessible
Create Backup: Click "🗄️ Create & Download Backup" to generate and download your backup file
Save Securely: The backup will download automatically - save it to a secure location (cloud storage, external drive, etc.)
Regular Schedule: Repeat weekly or before major changes to keep your data safe

⚠️ Important: In serverless environments (like Vercel), backups are downloaded directly to your device. They are not stored on the server, so make sure to save them to a secure location.

📋 Alternative: Local Backup Script

For developers who want to run backups from their local machine, you can use our backup script:

📋 View Local Backup Script Instructions

Step 1: Make sure you have PostgreSQL client tools installed

Step 2: Set your DATABASE_URL environment variable

Step 3: Run the backup script from your project directory:

# Make script executable (first time only)
chmod +x scripts/backup-database.sh

# Run the backup
./scripts/backup-database.sh

Output: Backup files will be saved to the ./backups/ directory

📋 Restoration Instructions

📋 How to Restore from Backup

⚠️ Warning: Restoring will overwrite your current database. Always test on a development database first!

Method 1: Using Admin Panel Backups (JSON files)

For backups created from this admin panel:

# Use our restoration script
node scripts/restore-from-json.js your-backup-file.json

Method 2: Using Local Script Backups (.dump files)

For backups created with the local backup script:

# Restore from a .dump file
pg_restore -d "$DATABASE_URL" -c -v backup_file.dump

💡 Pro tip: Test your restoration process periodically to ensure your backups work correctly.

📚 Backup Best Practices

🔄 Regular Schedule

Create manual backups weekly
Before making major changes
Test restorations monthly
Keep multiple backup copies

🏠 Storage Locations

Cloud storage (Google Drive, Dropbox)
External hard drives
Multiple locations for safety
Version control for code (GitHub)

🔒 Security

Keep backups in secure locations
Use secure connection strings
Limit access to backup files
Regular security reviews

📋 Documentation

Document your backup procedures
Keep restoration instructions handy
Note backup locations and passwords
Update processes as site grows

🚑 Recovery Options

🔄 Vercel Instant Rollback

Quickly revert to a previous deployment if new code causes issues.

Open Vercel Dashboard →

💾 Database Restoration

Restore from manual or automated backups using our restoration tools.

📋 Restoration Instructions

For JSON backups (from admin panel):

node scripts/restore-from-json.js backup-file.json

For local script backups (.dump files):

pg_restore -d "$DATABASE_URL" -c -v backup-file.dump

⚠️ Always test restoration on a development database first!

🗂️ GitHub Recovery

Clone your repository to recover source code and redeploy.

View Repository →