Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- error_reporting(E_ALL);
- // Name of the file
- $filename = 'matchme.sql';
- // MySQL host
- $mysql_host = 'localhost';
- // MySQL username
- $mysql_username = 'condor5_root';
- // MySQL password
- $mysql_password = 'K3s7NRIP0V-@';
- // Database name
- $mysql_database = 'condor5_matchme';
- // Connect to MySQL server
- mysql_connect($mysql_host, $mysql_username, $mysql_password) or die('Error connecting to MySQL server: ' . mysql_error());
- // Select database
- mysql_select_db($mysql_database) or die('Error selecting MySQL database: ' . mysql_error());
- mysql_query("DROP DATABASE condor5_matchme");
- mysql_query("CREATE DATABASE condor5_matchme");
- // Connect to MySQL server
- mysql_connect($mysql_host, $mysql_username, $mysql_password) or die('Error connecting to MySQL server: ' . mysql_error());
- // Select database
- mysql_select_db($mysql_database) or die('Error selecting MySQL database: ' . mysql_error());
- // Temporary variable, used to store current query
- $templine = '';
- // Read in entire file
- $lines = file($filename);
- // 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
- $templine .= $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
- mysql_query($templine) or print('Error performing query \'<strong>' . $templine . '\': ' . mysql_error() . '<br /><br />');
- // Reset temp variable to empty
- $templine = '';
- }
- }
- echo "Tables imported successfully";
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement