Hello, I am trying to run a .sql script produced with mysql-dump from a php script but failed to find a rudimentary robust solution yet. mysql_query() can only run one query at a time. Thus its necessary to somehow parse the input file and separate the queries... which is difficult since the syntax can be quite complex. So far I managed to run most CREATE TABLE and INSERT queries just by dropping newlines (\n) and explode()ing the input by ';'. Now I am stuck with a CREATE TRIGGER statement because mysql-dump does this: === DELIMITER ;; CREATE TRIGGER ... ON ... FOR EACH ROW BEGIN ... ... END; ;; DELIMITER ; === exploding that string by ';' results in 4 (or more) queries which are invalid syntax then. And I have no glue on what else mysql-dump may come up with on other occasions. does anyone know how to do that properly? I dont favor importing the dumps via shell command like 'cat some.dump | mysql' either. stephan -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
