PHP Developer's Network : Network Member Forums

Class: Large Database Backup



  Search   All class groups   Latest entries   Top 10 charts   Newsletter   Blog   Forums   Help FAQ  
  Login   Register  
Recommend this page to a friend! Trackback URL: http://www.phpclasses.org/trackback/browse/package/4017.html
      Classes of Nadir Latif  > 
Large Database Backup
 >  Download  >  Support forum Support forum  >  RSS 1.0 feed RSS 2.0 feed Latest changes  >  Stumble It! Stumble It!  >  Bookmark in del.icio.us Bookmark in del.icio.us  
  Supplied by   Group folder image Groups   Detailed description   Freshmeat project  
  Rate classes User ratings   Trackback   Applications   Files Files  
  • Supplied by:

  • Picture of Nadir Latif
    Name: Nadir Latif is available for providing paid consulting. Contact Nadir Latif .
    Published packages: 10
    Country: Sweden Sweden - PHP jobs in Sweden
    Home page: ???
    Age: 25
    All time rank: 201
    Week rank: 14

    Browse this author's classes

  • Innovation Award:

  • PHP Programming Innovation award nominee
    July 2007
    Number 2
    There are many pure PHP solutions for taking backup copies of MySQL databases.

    Most solutions are suitable to run on restricted PHP hosting environments. However, if you have a large database it may take more time to create a backup copy than the default 30 second PHP script execution time limit. The backup process may not finish before the script is aborted.

    This class provides a clever solution that avoids that problem. It splits the backup process into multiple steps, each extracting a limited number of table rows. This way, each step may take less time than the PHP execution time limit.

    Manuel Lemos
  • Groups:

  • Group folder image
    Database management, accessing and searching
    View top rated classes
    Group folder image
    System configuration and management
    View top rated classes
  • Detailed description:

  • This class can be used to backup large MySQL databases into multiple files.

    It can list the tables of a given MySQL database and generate SQL statements to create and insert records with the current values of the table rows, as if it was creating a new database. The class stores the generated SQL statements in files.

    A full backup process can be split in multiple iterations to not exceed PHP default script execution time limit. Each iteration dumps a limited number of table rows. An iteration can be executed by a script that redirects the page request to itself at the end to proceed to the next iteration.
  • Freshmeat project:

  • Project record: database_backup
    Popularity score: 86.02 (0.14%)
    Popularity rank: 29,909 (PHP Classes: 218)
    Vitality score: 1.00 (0.00%)
    Rating: Not yet rated Please rate this class in Freshmeat
  • User ratings:

  • Ratings
    Utility
    Consistency
    Documentation
    Examples
    Tests
    Videos
    Overall
    Rank
    All time:
    Good (80.0%)
    Good (85.0%)
    Good (85.0%)
    Sufficient (70.0%)
    -
    -
    Sufficient (64.0%)
    370
    Month:
    Not yet rated by the users
  • Trackback links:

  • Link Description
    MySQL Copy Table from One Database to Another
    Sometime in MySQL you want to copy an entire table from one database to a separate database...
    Latest blog trackback links Latest blog trackback links
  • Applications that use this class:

  • No application links were specified for this class.
    Add link image If you know an application of this package, send a message to the author to add a link here.
  • Files:

  • File Role Description
    Plain text file connection_details.csv Data
    Contains configuration details
    Plain text file db_backup.php Example
    sample file
    Plain text file mysql_backup.php Class
    Contains all functions
    Plain text file readme.txt Doc.
    Help file
    Plain text file backup_details.csv Data
    Data file
    Download all files: backupmysql.tar.gz backupmysql.zip
    NOTICE: if you are using a download manager program like 'GetRight', please Login before trying to download this archive.

 
  Advertise on this site   Site map   Statistics   Site tips   Privacy policy   Contact  

For more information send a message to :
info at phpclasses dot org.
Copyright (c) Icontem 1999-2008 PHP Classes - PHP Class Scripts
  PHP Book Reviews - Reviews of books and other products