sub fix_file_4mysql {    #arguments: 1) path to file
	        #returns: 1) the filename fixed for use in a mysql query

	#fix the contents of the temp file for use in mysql
	my $tmp_filename = shift;
	
        open( IN, "+<$tmp_filename" );
	my @file = <IN>;
	seek IN, 0, 0;
	foreach my $file (@file) {
		$file =~ s/\\/\\\\/g;
		print IN $file;
	}
	close IN;

	#fix temp_filename for use in mysql
	my $mysql_tmp_filename = $tmp_filename;
	$mysql_tmp_filename =~ s/\\/\\\\/g;

	return $mysql_tmp_filename;
}