Client Side Download of MySQL database

Question

I use this codes to download MySQL Database on Server Side it works fine but I don't know how to download Database on Client Side, please help.

        include'connect.php';
    if(isset($_POST['download'])){

        $time = time();
        $current_date_time = date('d-m-Y@H-i-s', strtotime('+3 hours'));
        $backupFile = 'D://xampp//htdocs//development//ShahrajeTraders//backup//'.$database.'~'.$current_date_time.'.sql';
        $command = "D://xampp//mysql//bin//mysqldump.exe -h $host_name -u $user_name -p$user_pass $database > $backupFile";
        system($command);

        if($command){
            echo'
            <script>
                $(document).ready(function(){
                    alert("Download Completed.");   
                }); 
            </script>
            ';          
        }else{
            echo'               
            <script>
                $(document).ready(function(){
                    alert("Error During Downloading."); 
                }); 
            </script>
            ';
        }
    }

Duplicate btw: http://stackoverflow.com/questions/737045/send-a-file-to-client — Sumurai8, Sep 21 '13 at 11:27

Jens L. · Accepted Answer · 2013-09-21T13:41:02.857

You will need to point the browser to the URL of the backup file.

I assume that you already sends content to the browser (say, you do echo calls before this code), so a possibility would be to set a location to the client (browser) with JavaScript.

In your case it could look like this

if($command){
        echo'
        <script>
            $(document).ready(function(){
                window.location="/development/ShahrajeTraders/backup/'.$database.'~'.$current_date_time.'.sql";
            }); 
        </script>
        ';          
    }else{
        echo'               
        <script>
            $(document).ready(function(){
                alert("Error During Downloading."); 
            }); 
        </script>
        ';
    }

I don't know the configuration of your web server, so you will need to adjust the URL in the code.

Client Side Download of MySQL database

1 Answers1