mysql import sql file

mysql -u username -p database_name < file.sql

 mysql> use db_name;
 mysql> source file_name.sql;

mysql -u username -p database_name < file.sql
; OR
 mysql> use db_name;
 mysql> source file_name.sql;

mysql>create database yourDatabaseName;
mysql>use yourDatabaseName;

Source : https://www.programmingquest.com/2018/08/how-to-export-mysql-database-using.html
open cmd
set mysql path in cmd
	set path=c:\wamp\bin\mysql\mysql5.6.17\bin
For database import (Restore): 
	mysql -u YourUser -p YourDatabaseName < filename.sql

zcat /path/to/file.sql.gz | mysql -u 'root' -p your_database

<?php
$conn =new mysqli('localhost', 'root', '' , 'blog_samples');

$query = '';
$sqlScript = file('database-script.sql');
foreach ($sqlScript as $line)	{
	
	$startWith = substr(trim($line), 0 ,2);
	$endWith = substr(trim($line), -1 ,1);
	
	if (empty($line) || $startWith == '--' || $startWith == '/*' || $startWith == '//') {
		continue;
	}
		
	$query = $query . $line;
	if ($endWith == ';') {
		mysqli_query($conn,$query) or die('<div class="error-response sql-import-response">Problem in executing the SQL query <b>' . $query. '</b></div>');
		$query= '';		
	}
}
echo '<div class="success-response sql-import-response">SQL file imported successfully</div>';
?>