db_backup_telegram.php is a PHP-based multi-database backup script that allows you to automate backups for MySQL/MariaDB databases. It supports compression, Telegram upload notifications, retention management, emoji captions, and robust logging.

• Backup multiple MySQL/MariaDB databases.
• Supports database compression (gzip, bzip2, zip).
• Telegram bot integration for uploading backups with custom captions.
• Backup retention to automatically clean up old backups.
• Verbose logging for easier debugging and auditing.

• PHP 7.4+ with PDO and cURL extensions enabled.
• MySQL or MariaDB with mysqldump utility (optional but recommended).
• A Telegram bot token and chat ID for uploading backups to Telegram.

1. Clone the repository or download the db_backup_telegram.php file.

   git clone https://github.com/BaseMax/database-auto-backup-telegram.git

2. Ensure you have a Telegram bot. If not, create one by talking to BotFather on Telegram. You will need the bot token and chat ID for sending backup files.

3. Configure the script:

   • Open the db_backup_telegram.php file.
   • Modify the $config array with your database credentials and Telegram bot details.

   Example:

   $config = [
       'databases' => [
           [
               'name' => 'your_db_name',
               'user' => 'your_db_user',
               'pass' => 'your_db_password',
               'host' => 'localhost',
               'port' => 3306
           ]
       ],
       'output_dir' => __DIR__ . '/backups',
       'use_mysqldump' => true, // Enable mysqldump or fallback to PHP PDO
       'compression' => 'gz',   // Supported: gz, bz2, zip
       'telegram' => [
           'bot_token' => 'your_bot_token',
           'chat_id' => 'your_chat_id',
           'caption' => 'Auto DB Backup'
       ],
       'retention_days' => 30,  // Retain backups for 30 days
       'log_file' => __DIR__ . '/backups/backup.log',
   ];

4. Make sure your web server or PHP process has write permissions to the output directory.

1. Run the script manually:

   You can run the script directly from the command line or via a web server. To run the script manually, execute:

   php db_backup_telegram.php

2. Automate backups with a cron job (Linux/macOS):

   You can automate the script to run at scheduled intervals by setting up a cron job. For example, to run it every day at midnight:

   crontab -e

   Add the following line:

   0 0 * * * /usr/bin/php /path/to/db_backup_telegram.php

• databases: An array of database configurations (e.g., database name, user, password, host, port).
• output_dir: Directory where the backup files will be stored.
• use_mysqldump: Set to true to use mysqldump for database backup, or false to use PHP PDO fallback.
• disable_compression: Set to true to disable compression, or false to enable it (compression options: gz, bz2, zip).
• compression: Specify the compression type (valid values: gz, bz2, zip).
• disable_telegram: Set to true to disable Telegram upload.
• telegram: Telegram bot configuration (includes bot token, chat ID, and caption).
• retention_days: Number of days to retain backup files before they are deleted.
• cleanup_after_upload: Set to true to delete the backup files after they have been uploaded to Telegram.
• log_file: Path to the log file for backup operations.
• verbose: Set to true to enable detailed logging.

The script logs all operations, including successful backups, errors, and Telegram uploads. By default, logs are written to backups/backup.log. You can change the log file location by modifying the log_file configuration.

The script supports automatic cleanup of old backups based on the retention_days configuration. For example, if set to 30, the script will delete backups older than 30 days. Set retention_days to 0 or leave it empty to disable retention.

This project is licensed under the MIT License.

© 2026 Seyyed Ali Mohammadiyeh (Max Base)