Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 247
  • Last Modified:

Mysql dump without zip

I have this code from phpMySQLAutoBackup, its working, but I want the dump without the gz (zip).

Someone any idea how to do that?

Thanks

Here is the code I use: (part of the code, but the most important).
// zip the backup and email it
$backup_file_name = 'mysql_'.$db.strftime("_%d_%b_%Y_time_%H_%M_%S.sql",time()).'.gz';
$dump_buffer_not_zipped = $dump_buffer;
$dump_buffer = gzencode($buffer);
if ($from_emailaddress>"") xmail($to_emailaddress,$from_emailaddress, "phpMySQLAutoBackup: $backup_file_name", $dump_buffer, $backup_file_name, $backup_type, $newline);
if ($save_backup_zip_file_to_server) write_backup($dump_buffer_not_zipped, $backup_file_name);
 
//FTP backup file to remote server
if (isset($ftp_username))
{
 //write the backup file to local server ready for transfer if not already done so
 if (!$save_backup_zip_file_to_server) write_backup($dump_buffer, $backup_file_name);
 $transfer_backup = new transfer_backup();
 $transfer_backup->transfer_data($ftp_username,$ftp_password,$ftp_server,$ftp_path,$backup_file_name);
 if (!$save_backup_zip_file_to_server) unlink(LOCATION."../backups/".$backup_file_name);
}
?>

Open in new window

0
delphibeginner
Asked:
delphibeginner
  • 4
  • 3
1 Solution
 
flob9Commented:
This should work :
<?php
 
//$backup_file_name = 'mysql_'.$db.strftime("_%d_%b_%Y_time_%H_%M_%S.sql",time()).'.gz';
$backup_file_name_not_zipped = 'mysql_'.$db.strftime("_%d_%b_%Y_time_%H_%M_%S.sql",time()).'.sql';
$dump_buffer_not_zipped = $dump_buffer;
//$dump_buffer = gzencode($buffer);
if ($from_emailaddress>"") xmail($to_emailaddress,$from_emailaddress, "phpMySQLAutoBackup: $backup_file_name_not_zipped", $dump_buffer_not_zipped, $backup_file_name_not_zipped, $backup_type, $newline);
if ($save_backup_zip_file_to_server) write_backup($dump_buffer_not_zipped, $backup_file_name_not_zipped);
 
//FTP backup file to remote server
if (isset($ftp_username))
{
 //write the backup file to local server ready for transfer if not already done so
 if (!$save_backup_zip_file_to_server) write_backup($dump_buffer_not_zipped, $backup_file_name_not_zipped);
 $transfer_backup = new transfer_backup();
 $transfer_backup->transfer_data($ftp_username,$ftp_password,$ftp_server,$ftp_path,$backup_file_name_not_zipped);
 if (!$save_backup_zip_file_to_server) unlink(LOCATION."../backups/".$backup_file_name_not_zipped);
}
?>

Open in new window

0
 
flob9Commented:
sorry double sql extension line 4 :

$backup_file_name_not_zipped = 'mysql_'.$db.strftime("_%d_%b_%Y_time_%H_%M_%S.sql",time());
0
 
delphibeginnerAuthor Commented:
Thanks for the reply.

The problem now is that the size is 0.

When it's being zipped its a couple of kb's.

Why?
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
delphibeginnerAuthor Commented:
Found it.

The line:
$dump_buffer_not_zipped = $dump_buffer;

Needed to be:
$dump_buffer_not_zipped = $buffer;

Because $buffer is used in an other file, my bad didn't said that.
0
 
flob9Commented:
Oh, sorry.
0
 
delphibeginnerAuthor Commented:
Many thanks
0
 
delphibeginnerAuthor Commented:
Dont worry, I'll reward you the points
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now