Just as note to self:
For Backup:
1 2 3 4 5 6 7 8 9 |
<?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:
1 2 3 4 5 6 7 8 9 |
<?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); ?> |