PHP Classes
elePHPant
Icontem

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

Recommend this page to a friend!
  Info   View files View files (2)   DownloadInstall with Composer Download .zip   Reputation   Support forum   Blog    
Last Updated Ratings Unique User Downloads Download Rankings
2012-07-26 (4 years ago) RSS 2.0 feedNot enough user ratingsTotal: 772 All time: 4,209 This week: 1,099Up
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
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  
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

 Version Control Unique User Downloads Download Rankings  
 0%
Total:772
This week:0
All time:4,209
This week:1,099Up