Paymenter Automated Database Backup

🔐 Automated Database Backup Extension for Paymenter

Protect your Paymenter database with a powerful, secure, and extremely easy-to-use backup extension.

This extension automatically creates backups of your Paymenter database and stores them in .sql.gz format to save storage space.

✅ Restore backups directly from the admin panel

Administrators can restore any previously created backup directly from the backup logs page without needing manual database commands.

This makes disaster recovery faster and easier when you need to restore your Paymenter database.
You can store backups on:

🖥️ Local VPS
🌍 Remote VPS
🔄 Both Local and Remote VPS at the same time

Everything can be configured directly from your Paymenter admin panel in just a few minutes.

For better security, it is recommended to use a second VPS as your remote backup server to prevent data loss if your main server fails.

━━━━━━━━━━━━━━━━━━━━

🚀 Installation

Upload the extension directly from your Paymenter admin panel:

Paymenter → Extensions → Ready to Install / Upload → Upload Extension

After installation:

1️⃣ Enable the extension
2️⃣ Configure your backup settings
3️⃣ Select backup frequency
4️⃣ Choose storage type
5️⃣ Save settings

Your backups will start running automatically.

━━━━━━━━━━━━━━━━━━━━

⚡ Main Features

✅ Automatic database backups
✅ Manual backup creation
✅ Backup logs system
✅ Download backups directly from admin panel
✅ Clean old backups manually
✅ Automatic retention management
✅ Local storage support
✅ Remote VPS storage support
✅ Local + Remote storage support
✅ Secure SSH transfer
✅ Optional email notifications

━━━━━━━━━━━━━━━━━━━━

⏰ Backup Frequency Options

Choose how often backups are created:

🕐 Every Hour
🕕 Every 6 Hours
🕛 Every 12 Hours
📅 Daily
🗓️ Weekly
📆 Monthly

━━━━━━━━━━━━━━━━━━━━

🗂️ Retention System

Set how many days backups should be stored.

Example:

• Keep backups for 7 days
  
• Set to 0 to keep backups permanently
  

Automatically remove old backups when needed.

━━━━━━━━━━━━━━━━━━━━

🔑 Database Password Options

Choose how the extension connects to your database:

✅ Use Paymenter .env configuration automatically
✅ Use custom database password manually

━━━━━━━━━━━━━━━━━━━━

💻 Storage Options

🖥️ Local VPS
Store backups directly on your main server

🌍 Remote VPS
Transfer backups to another VPS using SSH

🔄 Both Local and Remote
Store backups in both locations for maximum protection

━━━━━━━━━━━━━━━━━━━━

🔒 Remote VPS Configuration

For remote backups you can configure:

• Remote VPS IP
  
• SSH Port
  
• SSH Username
  
• SSH Password
  
• Remote Backup Path
  

Recommended setup:

VPS #1 → Main Paymenter Server
VPS #2 → Backup Server

━━━━━━━━━━━━━━━━━━━━

📥 Admin Backup Management

Admins can directly manage backups from the backup logs page.

✅ View backup history
✅ Download backups anytime
✅ Create manual backups
✅ Remove old backups

━━━━━━━━━━━━━━━━━━━━

📦 Backup Format

All backups are stored in:

.sql.gz

Compressed format to reduce storage usage.

━━━━━━━━━━━━━━━━━━━━

⚙️ Requirements

Install required dependency:

apt-get install sshpass

Required for remote VPS transfers.