Blesta can be configured to automatically produce database backups. Backups can also be downloaded manually, at any time. Blesta may send backups to a remote server over SFTP, or to AmazonS3. Frequent backups are highly recommend. For more information on configuring backups see [Settings] > [System] > Backup.


Common Issues:

  1. The backup file is 0 bytes.
    1. Make sure you have the mysqldump binary on your system and that the exec() command is not disabled.

    2. Blesta tries to run the following command, see if you can execute it via SSH and receive any errors

      mysqldump --host='localhost' --port='3306' --user='USERNAME' --password='PASSWORD' 'DATABASE-NAME' > '/path/to/tmp/DATABASE-NAME122024_db_2025-02-25T175305Z.sql'

      Replace USERNAME, PASSWORD, DATABASE-NAME with the correct details (can be found in ~/config/blesta.php) If you get an error like the following, you need to grant permissions for the host 127.0.0.1. Or, you may need to add 127.0.0.1 to your /etc/hosts file.
      mysqldump: Got error: 1130: "Host '127.0.0.1' is not allowed to connect to this MariaDB server" when trying to connect

  • No labels