MITS Cron Database Backups - Back Up, Manage & Restore Your Database

Back up your modified eCommerce shop database automatically, regularly or manually, and keep track of your backups conveniently.

The MITS Cron Database Backups module lets you back up the database of your modified eCommerce Shopsoftware automatically via a cron job or manually at the click of a button whenever needed. This protects important shop data against unnecessary loss and lets you manage existing backups directly in the administration area at any time.

In addition to standard database backups, the module provides practical MITS Database Tools. These let you download, delete or restore existing backups, or selectively back up and restore individual tables when required.

The module provides the following functions:

• Create automatic, regular database backups via a cron job.
• Start manual database backups directly in the administration area.
• Create backups as complete SQL/GZIP files.
• Optional table backup mode with a separate backup file for each database table.
• Select individual tables for manual backups.
• Download existing backups directly through the database tools.
• Restore complete backups or individual tables from table backups.
• Automatic safety backup before every restore.
• Delete existing backups individually or in bulk.
• Optionally send database backups by email.
• Optionally upload database backups to an external backup server via FTP.
• Optionally delete old database backups automatically after a specified period.
• Optionally clean up old LOG files of types mod_notice, mod_deprecated and mod_strict automatically.
• SQL query box for individual SQL statements directly in the administration area.

Extended database tools for administrators

The integrated database tools have been expanded with additional functions for maintaining, checking and managing the shop database. In addition to creating and restoring backups, you can check and adjust important database settings directly in the administration area.

• Convert tables between MyISAM and InnoDB.
• Adjust the database character set and collation, for example to utf8mb4.
• Select specific tables for backup, restore or conversion.
• Optionally set DB_SERVER_ENGINE and DB_SERVER_CHARSET in the active configure.php.
• The configure.php is temporarily made writable if necessary, then restored to its previous file mode.
• The backup folder at export/mits_cron_database_backups is automatically protected against direct external access.
• Writing module log files can be enabled or disabled in the system module.

Note: the conversion functions are intended as expert tools and should only be used when the intended database changes are clearly understood.

Conclusion: the module is therefore more than a simple cron job backup: it is a practical extension for managing, checking, restoring and maintaining your shop database.