Makesetup script of mysql databse adn domain in mysql to work

Hi I have made a script for creating and updatiing a database that works fine when I run it as php, but when I run it using Cron on Centos64bit it fails.

The scritp fails when it should update the database, it creates it and it all looks ok but the update of the databse does not work.

Please help me.

<?PHP

$dbh=mysql_connect ("localhost", "Database ID",

"DBPASW") or die('Cannot connect to the database because: ' . mysql_error());

$db=mysql_select_db ("DB");

? $sel_domains="select * from domains where database_setup = '0' limit 0,10";

$res_domains=mysql_query($sel_domains) or die(mysql_error());

while ($row_domains=mysql_fetch_array($res_domains))

{

$cmd="nohup mysql -u PREFIX_".strtolower($row_domains[username])." -pDBPASW PREFIX_".strtolower($row_domains[db]) ." < [url removed, login to view]" ;

?

//passthru("nohup mysql -u user -pDBPASW name < [url removed, login to view]");

passthru($cmd);

sleep(15);

$upd_domain="update domains set database_setup = 1 where id = ".$row_domains[id];

mysql_query($upd_domain);

//passthru("nohup mysql -u user -pDBPASW name < [url removed, login to view]");

}

echo "Database Setup Cron run";?>

Engineering Linux MySQL PHP Project Management Software Architecture Software Testing User Interface / IA

Project ID: #2828475

About the project