[Resolved] .sql parser

[ucbones]

Hi,

I have various dumps that I've generated from a MySQL db, one with table structure, one with data.

Does anyone know of a parser that will run through the files and send the individual queries? Save me writing one!

I'm aware of the phpMyAdmin solution and the exec solution (couldn't get the latter to work, the former doesn't really work in this situation).

Cheers,

Dom

[devinemke]

Originally posted by ucbones
I'm aware of the phpMyAdmin solution and the exec solution (couldn't get the latter to work, the former doesn't really work in this situation).

what it wrong with using phpMyAdmin?

[ucbones]

Partially laziness, partially tidiness. I'm writing a script that installs the CMS I've been writing, and I'd quite like it if it did all the database stuff as well.

[ucbones]

function mysql_parse_file($filepath,$fordbname,$indbname){
	mysql_select_db($fordbname);
	if (!file_exists($filepath)){
		mysql_select_db($indbname);
		return false;
	}
	$queries=file_to_queries($filepath);
	if (count($queries) > 0){
		foreach($queries as $query){
			if (!mysql_query($query)){
				echo mysql_error();
				mysql_select_db($indbname);
				return false;
			}
		}
	}

return true;
}
function file_to_queries($filepath){
	$database=file($filepath);
	$queries=array();
	for ($i=0; $i<count($database); $i++){
		$database[$i]=trim($database[$i]);
		if (strpos($database[$i],"#") === 0){
		}
		else {
			if (strlen($database[$i]) != 0){
				$queries[$k].=$database[$i];
				if (strpos(strrev($database[$i]),";") === 0){
					$k++;
				}
			}
		}
	}
	return $queries;
}

Did it myself! Not foolproof, but works well enough for me!