Login   Register  
PHP Classes
elePHPant
Icontem

File: README.txt

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Classes of Aziz S. Hussain  >  Multi Threaded MySQL Backup and Restore Daemon  >  README.txt  >  Download  
File: README.txt
Role: Documentation
Content type: text/plain
Description: Readme and Instructions
Class: Multi Threaded MySQL Backup and Restore Daemon
Backup multiple MySQL tables in parallel
Author: By
Last change:
Date: 2012-07-24 19:21
Size: 1,173 bytes
 

Contents

Class file image Download
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