SQLBackupAndFTP Database Backup Configuration Guide

SQLBackupAndFTP Database Backup Configuration

SQLBackupAndFTP is a backup solution for SQL Server, MySQL, and PostgreSQL databases. The software performs full, differential, and transaction log backups, compresses and encrypts backup files, and stores them on network locations, FTP servers, or cloud storage services.

Database Connection Setup

1. Navigate to the Connect to Database Server settings
2. Click on the settings wheel icon
3. Configure the connection parameters:

Setting	Value
Server Type	MySQL Server (TCP/IP)
Server Name	127.0.0.1
User Name	root
Password	(leave blank unless password is set)

4. Click Test Connection to verify successful connection
5. Select target databases and click Save & Close

Backup Storage Configuration

Setting Up Storage Destination

1. Navigate to the Store backups in selected destinations section
2. Click the green + button to add a storage location
3. Select your preferred storage method (Google Drive recommended)

Storage Location Recommendations

Store database backups on external storage services rather than local VPS storage. This provides better data protection and disaster recovery capabilities.

Automated Backup Scheduling

Schedule Configuration

1. Go to the Schedule backups tab
2. Configure backup frequency and timing parameters
3. Run a test backup to verify functionality
4. Confirm the backup file appears in your selected storage destination

Verification Steps

Monitor the initial backup process to ensure:

• Backup completes successfully
• Files are delivered to the configured storage location
• Email notifications function properly (if configured)

Related Articles

• SQL Error 2013 Fix - Troubleshoot database connection issues
• SFTP Connection Guide - Transfer backup files securely
• VPS Storage Management - Manage server storage

Need secure database hosting? View Vluxon FiveM VPS plans with reliable database storage and backup options.