<?php
echo "Initializing... <br>\n";
echo "*************** <br>\n";
$server = "localhost:3306";
$username = "root";
$password = "";
$mysql_connection = mysql_connect($server, $username, $password);
if (!$mysql_connection)
{
    die ('Could not connect to mysql'.mysql_error());
}
else
{
    echo "Connection MySQL established.<br>\n";
}
$mysql_database = mysql_select_db('midgard_test',$mysql_connection);
if (!$mysql_database)
{
    die ('Could not connect to database'.mysql_error());
}
{
    echo "Database selected successfully! <br>\n";
}

$filename = 'wicom-sql-statements.txt';
$sql_statements = file($filename);
echo "File read... <br>\n";

$counter = 0;
$total_counter = 0;
foreach ($sql_statements as $line)
{
    $counter++;
    $total_counter++;
    if ($counter == 50)
    {
        echo "*****<br>\n";
        echo "Counter hit 50 - SLEEPING for 5 seconds <br>\n";
        echo "*****<br>\n";
        sleep(5);
        $optimize = mysql_query('OPTIMIZE TABLE record_extension');
        if (!$optimize)
        {
            echo "Could not optimize... <br>\n";
        }
        else
        {
            echo "Table optimized. <br>\n";
        }
        $counter = 0;
        echo "Counter RESET<br>\n";
        echo "*****<br>\n";
    }
    echo "[".$total_counter."/8646] Line read.<br>\n";
    $query = mysql_query($line);
    if (!$query)
    {
        die('ERROR, COULD NOT SUBMIT QUERY'.mysql_error());
    }
    usleep(100000);
}

echo "<br>\n*****<br>\n";
echo "We are done here <br>\n";
echo "*****<br>\n";
fclose($file);
$mysql_close_connection = mysql_close($mysql_connection);
if (!$mysql_close_connection)
{
    die('Could not close MySQL connection');
}
else
{
    echo "MySQL connection closed! <br>\n";
}
?>