function archive_lmt_db($uname, $passw, $yrfrom, $yrto) { $yrfrom = intval($yrfrom); $yrto = intval($yrto); //Reconnect with the new username/password with more privileges $adminDB = new MeekroDB(NULL, $uname, $passw); //create new db //probably triggers error if already exists $adminDB->query("CREATE DATABASE `lmt-{$yrfrom}` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci"); $adminDB->useDB('lmt-' . $yrfrom); //copy db info to new db //This can be done dynamically using SHOW TABLES but this is easier. $tables = array('guts', 'individuals', 'map', 'pages', 'schools', 'teams'); foreach ($tables as $table) { $adminDB->query("CREATE TABLE `lmt-{$yrfrom}`.`{$table}` LIKE `lmt`.`{$table}`"); $adminDB->query("INSERT `lmt-{$yrfrom}`.`{$table}` SELECT * FROM `lmt`.`{$table}`"); } //truncate necessary fields in LMT db, since it's already archived. $tables_truncate = array('guts', 'individuals', 'schools', 'teams'); foreach ($tables_truncate as $table) { $adminDB->query("TRUNCATE TABLE `lmt`.`{$table}`"); } }