$begintime = time(); echo "Creating new binaries, and parts tables for each active group...\n"; foreach ($actgroups as $group) { if ($groups->createNewTPGTables($group['id']) === false) { exit($pdo->log->error("There is a problem creating new parts/files tables for group {$group['name']}.")); } $consoletools->overWrite("Tables Created: " . $consoletools->percentString($gdone * 3, $newtables)); $gdone++; } $endtime = time(); echo "\nTable creation took " . $consoletools->convertTime($endtime - $begintime) . ".\n"; $starttime = time(); echo "\nNew tables created, moving data from old tables to new tables.\nThis will take awhile....\n\n"; while ($bdone < $blen['total']) { // Only load 1000 binaries per loop to not overload memory. $binaries = $pdo->queryAssoc('SELECT * FROM binaries LIMIT ' . $bdone . ',1000;'); if ($binaries instanceof \Traversable) { foreach ($binaries as $binary) { $binary['name'] = $pdo->escapeString($binary['name']); $binary['fromname'] = $pdo->escapeString($binary['fromname']); $binary['date'] = $pdo->escapeString($binary['date']); $binary['binaryhash'] = $pdo->escapeString($binary['binarynhash']); $binary['dateadded'] = $pdo->escapeString($binary['dateadded']); $binary['xref'] = $pdo->escapeString($binary['xref']); $binary['releaseid'] = $pdo->escapeString($binary['releaseid']); $binary['categoryid'] = $pdo->escapeString($binary['categoryid']); $binary['totalparts'] = $pdo->escapeString($binary['totalparts']); $binary['relpart'] = $pdo->escapeString($binary['relpart']); $binary['reltotalpart'] = $pdo->escapeString($binary['reltotalpart']); $oldbid = array_shift($binary); if ($debug) {