This class can generate MySQL backup of files with SQL statements that can restore the database.
It can traverse the list of tables of a given MySQL database and generates SQL statements that can recreate the tables and the values of the respective records.
The generated SQL INSERT statements can insert up to 200 records at once.
The generated SQL statements of a table are stored in files, one for each table. The files are stored in a backup directory with a name that contains the current date.
The resulting directory and the contained files are stored in a ZIP file to take less disk space.
The class can also delete backup zip files older than 30 days. |
