Skip to main content

💾 Manual Firebird Database Backup

The platform provides certified database stacks with a simple and practical script to perform backups of stored data. The process is easy and can be completed in just a few minutes. No specialized knowledge is required — just follow the setup steps and define the appropriate cron expression.

⏱️ Backup Scheduling​

We will use the standard backup script to automate the process and configure it according to your needs (e.g., frequency, number of old backups to keep, etc.).

📂 Step 1: Access the Backup Script​

The script source code can be viewed directly in the panel:

  1. Click the Config button next to your database.
  2. This will open the embedded file manager.
  3. Locate the file: 
    /root/backup_firebird.sh
    imagem mostrando o dirétorio do Script de backup Firebird

🕒 Step 2: Automate with Cron​

To automate the script execution, we use the cron scheduler, already available in the containers.

Run in WebSSH on the instance:

crontab -e
{frequência} {caminho-para-o-script} {parâmetros-do-script}

imagem mostrando o local do diretório da cron de backup

🧩 Parameters:​

  • **{frequência}**: defines when the script will run (e.g., */10 * * * * = every 10 minutes).
  • **{caminho-para-o-script}**: script path (e.g., /root/backup_firebird.sh)
  • **{parâmetros-do-script}**: custom parameters.

🔁 Example:​

Full backup every 10 minutes, keeping the 3 most recent:

*/10 * * * * /root/backup_firebird.sh USUARIO SENHA BANCO 3

`

Save the file to apply the settings.

🌐 Step 3: Store on Another Server​

You can configure a remote mount point to store data outside the container.

⚠️ Attention: Any data already present in the mount point folder will be replaced by files from the remote directory.

💡 Alternatively, create a custom script on the remote server and connect using the database credentials to perform the backups.

🔎 Verify Backups​

Wait for the cron to run (according to the defined frequency) and access the folder:

/backup

📦 If everything goes well, you will see the file .FBK successfully generated.

✅ Choose the Best Option for You​

With these options, you can adapt the backup method to your needs — whether local or remote, manual or automatic.