PHP Classes

Multi Threaded MySQL Backup and Restore Daemon: Backup multiple MySQL tables in parallel

Recommend this page to a friend!
     
  Info   View files Files   Install with Composer Install with Composer   Download Download   Reputation   Support forum   Blog    
Ratings Unique User Downloads Download Rankings
Not enough user ratingsTotal: 791 All time: 4,316 This week: 206Up
Version License PHP version Categories
ash-dumper 1.0GNU General Publi...4.3PHP 5, Databases, Systems administration
Description 

Author

This class can backup and restore multiple MySQL tables in parallel.

It can take a backup of a MySQL database by running the mysqldump command multiple times in parallel, one time for each database table to backup.

The class can also do the opposite, i.e. restore a MySQL database by running the mysql command multiple times in parallel to restore all the database tables.

Innovation Award
PHP Programming Innovation award winner
August 2012
Winner


Prize: One downloadable e-book of choice by O'Reilly
Backup processes usually take a long time to complete, especially when the amount of data to backup is large.

This class attempts to make the process of taking backups of MySQL databases by creating multiple parallel processes, each ones takes a backup of a different table of the database.

Manuel Lemos
Picture of Aziz S. Hussain
  Performance   Level  
Name: Aziz S. Hussain <contact>
Classes: 8 packages by
Country: United States United States
Age: 42
All time rank: 51064 in United States United States
Week rank: 178 Up22 in United States United States Up
Innovation award
Innovation award
Nominee: 2x

Winner: 1x

Details

ASHDumper.php PHP version 5.3 @author Aziz Hussain <azizsaleh@gmail.com> @copyright GPL license @license http://www.gnu.org/copyleft/gpl.html @link http://www.azizsaleh.com ------------- ASHDumper.php -------------- Use this script to backup/restore your database at a table level. Each table will get its own process to get backed up and restored ------------ REQUIREMENTS ------------ - You need to have proc_open Enabled - You need to have access to mysql/mysqldump - Output directory must exist and must be writable by you -------- OPTIONS -------- -h Host Name of MySQL -u User Name of MySQL -p Password of MySQL -d Database Name of MySQL -o Folder of where to store SQL files (backup) or located (restore) ------ USAGE ------ To backup a database: php ASHDumper.php --backup -h localhost -u root -pPassword -o c:\abspath\to\output\dir To restore a database (DB Must Exist): php ASHDumper.php --restore -h localhost -u root -pPassword -o c:\abspath\to\sql\dir To restore a database (Create DB If It Does Not Exist): php ASHDumper.php --restore --create -h localhost -u root -pPassword -o c:\abspath\to\sql\dir

  Files folder image Files (2)  
File Role Description
Accessible without login Plain text file ASHDumper.php Class Main File
Accessible without login Plain text file README.txt Doc. Readme and Instructions

The PHP Classes site has supported package installation using the Composer tool since 2013, as you may verify by reading this instructions page.
Install with Composer Install with Composer
 Version Control Unique User Downloads Download Rankings  
 0%
Total:791
This week:0
All time:4,316
This week:206Up