WPDB SQL File import

sql_import.php

<?php
/* NOTICE
 * This script imports SQL commands "as is". 
 * Double check the SQL commands before using it
 * and BACKUP YOUR DATABASE.
 * It needs some improvement to use wpdb->prepare.
 */
class WPSQLImporter{
    /**
     * Loads an SQL stream into the WordPress database one command at a time.
     *
     * @params $sqlfile The file containing the mysql-dump data.
     * @return boolean Returns true, if SQL was imported successfully.
     * @throws Exception
     */
    public static function importSQL($sqlfile){    
	//load WPDB global
	global $wpdb;
        // read file into array
        $file = file($sqlfile);
		// import file line by line
        // and filter (remove) those lines, beginning with an sql comment token
        $file = array_filter($file,
                        create_function('$line',
                                'return strpos(ltrim($line), "--") !== 0;'));
       // and filter (remove) those lines, beginning with an sql notes token
        $file = array_filter($file,
                        create_function('$line',
                                'return strpos(ltrim($line), "/*") !== 0;'));
        $sql = "";
        $del_num = false;
		
        foreach($file as $line){
            $query = trim($line);
            try
            {
                $delimiter = is_int(strpos($query, "DELIMITER"));
                if($delimiter || $del_num){
                    if($delimiter && !$del_num ){
                        $sql = "";
                        $sql = $query."; ";
                        echo "OK";
                        echo "<br/>";
                        echo "---";
                        echo "<br/>";
                        $del_num = true;
                    }else if($delimiter && $del_num){
                        $sql .= $query." ";
                        $del_num = false;
                        echo $sql;
                        echo "<br/>";
                        echo "do---do";
                        echo "<br/>";
                        $wpdb->query($sql);
                        $sql = "";
                    }else{                            
                        $sql .= $query."; ";
                    }
                }else{
                    $delimiter = is_int(strpos($query, ";"));
                    if($delimiter){
                        $wpdb->query("$sql $query");
                        echo "$sql $query";
                        echo "<br/>";
                        echo "---";
                        echo "<br/>";
                        $sql = "";
                    }else{
                        $sql .= " $query";
                    }
                }
            }
            catch (\Exception $e)
            {
                echo $e->getMessage() . "<br /> <p>The sql is: $query</p>";
            }
            
        }
    }
}
?>

Hi
The below code worked form me after i use export in phpmyadmin and reset the database.
Thank you very much for being inspiration of what i was looking for.
`
function myImportSql($sqlfile){
$file = file($sqlfile);
// import file line by line
// and filter (remove) those lines, beginning with an sql comment token
$file = array_filter($file,
create_function('$line',
'return strpos(ltrim($line), "--") !== 0;'));
// and filter (remove) those lines, beginning with an sql notes token
$file = array_filter($file,
create_function('$line',
'return strpos(ltrim($line), "/*") !== 0;'));

                global $wpdb;

                    $command = '';
                    foreach($file as $line){
                    $command .= trim($line);
                    if(empty($command)){
                        continue;
                    }
                    $is_last_character_delimiter = $command[(strlen($command)-1)] === ';';
                    if(!$is_last_character_delimiter){
                        continue;
                    }
                        $wpdb->query( $command );
                        if($wpdb->last_error){
                            echo "<br>";
                            echo "error". $wpdb->last_error;
                            echo "<br>";
                        }
                    $command = '';
                }
        }

`