HOWTO Execute SQL File from PHP Script To Create a DB ?

kumschick

Hi all,

How do I create a new DB from PHP
and then install run the SQL file so that the DB will be field.

spighita

http://us2.php.net/manual/en/function.mysql-create-db.php

kumschick

No, what I want to do is:

$link = mysql_connect("$db_hostname");
if (! $link)
die("Couldn't connect to MySQL");
mysql_create_db("$db_default");
mysql_close($link);

mysql_query("mysql -u $db_username -p $db_password $db_default < install.sql");

but it doesn't work! 😕