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.
Descrizione
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
Install and check
The Diagnostics tab shows on one screen what your hosting allows: memory, execution time, presence of mysqldump, free disk space.
Choose what matters
Leave out statistics and log data while keeping the table structures. Watch the saved space update as you go.
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
Download the module and install it from your back office (Modules > Module Manager).
Open the Diagnostics tab to check what your hosting allows, then run a first manual backup.
Reduce the volume if needed with the "Ignore some datas" option and the Tables tab.
Copy the URL from the Cron tab into a webcron service for an automatic daily backup.
Caratteristiche
- 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
- Detected and used when available, for extra speed
- Transparent fallback to the PHP engine otherwise
- Nothing for you to configure
- 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 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
- Every table with its engine, rows and size
- Leave out unneeded data in a few clicks
- Live counter of the space saved
- Excluded tables keep their CREATE TABLE
- The archive remains a faithful copy of the schema
- The database can be rebuilt elsewhere with nothing missing
- A button on every row of the table list
- The safety net before a risky SQL query
- Never removed by the archive rotation
- 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
- Dedicated URL for a webcron service or cron job
- Command line script for very large databases
- Each backup can be sent by email
- Alert when no backup has been made for N days
- Webhook to Slack, Discord or your own tool
- Built-in operation log
- Server environment and applicable limits
- Ten largest tables in the database
- Self-test script covering every format and method
- Restricted to the native super administrator profile
- Downloads protected by a file hash
- No native table modified, no override
- Database password never exposed
Cronologia versioni
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
Un progetto, una domanda, un audit?
Risposta personale entro 24h lavorative. Confrontiamoci senza impegno.
Parliamo del tuo progetto →