FrontAccounting forum — The Below code is not working to download sql file from server

Re: The Below code is not working to download sql file from server

null@example.com (kvvaradha) — Sun, 24 Sep 2017 06:19:31 +0000

I am trying to create sql backup and download it straight away for my extension(hrm). Which i am trying to use the FA backup codes.There it worked fine.But its not working properly.

Re: The Below code is not working to download sql file from server

null@example.com (apmuthu) — Sun, 24 Sep 2017 01:54:48 +0000

State where you are using this construct and context.

1. Remove pragma-cache
2. Set expiry for refresh to old date
3. Make sure file_get contents is within the max filesize and timeouts set in php.ini / apache conf files.
4. Zipping the sql will save bandwidth if http gz compression is not enabled.

View discussion.

The Below code is not working to download sql file from server

null@example.com (kvvaradha) — Sat, 23 Sep 2017 17:15:40 +0000

i was trying to download sql file using this script.But its not working

 header("Content-type: 'application/sql'");
            header('Content-Length: '.filesize(dirname(dirname(__FILE__)).'/backups/'.$key.'.sql'));
            header('Content-Disposition: attachment; filename='.$key.'.sql');
            echo file_get_contents(dirname(dirname(__FILE__)).'/backups/'.$key.'.sql');