เครื่องมือเด็ดในการ Backup ฐานข้อมูล MySQL

Feature:
Here are some of the functions provided by mysqldumper:


mysqldumper can read Dumpfiles from other Scripts via the integrated parser (for example from phpMyAdmin)
Security: mysqldumper can generate a .htaccess-file to protect itself and all of your backup-files
mysqldumper can do Multipart-Backups. That means: mysqldumper can automatically split the dumpfile if it gets bigger than your chosen size. When you want to restore a backup and choose the wrong part - it doesn' matter => mysqldumper will notice that and will get the correct startfile automatically.
automatic Errormodul
MiniSql => You have access to your MySQL-Tables. You can delete tables, edit or insert data. You can run/ save any SQL-Statement.
Database-Overview: look at running processes or even stop them
very good file-overview => backups of the same database are shown as one entry. Click it to see all of the files.
automatic file-deletion => set your own rules to delete old backups. Specify the age or the number of files when it will be deletetd automatically to save server webspace.
Perl Cronscript done => all features of the PHP-Script are now integrated in the Perlscript that can be started via a Cronjob
Configuration can be set seperatly for each Script (PHP and Perl)
befor you start a backup all your parameters are shown again, so you definitely know what you are doing :-)
Send Emails with or without your dumpfile attached / you can set the maximum size of the attachement. If it grows bigger it won't be attached.
Send dumpfiles via FTP to another Server. This is also working using the multipart feature.
Faster backups und restore (compared to older versions of mysqldumper)
ect. ect. ect ...


http://www.mysqldumper.de/en