How do I import a .sql file in mysql database using PHP?

by

Warning: mysql_* extension is deprecated as of PHP 5.5.0, and has been removed as of PHP 7.0.0. Instead, either the mysqli or PDO_MySQL extension should be used. See also the MySQL API Overview for further help while choosing a MySQL API.
Whenever possible, importing a file to MySQL should be delegated to MySQL client.

I have got another way to do this, try this

<?php

// Name of the file
$filename="churc.sql";
// MySQL host
$mysql_host="localhost";
// MySQL username
$mysql_username="root";
// MySQL password
$mysql_password = '';
// Database name
$mysql_database="dump";

// 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";
?>

This is working for me

More Related Contents:

  1. Comma separated numeric values – PHP CodeIgniter
  2. php+mysql Fatal error: Call to undefined function mysql_connect()
  3. Using PHP data in MySQL [closed]
  4. Checking the availability of rooms
  5. How to sort user data by id
  6. Select those record only from table 1 where city exist against state id in table 2 in PHP
  7. PHP PDO prepared statements
  8. Example of how to use bind_result vs get_result
  9. mysqli::query(): Couldn’t fetch mysqli
  10. select count(*) from table of mysql in php
  11. Why I am getting Cannot pass parameter 2 by reference error when I am using bindParam with a constant value?
  12. Loading .sql files from within PHP
  13. Incorrect Integer (2147483647) is inserted into MySQL?
  14. I need my PHP page to show my BLOB image from mysql database
  15. jQuery UI Sortable, then write order into a database
  16. Cannot connect to MySQL 4.1+ using old authentication
  17. Special characters in PHP / MySQL
  18. Fetching single row, single column with PDO
  19. MySQL db question marks instead of hebrew characters..?
  20. “Warning: Cannot modify header information – headers already sent by” error [duplicate]
  21. mysql_num_rows() expects parameter 1 to be resource, boolean given in [duplicate]
  22. How I can create installer for website. PHP mysql [closed]
  23. “No such file or directory” or “No such host is known” when running migrations
  24. How to join two tables with ssp.class.php
  25. How to convert IPv6 from binary for storage in MySQL
  26. Eloquent many-to-many-to-many – how to load distant relation easily
  27. Backup a mysql database and download as a file
  28. MYSQL select a piece of a string and order by that piece
  29. Is a BLOB converted using the current/default charset in MySQL?
  30. PHP/MySQL Pagination

Leave a Comment