we can create backup using mysql interface that is phpmyadmin. But we can create a customize interface to data backup using create simple line of code <?php if(isset($_POST['submit'])) { shell_exec(‘C:\xampp\mysql\bin\mysqldump.exe ‘.$_POST['dbname'].’ –user=root –password= >c:\\’.$_POST['dbname'].’.sql’) ; } ?> <body> <form name=”mysql” method=”post”> <div> <table> <tr> <td>Database Name</td><td><input type=”text” name=”dbname”></td> </tr> <tr><td><input type=”submit”  name=”submit” value=”Backup”></td><td></td> </tr> </table> [...]