MySQL Database Backup

Website: http://restkultur.ch/personal/wolf/scripts/db_backup

db_backup is a database backup script written in PHP4.
Most people will used it to have a daily snapshot of the dynamic data on their website. (e.g. content management systems, forums, guestbooks etc.) The script reads all tables in the MySQL databases you choose and exports (dumps) them in SQL files.

The generated SQL files can be used to rebuild the tables on any other MySQL database or server or on the same server in case of data-loss. db_backup has been tested sucessfully on large databases with 1.5 mio records.

Features:

• Backup multiple databases and servers with different users and passwords.
• Backups can be scheduled using cron (on UNIX systems) or AT (on Windows systems).
• Create daily, weekly and monthly snpashots of your database.
• Keep the daily, weekly and monthly backups for a user-specified time.
• Archive and compress the SQL files (*.tar.gz).
• Creates a detailed report of everything that has been done.
• Reports can be mailed to you or any other user- specified email- address, saved to disk or displayed in browser.
• Generated SQL files can be mailed to you or any other user-specified email-address.
• Generated SQL files can be uploaded by FTP to any user-specified FTP server.
• Choose to create SQL files for each table or one for each database.
• No system calls, everything in 100% pure PHP. PHP Safe-mode compatible.

System requirements

• PHP version 4.0.5 or later.
• MySQL server version 3.23.21 or later.

See the file INSTALL for more detailed system and software requirements.

Installation

For detailed instructions on how to install MySQL database backup on your server, please refer to the INSTALL document.

Aknowledgements

Based upon the script mysqlbackup.php from Juan Camilo Rozo. I was using his script successfully for many years on my hosting account.
Gracias Juan Camilo, por lejar me dormir bien todo estos años.

The scripts are also based on work started originally by my dear friend and provider Roger Fichmann (http://fastweb.ch)

The SQL file generation functions taken deliberately from PHPMyAdmin. Simply the best MySQL Adminstration package around. I recommend it also to import the generated SQL files. Get it from http://www.phpmyadmin.net/

The functions for mailing backup-reports and compressed backup-files are provided by the html-mime-mail-class from PHP Guru Richard Heyes (www.phpguru.org) by included in this distribution. You can get the latest version of that here.

Thanks to François Gonczi of equiterre, who contributed the parts for archiving under PHP with the PEAR Archive-Class, we got rid of the last system calls and db_backup has grown to a 100% pure PHP solution.

Copyright and Licensing

This product is Copyright ©  by Alain Wolf, Zurich - Switzerland and is distributed under the GPL.
Please read through the file LICENSE for more information about the license.

• .tar.gz file
• .zip file

  Back to Free Scripts Index...