How to import SQL file format with php

[slackman]

i has SQL file it's contain SQL Format and include data, how to impor to my database(restore database) to my local database,anyone show the sample source code for import database(assume you has username&password database and SQL data file)

[NogDog]

I believe you can use MySQL's SOURCE command:

mysql_query("SOURCE path/to/sqlfile.sql");