Sypex Dumper

Sypex Dumper is a quick and extremely easy to use Web-based solution for managing MySQL databases.

This little script can handle everything from boring maintenance tasks up to pretty crucial troubleshooting duties a developer might have.

Sypex Dumper doesn't only deal with database dumps and can provide a wide view of the entire database's performance and table structure.

Sypex Dumper can be used as a stand-alone application or it can be embedded in more powerful PHP-based applications.

All it needs from the developer's side is a PHP interpreter and the MySQL database's connection details.

Sypex Dumper can prove to be a pretty useful script to have around, especially if you work with MySQL databases on a regular basis.

Installation:

Download and unzip the Sypex Dumper package.
Move the /sxd/ folder to your Web server
Access the folder via a browser (http://domain/sxd/)
Enter MySQL authentication credentials to login

Sypex Dumper uses a dual licensing model. There's a Free edition and a Pro edition, the later coming packed with extra features under a commercial license.

Features:

• Free Edition Features:
• Support for export (backup) operations
• Support for import operations
• GZip compression
• BZip2 compression
• Encoding selection
• Auto-delete large backups
• Auto-delete older backups
• Support for localized interfaces
• Recovery strategies
• Resets AUTO_INCREMENT
• Supports MySQL tables, views, procedures, functions, triggers and events
• Logs all activity
• Supports downloading of backup files
• Can manually delete backups
• Create new databases
• Delete entire databases
• Check database tables
• Repair database tables
• Analyze database tables
• Optimize database tables
• Pro Edition Features:
• Ultra-fast backups
• Change or correct charsets
• Enable or disable keys
• Empty tables
• Delete tables
• Restore table structure
• Restores database objects
• Change table prefixes
• Import SQL files
• Supported third-party integrations:
• Drupal 6.x and 7.x
• ImageCMS 3.x and 4.x
• IPBoard
• Joomla 1.5+
• MODx
• phpBB
• PHP-Fusion
• PunBB
• vBulletin
• WordPress 2.9+
• XenForo

What is new in this release:

• Pro Edition:
• Instead of encoders now uses obfuscation code.
• Fixed error when restoring of selected objects from a backup.
• Free Edition:
• Error displaying a log file.
• Some minor code changes.

Requirements:

• PHP 4.3.1 or higher
• MySQL 3.23.56 or higher
• PHP's zlib and bz2 modules