1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

PHP + JS - Ajax Database restore script :-)

Discussion in 'Programming' started by Acecool, Nov 3, 2008.

  1. #1
    Ok, I made a database restore script a while back (which I still have... script was around 5 files), and now by popular demand, an AJAX 1 file, 11kb, version...

    Check out the youtube demo:
    http://www.youtube.com/watch?v=dlTZYHkEKZA


    OR the high def - 55mb version...
    http://www.acecoolco.com/ajax_database_restore.avi


    Let me know if you guys are interested in this one.

    -Josh


    Config section at the top of the file:
    <?php
    /******************************************************************************
     * Author:	Josh 'Acecool' Moser
     * Script:	Ajax Database Restore Program
     *
     * Desc. :	This program will restore your database from a 1 file .sql
     *		Easily and efficiently...
     *
     * Why?  :	I wrote this program after restoring a 30mb database which took
     *		2 days by hand... I had to restore it again a month later due
     *		to moving servers and the 35mb sql file took 14 minutes!!!!
     */
    
    //
    // Variables - Configuration
    //
    $_cfg['db']['host'] = 'localhost'; 		// Database HOST
    $_cfg['db']['name'] = 'db_name';			// Database NAME
    $_cfg['db']['user'] = 'IwonderWhoYouAre';			// Database USERNAME
    $_cfg['db']['pass'] = 'thiscouldbeYOURpassword!!';			// Database PASSWORD
    
    $_cfg['restoredb']['wait'] = '1000'; 		// How long should we wait between RELOADING the page? In ms
    $_cfg['restoredb']['max_scan_lines'] = '400';	// What is the max amount of lines we can scan before giving up?
    $_cfg['restoredb']['queries_per_page'] = '2500';	// How many queries can we execute before we stop executing and reload to prevent overloading the server?
    $_cfg['restoredb']['show_queries'] = 0;		// Show the queries on the page? (EXTREMELY SLOW, lots of output)
    
    error_reporting(E_ALL);				// Lets display ALL ERRORS
    set_time_limit('30');				// How many seconds do we want to let the script run before the server says you've had enough?
    ini_set('max_execution_time', '30');		// How many seconds do we want to let the script run before the server says you've had enough?
    PHP:
     
    Acecool, Nov 3, 2008 IP
  2. qualityhostings

    qualityhostings Well-Known Member

    Messages:
    1,764
    Likes Received:
    9
    Best Answers:
    0
    Trophy Points:
    105
    #2
    Is it still available ?
     
    qualityhostings, Feb 18, 2009 IP