How to Import .sql file via PHP?

Hello,

I would like to ask, what command to use in order to upload .sql file to the database using php.

Thank You in advance

 

Just use http://www.ozerov.de/bigdump.php

 

I am going to use a cronjob to run my php script, so bigdump is not proper for me

 

Well bigdump uses get to import a file ... its in such a format bigdump.php?start=1&fn=wrdp1.sql.gz so u can call it using cron

Otherwise try this

if (mysql_query("SOURCE file.sql")) {
echo "success";
}

 

Thanks Bohra. Great tip with bigdump Everything worked like a sharm

 

Kool Glad i could help