Baabu Posted March 5, 2008 Share Posted March 5, 2008 <?php #PHP CODE $host = 'localhost'; $dbuser = 'baabu'; $dbpword = 'pass'; $dbname = 'shop'; $backupFile = date("Y-m-d") . ".gz"; # Use system functions: MySQLdump & GZIP to generate compressed backup file $command = "mysqldump -h$host -u$dbuser -p$dbpword $dbname | gzip> $backupFile"; system($command); # Start the download process $len = filesize($backupFile); header("Pragma: public"); header("Expires: 0"); header("Cache-Control: must-revalidate, post-check=0, pre-check=0"); header("Cache-Control: public"); header("Content-Description: File Transfer"); header("Content-Type: application/gzip"); header("Content-Disposition: attachment; filename=$filename;"); header("Content-Transfer-Encoding: binary"); header("Content-Length: ".$len); @readfile($backupFile); # Delete the temporary backup file from server unlink($backupFile); ?> well here is above code when i try to open up backup.php it starts downloading backup.php not the .gz file can anyone help me out in adding a backup function to my site Best Regards Baabu Link to comment https://forums.phpfreaks.com/topic/94438-backup-help-messed/ Share on other sites More sharing options...
s0c0 Posted March 5, 2008 Share Posted March 5, 2008 I know this doesn't exactly answer your question, but why not create a cronjob to do this? Link to comment https://forums.phpfreaks.com/topic/94438-backup-help-messed/#findComment-483647 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.