EJB - Easy Joomla Backup

Version 4.3.0.1-PRO - 2023-09-21

• ^ [CLI] Added wildcard file exclusion in backup process.
• # [CLI] Fixed SQL syntax issue with special characters in the table name.

Version 4.3.0.0-PRO - 2023-09-19

• + Wildcard File Exclusion in Backup: Added support for wildcard (*) file exclusion during the backup process. You can now use asterisks to exclude multiple files that match a particular pattern. With the wildcard functionality, you may exclude all files from a specific type (e.g. *.zip). Thanks to Geraint for requesting this feature!
• + CLI Plugin Status in Footer: Added the CLI plugin status in the footer for better visibility and quick checks on the plugin's operational status.
• + Joomla! Compatibility Check in Installation Script: The installation script has been updated to include a check for the highest compatible version of Joomla! to avoid any problems caused by using incompatible core versions.
• ^ phpseclib Update: Updated the phpsseclib script to version 3.0.23. This new version includes improvements and fixes that enhance secure SFTP uploads.
• ^ PHP 8.1 Compatibility: Resolved a PHP 8.1 deprecation warning: "Deprecated: Implicit conversion from float-string to int loses precision." The underlying issue has been fixed to ensure full compatibility with PHP 8.1.
• # Archive Name Suffix: The secure suffix will only be added to the archive name if the encryption option is enabled and a password is provided. This makes it easier to identify encrypted backups.

Version 4.2.0.1-PRO - 2023-07-11

• ^ Updated phpseclib library
• # Fixed SQL syntax issue with special characters in the table name. Thanks to Robert S. for reporting it!

Version 4.2.0.0-PRO - 2023-06-10

• + Added SFTP Upload feature. To transfer your backup archives to a remote server, you must establish an SFTP connection by providing the host, username, and password. Additionally, you can select a custom folder path to upload the files to a specific subfolder as per your requirement.
• + Added Add all tables option. Add all tables to the database, even those that do not have the prefix of the Joomla! installation (e.g. a Matomo installation on the same database). Thanks to Volkmar for requesting this feature!
• + Added a new feature to overview tables, allowing you to hide table columns dynamically.
• + Code optimisations.

Version 4.1.0.0-PRO - 2023-02-07

• Increased technical requirements for Joomla! 4: Increasing Technical Requirements - Core & PHP for Joomla! 4 Pro Extensions.
• + Code optimisations.
• ^ Changed default value for the option "Maximum execution time" (15).

Version 4.0.4.3-PRO - 2022-12-09

• + Added logging for exceptions using Joomla!'s core log system.
• # Optimised database structure validity executed in the update routine.

Version 4.0.4.2-PRO - 2022-11-09

• # An empty line in exclude folder option excluded all folders. Thanks to HorstG for reporting it!

Version 4.0.4.1-PRO - 2022-09-01

• # Updated the CLI command files to bypass a bug introduced in Joomla! 4.2.1. Thanks to Thomas (thosch) for reporting it!
  Don't forget that you can use the --json option to receive a JSON response from the backup call (php cli/joomla.php backup:full --json)
  Example output: {"date":"2022-09-01 08:07:15","dateLocal":"2022-09-01 10:07:15","comment":"Backup file was created by a CLI command","name":"cli_2022-09-01_10-07-15_ckYVXVZqWYoPxLSV.zip","type":"fullbackup","duration":7.39,"size":27727416,"status":true}

Version 4.0.4.0-PRO - 2022-08-30

• + Added Pro Security Token validation check. The Pro package contains a token file with an individual security token linked to the user account and checked against the validation server for authenticity.
• ^ Multiple internal code optimisations.
• # Added an icon to component dashboard view. Thanks to Dirk (Wilderer) for reporting it!

Version 4.0.3.2-PRO - 2022-05-18

• + Added inline help toggle button to display inline descriptions to bypass a bug in Joomla! 4.1.3.
• ^ Changed field types from text to integer with dropdown list for the options "Initial execution level" and "Maximum amount of files per iteration".
• ^ Optimised default values for the options "Initial execution level" (6) and "Maximum amount of files per iteration" (1000).
• ^ Optimised the exclusion logic to improve the performance.
• # Fixed termination condition in a recusive function called via Ajax. Thanks to Michael K. for reporting it!

Version 4.0.3.1-PRO - 2022-02-17

• ^ Updated search tools output of the backend component due to the path change to the CSS file in Joomla! 4.1
• ^ Code optimisations

Version 4.0.3.0-PRO - 2022-01-10

• + Added Maximum amount of files per iteration option - Maximum amount of files per batch process to avoid timeouts in folders with a large number of files. Default: 500
• ^ Improved exception handling in the backup process with detailed error message output
• ^ Code optimisations

Version 4.0.2.0-PRO - 2021-11-17

• + Added the built-in Download Key Manager support to enter your Pro Update ID without installing the update helper plugin.
  Important: Please copy your personal Pro Update ID using the second copy button in the Pro ID Manager and enter the key in System - Update - Update Sites - Select the entry of the Pro extension and enter the ID into the Download Key field.
• ^ Code optimisations

Version 4.0.1.1-PRO - 2021-10-27

• + Added dateLocal field with the timezone of the server to the JSON output option. Thanks to Thomas Sch. for requesting it!
• ^ Updated session handler check. Thanks to Thomas Sch. for reporting it!

Version 4.0.1.0-PRO - 2021-10-26

• + Added --json and --raw options to the CLI commands. Thanks to Thomas Sch. for requesting this feature!
  Usage via the command line: php cli/joomla.php COMMAND --json and php cli/joomla.php COMMAND --raw
  --json will return a JSON with all relevant data that is also used in the notification mail, --raw will return 0 or 1 on the command line

Version 4.0.0.1-PRO - 2021-09-26

• # Upper and lower case of classes on Linux servers. Thanks to Werbeagentur Müller for reporting it!

Version 4.0.0.0-PRO - 2021-09-24

• + First Pro release for Joomla! 4.x based on EJB Pro version 3.6.1.0-PRO
• + Added system plugin for CLI commands: backup:full, backup:database and backup:file
  Usage via the command line: php cli/joomla.php COMMAND - Replace COMMAND with one of the commands above!
• ! Removed CLI standalone script

Version 3.6.3.2-PRO - 2022-12-10

• + Added logging for exceptions using Joomla!'s core log system.
• # Fixed rare possible response error "Undefined array key 0" if error reporting is enabled. Thanks to eumel1602 for reporting it!

Version 3.6.3.1-PRO - 2022-05-18

• ^ Changed field types from text to integer with dropdown list for the options "Initial execution level" and "Maximum amount of files per iteration".
• ^ Optimised default values for the options "Initial execution level" (6) and "Maximum amount of files per iteration" (1000).
• ^ Optimised the exclusion logic to improve the performance.
• # Fixed termination condition in a recusive function called via Ajax. Thanks to Michael K. for reporting it!

Version 3.6.3.0-PRO - 2022-01-08

• + Added Maximum amount of files per iteration option - Maximum amount of files per batch process to avoid timeouts in folders with a large number of files. Default: 500
• ^ Improved exception handling in the backup process with detailed error message output
• ^ Code optimisations

Version 3.6.2.0-PRO - 2021-10-28

• + Added --json option to the CLI command. Thanks to Thomas Sch. for requesting this feature!
  Usage via the command line: php cli/ejbCli.php TYPE --json
  --json will return a JSON with all relevant data that is also used in the notification mail.
  Important: You need to provide the backup type ([1|2|3]) if you want to use the --json option!

Version 3.6.1.0-PRO - 2021-09-09

• ^ Optimised post process handling for CONSTRAINT rules in the database backup process. Thanks to Marion M. for reporting it!

Version 3.6.0.2-PRO - 2021-07-29

• + Mail only if errors occur option - Sends the notification mail only if an error occurs. Thanks to Rico for requesting this feature!

Version 3.6.0.1-PRO - 2021-06-29

• + Mail after backup - Cron plugin & CLI script option - This feature sends a notification email with all details after the backup process if the cron plugin or the CLI script is used (cli/ejbCli.php).
• ^ Updated custom field

Version 3.6.0.0-PRO - 2021-05-21

• + Backup storage location option - With this option, you may define a custom storage location for the backup archives. For instance, you can specify a folder outside the webroot to block access via a browser. Use ../ to specify a folder outside the webroot. Example: ../backups
  Note: PHP cannot always write data outside the webroot in strict server environments (open_basedir restriction). If you run into this problem, then please specify a folder within the webroot directory!
• + Added "Backup storage location is writable" check to the list of requirement checks.
• ^ Changed the version number specification. The first number stands for the supported major Joomla! version. The following three numbers follow the Semantic Versioning Specification (SemVer), as it used to be previously.
• ^ Updated custom field
• ^ Updated language strings
• ^ Code optimisations
• # Fixed time offset of discovered backup entries

Version 3.5.4-PRO - 2020-12-13

• + Dropbox - Automatic upload - Uploads the newly created backup archives automatically to Dropbox.
• + Dropbox - Automatic upload - Cron plugin & CLI script - Uploads the newly created backup archives automatically to Dropbox if the cron plugin or the CLI script is used (cli/ejbCli.php).
• ^ Code optimisations

Version 3.5.3-PRO - 2020-07-28

• + Database backups are generated in separate Ajax calls instead of one single request, just like the file system backup. This approach mitigates the risk of hitting server limits for big databases drastically!

Version 3.5.2-PRO - 2020-07-15

• + Optimised database backup process for huge tables (> 1 million entries) to mitigate resource consumption
• ^ Updated custom field

Version 3.5.1-PRO - 2020-05-05

• + Indicator of the backup progress in per cent in the tab/window title
• ^ Updated language strings
• ^ Code optimisations

Version 3.5.0-PRO - 2020-04-27

• First release with increased technical requirements: Increasing Technical Requirements - Joomla! Core & PHP for Pro & Free Extensions
• + Dropbox Upload - Associates Easy Joomla Backup Pro with a Dropbox account to allow the upload of backup archives with one click to Dropbox.
• ^ Code Optimisations

Version 3.4.4-PRO - 2019-09-19

• ^ Changed default value to "Yes" for option "DROP TABLES" - Better setting for the new restoration script Easy Joomla Backup Pro Restore
• # Name of SQL dump file (without .zip extension)

Version 3.4.3-PRO - 2019-08-17

• + Added ".secure" file name suffix to backup archives with password protection
• + Added password confirmation field with a dynamic check for equal entries

Version 3.4.2-PRO - 2019-03-16

• ^ Improved download handling of large package sizes - Thanks for reporting this issue to Blu Dove Designs

Version 3.4.1-PRO - 2019-03-07

• ^ Increased minimum Joomla! version to 3.9 - Replaced classes JFile / JFolder with File / Folder.
• ^ Enforce HTTP status code 200 for archive downloads
• ^ Updated project page in all files (from https://joomla-extensions.kubik-rubik.de to https://kubik-rubik.de)
• # Filter for root files was set too strict, files starting with a dot (.) have been filtered

Version 3.4.0-PRO - 2019-02-14

• + Encryption - Encrypt Backup Archives - The Advanced Encryption Standard (AES) is used to encrypt the archives. Technical requirements for the encryption functionality: PHP >= 7.2 and Libzip >= 1.2. Note: The encryption process increases the backup time!
• + Encryption Algorithm Key Size - Sets the encryption algorithm key size. According to NIST (U.S. National Institute of Standards and Technology), the 128-bit key size is perfectly adequate for secure encryption. Though, you may increase the key to 192-bit or even 256-bit.

Version 3.3.0-PRO - 2019-01-28

• + First Pro release based on EJB version 3.2.5
• + Dynamic Backup Process (Ajax Requests) - Backups are created using Ajax requests to avoid timeouts or memory limit fatal errors
• + Option: Maximum Execution Time - Maximum execution time in seconds per batch process. The value should be adjusted if the backup process runs into a timeout. Default value is 30 seconds. The value 0 means that the script uses the half of the maximum execution time provided by the server. If you set a custom value, then the system value is overwritten. If you encounter an error, then decrease the selected value step-by-step to find the best setting. Actual execution time is entered value in seconds + processing time of currently archived folder!
• + Option: Initial Execution Level - How many levels should be used for the initial scanning preparation values. This option helps you to avoid timeouts if you have a nested and deep file system structure. If you are still running into timeouts, then you should increase the number. To improve performance you can reduce the number!
• + Removed dependency on mysqli handler - Dumps with the mysql handler are created properly

Version 3.4.1.0-FREE - 2021-09-09

• ^ Optimised post process handling for CONSTRAINT rules in the database backup process. Thanks to Marion M. for reporting it!

Version 3.4.0.0-FREE - 2021-08-02

• + Maintenance update based on 3.6.0.2-PRO
• + Database backups are generated in separate Ajax calls instead of one single request, just like the file system backup. This approach mitigates the risk of hitting server limits for big databases drastically!
• + Optimised database backup process for huge tables (> 1 million entries) to mitigate resource consumption
• ^ Changed the version number specification. The first number stands for the supported major Joomla! version. The following three numbers follow the Semantic Versioning Specification (SemVer), as it used to be previously.
• ^ Updated custom fields
• ^ Updated language strings
• ^ Code optimisations
• # Fixed time offset of discovered backup entries

Version 3.3.1-FREE - 2020-05-03

• + Maintenance update based on 3.5.0-PRO
• + Indicator of the backup progress in per cent in the tab/window title
• ^ Updated language strings
• ^ Code optimisations

Version 3.3.0-FREE - 2020-01-03

• First release with increased technical requirements: Increasing Technical Requirements - Joomla! Core & PHP for Pro & Free Extensions
• + Dynamic Backup Process (Ajax Requests) - Backups are created using Ajax requests to avoid timeouts or memory limit fatal errors
• + Removed dependency on mysqli handler - Dumps with the mysql handler are created properly
• + Modern, optimized code
• ^ Enforce HTTP status code 200 for archive downloads
• ^ Improved download handling of large package sizes
• ^ Changed default value to "Yes" for option "DROP TABLES"
• # Name of SQL dump file (without .zip extension)

Version 3.2.6 - 2019-06-30

• + Added Custom Field - Pro Button
• ^ Updated Custom Fields
• ^ Updated Project Page URL

Version 3.2.5 - 2017-10-09

• + Option: Add Random String To Name (Suffix) - With this option a random, 10 characters long string is added to the archive name to abolish the fixed name pattern.
• ^ Custom Field
• ^ Small Code Optimizations

Version 3.2.4 - 2016-08-31

• ^ Improved logic check in the backup process to avoid a PHP Warning notice if open_basedir restriction is used - Thanks to Natalie F. for reporting it!
• ^ Updated Language Files

Version 3.2.3 - 2016-06-03

• + Function setExternalAttributesName check - Added check whether required function to set the permission rights on UNIX systems is available - since PHP 5 >= 5.6.0, PHP 7, PECL zip >= 1.12.4 - Thanks to Marion M. for reporting this issue!

Version 3.2.2 - 2016-06-03

• # Permission rights on Unix systems - All file and folder permission rights are set properly on Unix systems - Thanks to Mario I. for reporting this issue and Remi C. for providing a solution for the fix!
• ^ Code style
• ^ Updated custom field

Version 3.2.1 - 2015-11-03

• ^ SQL dump process - Improved the handling of numeric values that do not have the data type integer - Thanks to Marion for reporting this issue!
• ^ Code style

Version 3.2.0 - 2015-07-31

• + Donation Code Validation Process - Improved the validation process with a new server (HTTPS request) plus an independent, separated fallback server (HTTP request).

https://check.kubik-rubik.de/
http://check.kubik-rubik.eu/

https://downloads.kubik-rubik.de/

Version 3.1.0 - 2015-05-17

• + CLI script - After the installation the CLI script is available in the cli folder of the Joomla! instance. Use the script to create backups through your terminal directly on the server. With the help of crontab you can create cron jobs to automate the backup process.
  Usage in the terminal on the sever:
  

  php path/to/joomla/root/cli/ejb_cli.php x

  Argument x can be: 1 - Full Backup, 2 - Database Backup, 3 - File Backup. Default is 1 if no argument is provided!
  Crontab entry to create full backups daily at midnight (Open with 'crontab -e', do not forget to restart this service after you've saved the file):

  0 0 * * * php path/to/joomla/root/cli/ejb_cli.php 1

• + Option: Prefix for archive names - With this option the prefix can be set manually to identify the archive files. This is especially useful for the CLI process!
• ^ Semantic versioning - Switched to semantic versioning, see http://semver.org/ for more details. Please update manually since the core update server functionality will not recognize the new version!

Version 3-5 - 2015-03-23

• + Status notification for the EJB Cronjob plugin - Notification with link in the footer of the main view
• + Improved Create view - Uses full width & better positioning of the loading animation
• + Update Server - Added the Joomla! core functionality for the update checks
• ^ Updated Donation Code field - Uses the HTTP API for the requests and calls the check script via HTTPS
• ^ Links in the language files - Updated outdated links to the JED (Joomla! Extensions Directory)
• ! Removed deprecated "JError" usage - Uses PHP Exceptions instead
• ! Removed Version Check field
• # Search button - Cancel - getElementById (change needed in Joomla! 3.4.0 and higher)
• # Package name creation - Correct package names for websites that use HTTPS

Version 3-4 - 2014-06-27

• + Joomla! 3.0.x / 3.1.x compatibility - added compatibility for outdated core versions on popular request

Version 3-3 - 2014-05-09

• + New option: Maximum number of backup files - Outdated files are removed automatically after the backup process was executed

Version 3-2 - 2014-02-08

• ^ Improved the handling of NULL values
• ^ Improved the handling of "\0" (ASCII 0 (0x00)), NUL-byte characters
• ^ Improved output - added icons
• ^ Updated custom fields

Version 3-1 - 2013-09-10

• + First release for Joomla! 3 - based on version 2.5-2 with important modifications and optimizations for Joomla! 3.x
• + This release is tested only with Joomla! 3.1.5 - do not use it in a lower Joomla! version. Do not report any problems with other Joomla! versions. Only the mentioned version is supported officially by EJB!

Version 2.5-4 - 2014-05-19

• + New option: Maximum number of backup files - Outdated files are removed automatically after the backup process was executed
• + Added database type check

Version 2.5-3 - 2014-02-07

• + Automatic comment from the Cronjob Plugin - if the backup process was executed by the cronjob plugin, then it is specified in the comment field
• ^ Improved the handling of NULL values
• ^ Improved the handling of "\0" (ASCII 0 (0x00)), NUL-byte characters
• ^ Updated custom fields

Version 2.5-2 - 2013-07-03

• + New Feature: Cronjob - with the new system plugin EJB Cronjob the backup process can be executed directly in the frontend. Use this feature to create recurring cronjob calls. This great feature will save you time and nerves. Configure the cronjob task, lean back and relax, EJB Cronjob will do the job for you! :-)
• ^ Drop table - added IF EXISTS to the drop table order to avoid errors while importing the sql file in a different database
• ^ Updated custom fields

Version 2.5-1 - 2013-05-18

First stable release with minor changes to the RC2 version

Version 2.5-1 RC2 - 2013-03-26

+ Feature: Add additional tables - with this feature additional tables which do not have the Joomla! prefix can be added to the database dump
# Wrong status notice after a download

Version 2.5-1 RC - 2013-03-19

+ First public release of the component