PHP Ubuntu - Backup and Restore MySQl

Question

I follow this and it working well in Window

But when i run in ubuntu (13.10) and using xampp

<?php
$server     = "localhost";
$username   = "root";
$password   = "root";
$db = "test";
$restore_file   = "/home/myname/test.sql";
$cmd = "/opt/lampp/bin/mysql -h {$server} -u {$username} -p{$password} {$db} < $restore_file";
//umask(0);
exec($cmd);
echo "Restore complete!";
?>

it echo restore complete but database is empty. If i run script on terminal then it working.

How to fix that thanks

@Sadik it must be running because restore complete that show on browser — DeLe
– DeLe, Commented Mar 8, 2014 at 16:32
output is /opt/lampp/bin/mysql -h localhost -u root -proot test < /home/myname/test.sql — DeLe
– DeLe, Commented Mar 8, 2014 at 16:36

Harikrishnan · Accepted Answer · 2014-03-08 17:05:05Z

0

What is O/P?

<?php
        if(function_exists('exec')) {
        echo "exec function is enabled";
        }
        else {
        echo "exec is not enabled";
        }
  ?>

Edit
Execute this command in shell.

chmod +x /opt/lampp/bin/mysql

Edit

exec($cmd, $output, $return); 

echo $output;
if (!$return) {
    echo "Success";
} else {
    echo "Failed";
}

edited Mar 8, 2014 at 17:05

answered Mar 8, 2014 at 16:41

Harikrishnan

10k11 gold badges89 silver badges131 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

DeLe Over a year ago

output is exec function is enabled

dhidy Over a year ago

maybe its a permission issue.

DeLe Over a year ago

what are $output and $return variable?

Collectives™ on Stack Overflow

PHP Ubuntu - Backup and Restore MySQl

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related