restore backup file in phpmyamdin database

i have a backup file (.sql) through this code

<?php
backup_tables('localhost','username','password','dbname');


/* backup the db OR just a table */
function backup_tables($host,$user,$pass,$name,$tables = '*')
{
    
    $link = mysql_connect($host,$user,$pass);
    mysql_select_db($name,$link);
    
    //get all of the tables
    if($tables == '*')
    {
        $tables = array();
        $result = mysql_query('SHOW TABLES');
        while($row = mysql_fetch_row($result))
        {
            $tables[] = $row[0];
        }
    }
    else
    {
        $tables = is_array($tables) ? $tables : explode(',',$tables);
    }
    
    //cycle through
    foreach($tables as $table)
    {
        $result = mysql_query('SELECT * FROM '.$table);
        $num_fields = mysql_num_fields($result);
        $return.= 'DROP TABLE IF EXISTS '.$table.';';
        $rtg=mysql_query('SHOW CREATE TABLE '.$table);
        $row2 = mysql_fetch_row($rtg);
        $return.= "\n\n".$row2[1].";\n\n";
        
        for ($i = 0; $i < $num_fields; $i++)
        {
            while($row = mysql_fetch_row($result))
            {
                $return.= 'INSERT INTO '.$table.' VALUES(';
                for($j=0; $j<$num_fields; $j++)
                {
                    $row[$j] = addslashes($row[$j]);
                    $row[$j] = ereg_replace("\n","\\n",$row[$j]);
                    if (isset($row[$j])) { $return.= '"'.$row[$j].'"' ; } else { $return.= '""'; }
                    if ($j<($num_fields-1)) { $return.= ','; }
                }
                $return.= ");\n";
            }
        }
        $return.="\n\n\n";
    }
    
    //save file
    $handle = fopen(date("d-m-Y").'.sql','w+');
    fwrite($handle,$return);
    fclose($handle);
}?> 

PHP:

i want a restore function if i click restore button then backup file restore in my phpmyadmin database..........

 

You can use "import" function of phpmyadmin. Or (for huge backup files) try to use mysqldumper

 

Try to import the .sql file using the Import function in phpmyadmin. If that doesnt work try mysqldumper.

 

try bigdump its best

 

here is a tutorial explaining how import/export sql files in phpmyadmin:

http://www.spotht.com/2010/04/how-to-importexport-mysql-databases-in.html

 

thanx for reply

 

I could also suggest using navicat with privilages enabled for your ip address. Then you can upload it from your desktop directly