So I have the file db.sql, and its only a few kilobytes, so very small, but I can't figure out how I would import it in to my database through a PHP script. I tried some code that broke it up query by query but it did not get fully imported.

thanks

use phpMyAdmin. It should be available from your control panel.

that would work to import my database, but I am writing an install script, so i need to know how to do this in php code

Hello melefire...

I don't know if this is much help, but I thought I'd try and help out at a chance it was. I've used it with CSVs and hopefully you can use it for SQL.

Check out this page

http://dev.mysql.com/doc/refman/5.1/en/load-data.html

I managed to load a CSV file into MySQL really easily with this so it might be your way forward. That said someone who knows their stuff might dive in with something better... either way I hope this has been of some use!

Regards,

Leonard

PS... The query string I used was...
"LOAD DATA LOCAL INFILE './$filename' INTO TABLE $dbtable FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n'"

simply use a command line

PHP Code:

$run="mysql -u $user -p$password $db < file.sql";
exec($run); 


Looking in the comment on the php manual, I've seen this: http://www.php.net/manual/en/functio...uery.php#85876
As far as I know, it reads the sql file and sends the query one after the other, but should be able to cope with multilines statements.
It could be worth a try.

thanks for the help, but on my server the exec command is disabled. Also i tried out that function you mentioned and it didn't work.

just put the queries into strings and call them with mysql_query($command_string)