I am using oracle as database. The script files are maintained in sql file.
I have to execute these sql script from PHP.
Through sqlplus, we can easily run the script like:
Code: Select all
@c:\test.sql;
Thanks
Moderator: General Moderators
Code: Select all
@c:\test.sql;
Code: Select all
$dbhost = 'localhost';
$dbuser = 'root';
$dbpass = 'password';
$db = 'test';
$file ='/tmp/file_restore.sql';
if ($dbpass != '') {
$cmd = '/usr/bin/mysql -h '.$dbhost.' -u '.$dbuser.' -p
'.$dbpass.' < '.$file;
exec($cmd,$out,$retval);
} else {
$cmd = '/usr/bin/mysql -h '.$dbhost.' -u '.$dbuser.' < '.$file;
exec($cmd,$out,$retval);
}