PHP Classes
Icontem

Class: Large Database Backup


  Search   All class groups All class groups   Latest entries Latest entries   Top 10 charts Top 10 charts   Newsletter Newsletter   Blog Blog   Forums Forums   Help FAQ Help FAQ  
  Login   Register  
Recommend this page to a friend!
      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: 167
    Week rank: 51

    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 Databases Database management, accessing and searching View top rated classes
    Group folder image Systems administration 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: 90.44 (0.15%)
    Popularity rank: 29,440 (PHP Classes: 217)
    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%)
    378
    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 Advertise on this site   Site map Site map   Statistics Statistics   Site tips Site tips   Privacy policy Privacy policy   Contact 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