Solved

Mysql dump without zip

Posted on 2009-07-15
7
207 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
Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

 
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

Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

Suggested Solutions

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‚Ķ
Since pre-biblical times, humans have sought ways to keep secrets, and share the secrets selectively.  This article explores the ways PHP can be used to hide and encrypt information.
The viewer will learn how to dynamically set the form action using jQuery.
This tutorial will teach you the core code needed to finalize the addition of a watermark to your image. The viewer will use a small PHP class to learn and create a watermark.

705 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

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now