Database backup module for PrestaShop: a simple and efficient solution

Database backup module for PrestaShop: a simple and efficient solution

Back up your database automatically or in one click, restore it just as easily, and get large databases through to the end even on shared hosting with tight limits.

Version v2.0.0 Compatibility PS 1.6 → 9.x Category Security 0 installs 0.0★ average rating

Description

The problem

Your host's backups are global, daily, and restoring one means opening a support ticket. They are of no use right before a module update or a manual change in the database.

As for ordinary backup tools, they stop halfway as soon as the database grows: execution time exceeded, memory exhausted, incomplete archive. On shared hosting, backing up simply becomes impossible.

The solution

An engine that processes the database in small batches: the backup advances step by step and reaches the end, whatever the server limits. It detects mysqldump when available and falls back on PHP on its own when it is not.

You stay in control of what gets archived and of the output format, and you restore in one click from the back office. The batch size is even measured for your server, so you never have to guess a technical value.

How it works

1

Install and check

The Diagnostics tab shows on one screen what your hosting allows: memory, execution time, presence of mysqldump, free disk space.

2

Choose what matters

Leave out statistics and log data while keeping the table structures. Watch the saved space update as you go.

3

Automate

Schedule a daily backup through a webcron service or a cron job, and be alerted if it ever stops running.

Detailed features

Batch engine

  • Large databases no longer hit the execution time limit
  • Live progress: tables, rows, speed, duration
  • Works on the most restrictive shared hosting
  • Interrupted scheduled backups resume automatically

Automatic mysqldump

  • Detected and used when available, for extra speed
  • Transparent fallback to the PHP engine otherwise
  • Nothing for you to configure

Four archive formats

  • gzip for the best compression
  • zip for easy opening on Windows
  • ZIP per table: one .sql file per table
  • Uncompressed SQL for immediate inspection

Measured batch size

  • Measured for your server at installation
  • Recomputable at any time with one click
  • Based on the available PHP memory
  • INSERT statements split under max_allowed_packet

Tables tab

  • Every table with its engine, rows and size
  • Leave out unneeded data in a few clicks
  • Live counter of the space saved

Always a complete schema

  • Excluded tables keep their CREATE TABLE
  • The archive remains a faithful copy of the schema
  • The database can be rebuilt elsewhere with nothing missing

Single-table backup

  • A button on every row of the table list
  • The safety net before a risky SQL query
  • Never removed by the archive rotation

One-click restore

  • From the backup list, with confirmation
  • Partial restore through the ZIP per table format
  • Documented recovery procedure if the shop is down
  • Every archive format can be restored

Automation

  • Dedicated URL for a webcron service or cron job
  • Command line script for very large databases
  • Each backup can be sent by email

Monitoring

  • Alert when no backup has been made for N days
  • Webhook to Slack, Discord or your own tool
  • Built-in operation log

Diagnostics

  • Server environment and applicable limits
  • Ten largest tables in the database
  • Self-test script covering every format and method

Controlled access

  • Restricted to the native super administrator profile
  • Downloads protected by a file hash
  • No native table modified, no override
  • Database password never exposed

Responsible security policy

This module adheres to the TouchWeb Charter for responsible cybersecurity: acknowledgement within 7 days for any relevant report, fix and CVE publication within 30 days, never a silent patch. Published by Mediacom87, PrestaShop specialist since 2008.

Installation in 4 steps

1

Download the module and install it from your back office (Modules > Module Manager).

2

Open the Diagnostics tab to check what your hosting allows, then run a first manual backup.

3

Reduce the volume if needed with the "Ignore some datas" option and the Tables tab.

4

Copy the URL from the Cron tab into a webcron service for an automatic daily backup.

Features

Changelog

v2.0.0
  • New chunked backup engine: large databases are processed in small batches and no longer hit server time limits
  • Automatic detection of mysqldump for faster backups, with a transparent fallback to the PHP engine when it is unavailable
  • Four archive formats: gzip, zip, one .sql file per table inside a zip, or uncompressed SQL
  • Scheduled backups resume where they stopped and complete even on hosting with short time limits
  • Restore now supports every archive format
  • New Tables tab to exclude the data of chosen tables or back up a single table
  • The archive limit now applies to scheduled backups only: manual backups and single-table dumps are never deleted automatically
  • New Diagnostics tab: server environment, applicable limits, largest tables and backup directory status
  • Alert on the module page when no backup has been made for a chosen number of days
  • Webhook notification after each backup (Slack, Discord or your own endpoint)
  • Command line script for very large databases, free from web server timeouts
  • Your existing license is found automatically after a reinstallation or on another subdomain
  • PrestaShop 9 compatibility
  • Fixed the zip formats, which could produce an unreadable archive
  • Fixed saving one tab, which could reset the settings of another
  • Strengthened security of backup download, restore and deletion
  • Translations completed in all 17 languages
v1.2.0
  • Added option to reduce backup file size
  • Addition of new tables ignored as unnecessary to reduce backup size
  • Added compatibility with PrestaShop 8
  • Add the number of backup files available directly on the backups tab
  • Display the date of backups saved in the file name rather than the date of the file itself when copying or restoring servers
  • Adding logs directly in the module
  • Add identification between backups performed manually or using the Cron task
v1.1.0
  • Removal of unnecessary data from certain tables to reduce the size of the database without compromising recovery
  • Added database size as a badge on the backup tab for better visibility
v1.0.0
  • Initial commit

A project, a question, an audit?

Personal reply within 24 working hours. No strings attached.

Let's discuss your project →