Extracting all binary files from MySQL at one stroke!

Hi...All

I have been trying so long to extract all the binary files from MySQL database at one shot. I have this MySQL database that contains binary files inside BLOB data field. What I want to do is I want to retrieve all the files into my harddisk at one shot.

It can be in zip format or I specify a folder path then all the files are extracted to that folder. Can anybody tell me how to do this? I have been trying to figure out so long but still can't get the answer yet.

I tried to do looping after selecting all the files from database. the example is below. But after appearing the first download dialog box. The loop stops. Please suggest me how to slove the problem.

<?

     //Establish connection with database
     require_once("includes/db_connect.php");    
     
      $conn = db_connect();
 
     if (!$conn){
             echo "Could not connect to database server - please try later.";    
          exit;
     }
     
     $sql = "SELECT File,FileName,FileSize,FileType FROM File";
     
     $result = mysql_query($sql);
     
     if(!$result){
          echo "Error in retrieving files";
          exit;
     }
     
     //echo mysql_num_rows($result);
     //exit;
     
     for($i=0;$i < mysql_num_rows($result);$i++) {
     
     $data = mysql_result($result,0,"File");
     $name = mysql_result($result,0,"FileName");
     $size = mysql_result($result,0,"FileSize");
     $type = mysql_result($result,0,"FileType");


     header("Content-type: $type");
     header("Content-length: $size");
     header("Content-Disposition: attachment; filename= $name");
     header("Content-Description: PHP Generated Data");
     echo $data;
     
     }


?>

Thanks all.