Solved

Mysql dump without zip

Posted on 2009-07-15
7
213 Views
Last Modified: 2013-12-13
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
Comment
Question by:delphibeginner
  • 4
  • 3
7 Comments
 
LVL 14

Accepted Solution

by:
flob9 earned 50 total points
ID: 24861008
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
 
LVL 14

Expert Comment

by:flob9
ID: 24861024
sorry double sql extension line 4 :

$backup_file_name_not_zipped = 'mysql_'.$db.strftime("_%d_%b_%Y_time_%H_%M_%S.sql",time());
0
 
LVL 1

Author Comment

by:delphibeginner
ID: 24861816
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
Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

 
LVL 1

Author Comment

by:delphibeginner
ID: 24861863
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
 
LVL 14

Expert Comment

by:flob9
ID: 24862064
Oh, sorry.
0
 
LVL 1

Author Closing Comment

by:delphibeginner
ID: 31603820
Many thanks
0
 
LVL 1

Author Comment

by:delphibeginner
ID: 24862414
Dont worry, I'll reward you the points
0

Featured Post

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Password hashing is better than message digests or encryption, and you should be using it instead of message digests or encryption.  Find out why and how in this article, which supplements the original article on PHP Client Registration, Login, Logo…
3 proven steps to speed up Magento powered sites. The article focus is on optimizing time to first byte (TTFB), full page caching and configuring server for optimal performance.
The viewer will learn how to dynamically set the form action using jQuery.
The viewer will learn how to create a basic form using some HTML5 and PHP for later processing. Set up your basic HTML file. Open your form tag and set the method and action attributes.: (CODE) Set up your first few inputs one for the name and …

679 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question