restoring database php

[arukiri]

i can't seem to restore my database backup in php. this is my code

 

<?php

$host = 'localhost';

$user = 'root';

$pass = ' ';

$dbname = 'itravel';

$backup_name = 'itravel_backup.sql';

if(isset($_POST['backup']))

{

$backup = "c:/xampp/mysql/bin/mysqldump --opt -h $host -u $user $dbname > $backup_name";

system($backup);

}

 

if(isset($_POST['restore']))

{

$restore = 'c:/xampp/mysql/bin/mysql -u $user --p $pass $dbname < $backup_name';

system($restore);

}

?>

 

backup was successful but the restore was a failure. help me guys!

[Christian F.]

Run the restore command manually, and it should tell you why.

 

Also, if you haven't done so already: Turn on error reporting. Without error messages no-one can do anything about your problem, as no-one really knows what the problem actually is.

[arukiri]

how to do it manually? i am using phpmyadmin. please help