Backup and Restore MySQL Database with PHP

Just as note to self:

For Backup:

<?PHP

$dump_path = "/usr/bin/"; //input location for the backup to be saved

$host = "localhost"; //db host e.g.-localhost

$user = "root"; //user e.g.-root

$pass = ""; //your mysql passwprd

$dbname = "fauzi-www"; //database name

$command= $dump_path . 'mysqldump -h' . $host . ' -u' . $user . ' -p' . $pass . ' ' . $dbname . ' > ' . $dbname . '.sql';

shell_exec($command);

For Restore:

<?PHP

$dump_path = "/usr/bin/"; //your backup location

$host = "localhost"; //db host e.g.-localhost

$user = "root"; //user e.g.-root

$pass = ""; // your mysql passwprd

$dbname = "fauzi-www"; //database name

$command = $dump_path . 'mysql -h' . $host . ' -u' . $user . ' -p' . $pass . ' ' . $dbname . ' < ' . $dbname . '.sql';

shell_exec($command);