How to Automate MySQL & MariaDB Backups on Jelastic PaaS

In this article we explore how to create backups for MySQL and MariaDB databases, ensuring data can be restored when needed. The tutorial uses Jelastic PaaS’s built‑in backup script and shows how to set up automated cron jobs.

Data loss can occur due to human error, attacks, crashes, or disasters, so regular automated backups are essential. Jelastic provides a ready‑to‑use script that requires only a few parameters and a cron expression.

Setting Database Backup

The default backup script is located at /var/lib/jelastic/bin/backup_script.sh and can be viewed via the dashboard’s file manager.

To schedule the script, edit the cron file /var/spool/cron/mysql and add an entry in the format:

{frequency} {path to script} {script-parameters}

Example parameters:

-m {mode} – dumpall or dump

-c {count} – number of old backups to keep

-u {user} -p {password} – database credentials (escape % with a backslash)

-d {databases} -t {tables} – specific databases or tables

For instance, to back up the entire database every 10 minutes:

*/10 * * * * /var/lib/jelastic/bin/backup_script.sh -m dumpall -c 3 -u root -p passw0rd

Save the cron file to apply the schedule.

To store backups on another node or remote server, configure the appropriate installation node. Existing data in the node’s folder will be replaced by the remote files, or you can create a custom script that connects to a remote server.

After the script runs, backups appear as .bz2 archives in /var/lib/jelastic/backup.

Download Database Backup

You can retrieve backup files directly from the dashboard’s file manager, via SFTP/FISH, or by installing an FTP component (requires a public IP).

Restore Database from Backup

After creating a database node, access phpMyAdmin from the email notification. Use the “Import” tab, browse to the backup file, and upload it.

Upon successful import, phpMyAdmin shows a confirmation message, and the database is restored.

Following these steps ensures regular automated backups and easy restoration, keeping your data safe.