mysql - restore backup mysqldump php -

mysql - restore backup mysqldump php -

i can't seem restore database backup in php. code

<?php $host = 'localhost'; $user = 'root'; $pass = ' '; $dbname = 'itravel'; date_default_timezone_set('asia/kuala_lumpur'); $date = date('y_m_d'); if(isset($_post['backup'])) { $backup = "c:/xampp/mysql/bin/mysqldump --opt -h $host -u $user $dbname > itravel_backup_$date.sql"; system($backup); } if(isset($_post['restore'])) { $restore = "c:/xampp/mysql/bin/mysqldump --opt -h $host -u $user $dbname < itravel_backup_$date.sql"; system($restore); } ?>

backup successful restore failure. help me guys!

updated code with

<?php $host = 'localhost'; $user = 'root'; $pass = ' '; $dbname = 'itravel'; //date_default_timezone_set('asia/kuala_lumpur'); //$date = date('y_m_d'); $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/mysqldump --opt -h $host -u $user $dbname < itravel_backup_$date.sql"; //system($restore); $restore = "c:/xampp/mysql/bin/mysql --opt -h $host -u $user $dbname < $backup_name"; system($restore); } ?>

but still not working

you need utilize mysql binary restore, not mysqldump.

php mysql mysqldump