mysql import

mysql_import.php

<?php
try {
    if (! @include_once( './data/install.php' )) {
      throw new Exception ('install.php does not exist');
    }
    if (!file_exists('./data/install.php' )) {
      throw new Exception ('install.php does not exist');
    } else {
      require_once('./data/install.php' );
    }
} catch(Exception $e) {
    exit('Couldn\'t found data/install.php file.');
}
if (empty($argv[1])) {
    exit('Please choose a sql file');
}
$sqlFile = $argv[1];

// Connect to MySQL server
$connection = mysqli_connect(DB_SERVER, DB_USER, DB_PASSWORD, DB_NAME) or exit('Error connecting to MySQL server: ' . mysqli_error());
// Temporary variable, used to store current query
$tmpLine = '';
// Read in entire file
$lines = file($sqlFile);
// Loop through each line
foreach ($lines as $line) {
    // Skip it if it's a comment
    if (substr($line, 0, 2) == '--' || $line == '') {
        continue;
    }

    // Add this line to the current segment
    $tmpLine .= $line;

    // If it has a semicolon at the end, it's the end of the query
    if (substr(trim($line), -1, 1) == ';') {
        // Perform the query
        mysqli_query($connection, $tmpLine) or print('Error performing query ' . $tmpLine . ': ' . mysqli_error($connection));
        // Reset temp variable to empty
        $tmpLine = '';
    }
}
echo 'Tables imported successfully';
exit(0);