executing a dump.sql file with php

[ninjured]

hi guys,
Is there an easy way to execute a mysql dump located in the same directory as the php file on unix?

[RonPK]

Hi there ninjured, welcome to WebmasterWorld!

You can run shell commands from a PHP script with commands like exec() and system(). Check the manual to find out which one is right for you.

I'm not 100% sure of the syntax, but something like this might work:
<?php
exec("mysql -u [username] -p[password] -D [database] < dump.sql");
?>