MysqlDumper:Mysql database backup, restore, management tools

Posted under Database Tools Development Mysql Open Source Software on Sunday, 12 July 2009 by rueben

What is MySQLDumper ?

MySQLDumper is a backup programm for MySQL-Databases, written in PHP and Perl. You can dump your data into a backup file and if needed, restore it. Especially on shared hostings without access to shell-commands, MySQLDumper is a sensefull option.
The project is a OpenSource Project and is released under the GNU-Licenses.

The problem …

A PHP-Script has a maximum of execution time; anything after above the limit (Usually sets to 30 seconds) will result in losing data. Such behavior renders large database backup impossible. Perhaps you already noticed how much of a problem it could be while using other tools.

MySQLDumper fills a gap …

MySQLDumper uses a proprietary technique to avoid execution interruption. It only reads and saves a certain amount of commands and then calls itself via JavaScript and memorizes how far in the process it was and resumes its action from its last standby.
MySQLDumper restores a backup file by using the same process. Unlike other tools splitting and splicing of large files is no longer necessary.

MySQLDumper offers to write data directly into a compressed gz-File. The Restore-Script is able to read this file directly without unpacking it. Of course you can use it without compression, however using Gzip saves a sizeable amount of bandwidth.