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: