106 replies to this topic

[Jan Zonjee]

lightshine, on Feb 18 2009, 08:09 AM, said:

It show this error message "compression tooling '/usr/bin/gzip' not found" on the page when i press on the backup button on the backup website area.

Either the path set in LOCAL_EXE_GZIP (I think it is in application_top.php) is wrong or you can't use it at all because it is not there. The contribution also can use it's own files for gzipping a file. It is in there as a function.

[lightshine]

Jan Zonjee, on Feb 18 2009, 03:35 PM, said:

Either the path set in LOCAL_EXE_GZIP (I think it is in application_top.php) is wrong or you can't use it at all because it is not there. The contribution also can use it's own files for gzipping a file. It is in there as a function.

Could you please show me how to do it? Thank you!

[lightshine]

Jan Zonjee, on Feb 18 2009, 03:35 PM, said:

Either the path set in LOCAL_EXE_GZIP (I think it is in application_top.php) is wrong or you can't use it at all because it is not there. The contribution also can use it's own files for gzipping a file. It is in there as a function.

I'm a newbie in php and osc. Could you please show me how to code using the gzip function to zip up the entire catalog/shop site to a file? Which would enable us to download the site for backup as well.
This is what i have tried so far but it does not work properly as shown below. When i click on the backup button, it only return a very small file size which should not be the case!

	  case 'backupfilesnow':
		tep_set_time_limit(0);
		$backup_file = 'files_' . date('YmdHis') . '.gz';
		if (@file_exists(LOCAL_EXE_GZIP) && $safe_mode_setting == false) {
		  exec('tar -cjf ' . DIR_FS_BACKUP . $backup_file . ' ' . DIR_FS_DOCUMENT_ROOT . ' --exclude=\'*.gz\' ' . DIR_FS_BACKUP);
		  header('Content-type: application/x-octet-stream');
		  header('Content-disposition: attachment; filename=' . $backup_file);
		  readfile(DIR_FS_BACKUP . $backup_file);
//		unlink(DIR_FS_BACKUP . $backup_folder_file);
		  unlink(DIR_FS_BACKUP . $backup_file);
		} elseif (@function_exists('gzwrite')) {
			$gzip_result = osc_gzip (DIR_FS_BACKUP, $_GET['file'], false);
			
			if (!$gzip_result) {
			$messageStack->add_session(ERROR_ON_GZIP, 'error');
				tep_redirect(tep_href_link(FILENAME_BACKUP, $listing_link));
				exit;
			}
		} else {
		  //$messageStack->add_session('compression tooling \'' . LOCAL_EXE_GZIP . '\' not found', 'error');
		  $messageStack->add_session(ERROR_NO_GZIP_AVAILABLE, 'error');
		  tep_redirect(tep_href_link(FILENAME_BACKUP, $listing_link));		 
		  exit;
		}
		break;

Edited by lightshine, 20 February 2009 - 06:21 AM.

[ifccnb]

Hello, I installed your contrib and seems to work fine, thanks. I just had a question... in the contrib file you included some screen shots. I have never seen this screen when I perform a restore.

This is not a nitpick lol. I was just wondering because it looks cool.

[img]http://www.pagesworldbanknotes.com/zweb_images/screenshot_reload_backup.gif[/img]

[Coopco]

Hi Jan

I have this contribution installed and am in the process of doing the updates to RC2a. I am up to the MySQL 5.0 Strict Mode compatibility updates and Update database backup and restoration.

Do you think it is worthwhile doing these?

[Jan Zonjee]

Coopco, on Oct 3 2009, 03:36 PM, said:

I have this contribution installed and am in the process of doing the updates to RC2a. I am up to the MySQL 5.0 Strict Mode compatibility updates and Update database backup and restoration.

Do you think it is worthwhile doing these?

Not for the database manager if you installed this one. As far as I recall those fixes should be in there or not needed.

[Jan Zonjee]

ifccnb, on Feb 27 2009, 10:22 AM, said:

I just had a question... in the contrib file you included some screen shots. I have never seen this screen when I perform a restore.

This is not a nitpick lol. I was just wondering because it looks cool.

Never saw your post, sorry. You would only see this if the backup you had to make would come close to the maximum execution time of a PHP script (so the command to extend the maximum time to indefinitely would not be allowed on your server too). Then the backup would happen in several "passes" and this is a screen that shows the progress so far.

[Coopco]

Jan Zonjee, on Oct 3 2009, 11:52 PM, said:

Not for the database manager if you installed this one. As far as I recall those fixes should be in there or not needed.

Fantastic, thanks Jan.

[Milierkovic]

Hello Jan Zonjee,

First of all thanks for your contribution.

I have a question, i am following the  "How to secure your site" thread: http://forums.oscommerce.com/topic/313323-how-to-secure-your-site/

It states here and i quote "I recommend you use AutoBackup Database in Admin AND Database backup manager also Backup of all store files in zip format. "

Now i happen to have installed Auto Backup Install V3.0 and in this contribution i had to edit "admin/includes/languages/english/backup.php"

5. In /admin/includes/languages/english/backup.php

find:

define('ERROR_BACKUP_DIRECTORY_DOES_NOT_EXIST', 'Error: Backup directory does not exist. Please set this in configure.php.');

replace with:

define('ERROR_BACKUP_DIRECTORY_DOES_NOT_EXIST','Error, Backup Directory Does Not Exist, please create it or run "auto_backup_setup.php"');

Now in your contribution i have to upload a new admin/includes/languages/english/backup.php file, but this does not have the change in it anymore
for the Auto Backup Install V3.0 to work.

Is it safe just to change this line again after i uploaded your admin/includes/languages/english/backup.php file?

Or can this cause mailfunctioning?

Thanks

Edited by Milierkovic, 09 October 2009 - 03:50 PM.

[spooks]

Milierkovic, on 09 October 2009 - 03:49 PM, said:

Its just a language file, you are just defining what it says if there is a error, it could say anything u like.

Changing it will not effect the operation of either app.

[Jan Zonjee]

Milierkovic, on 09 October 2009 - 03:49 PM, said:

Now in your contribution i have to upload a new admin/includes/languages/english/backup.php file, but this does not have the change in it anymore
for the Auto Backup Install V3.0 to work.

Is it safe just to change this line again after i uploaded your admin/includes/languages/english/backup.php file?

Or can this cause mailfunctioning?

The purpose of the language files is just to be able to use different languages with one "code" file so you seldom get errors with changes in language files. You should be safe changing this line again in the language file that came with the contribution.

[Milierkovic]

Thanks for your quick answers,

I asked this question just to be sure, but now i see it cant do any damage, it works good, i tested it.

better safe then sorry

[faaliyet]

Hello Jan,
That's really really a great addon for osCommerce. Thanks for your time, idea and your perfect effort.

I have some questions:

-Do you think to update this addon for osCommerce v2.3.x (ereg_replace, template_top.php , template_bottom.php etc...)?
-Do you think to develop the script as AutoBackup Script with some available options like:
***AutoBackup DB ( 1-24 hourly, daily, weekly, monthly)
***Delete backup archives [older than specified days]
***Restore base from last backup archive [matching specified regexp]
***Create back up archives [from specified table(s)]\n\n". [table1 table2...]\n".
-Including BigDump and XT-Dump(I can't find) updates.

I will need to use this addon with some extra options. I think to start to develop but, I can't find XT-Dump on the Web.

Thanks.

[faaliyet]

Hello Jan,

I've tested this class: http://www.phpclasses.org/package/4017-PHP-Backup-large-MySQL-databases-into-multiple-files.html
That's not a good solution. That has a problem with null and empty inputs ''. But like "idea" really it's very good.
I didn't find the new version or documentation for XT-Dump. Because there is no site of the creator : http://dreaxteam.free.fr/ now.
I also found a bug (and maybe in osC v2.3.1.- I didn't check) in your addon with my mysql partitions (partition option of mysql).

Thanks.

Edited by faaliyet, 08 March 2011 - 07:41 PM.

[Jan Zonjee]

faaliyet, on 08 March 2011 - 07:33 PM, said:

I've tested this class: http://www.phpclasses.org/package/4017-PHP-Backup-large-MySQL-databases-into-multiple-files.html
That's not a good solution. That has a problem with null and empty inputs ''. But like "idea" really it's very good.

Never seen it and I the site didn't open this moment so it will have to wait.

Quote

I didn't find the new version or documentation for XT-Dump. Because there is no site of the creator : http://dreaxteam.free.fr/ now.

True, but a newer version I saw can be found here.

Quote

I also found a bug (and maybe in osC v2.3.1.- I didn't check) in your addon with my mysql partitions (partition option of mysql).

I don't know what you mean with that. Please clarify what you mean with mysql partitions (haven't googled for it).

[Jan Zonjee]

faaliyet, on 18 February 2011 - 09:31 PM, said:

I have some questions:

-Do you think to update this addon for osCommerce v2.3.x (ereg_replace, template_top.php , template_bottom.php etc...)?

Haven't written a line of code in months. Too busy and too lazy.

Quote

-Do you think to develop the script as AutoBackup Script with some available options like:
***AutoBackup DB ( 1-24 hourly, daily, weekly, monthly)

As far as I know "spooks" already did an auto-backup contribution.

Quote

-Including BigDump and XT-Dump(I can't find) updates.

BigDump was very recently uploaded I think (Restore Database with Browser). Haven't looked at updates of those two.

[kymation]

mysqldumper does a great job of backing up and restoring large databases. Backups can run manually or from a CRON job. It's free/open source of course.

Regards
Jim

[faaliyet]

kymation, on 09 March 2011 - 12:34 AM, said:

mysqldumper does a great job of backing up and restoring large databases. Backups can run manually or from a CRON job. It's free/open source of course.

Regards
Jim

Thanks Jim !
I just saw the screenshots of mysqldumper and that looks perfect. I'm gonna check this out.
That's really a great job ! Awesome !
Thanks in advance for your message !!!

[spooks]

Uploaded New Version 1.5 (Complete Package)

Modified layout for 2.3.x,
Moved & modified download function,
Added download(display) plus deletion of log files if found in folder,
Added ability to email backup files,
Replaced any depreciated functions.
A few other minor display modifications.

This version is also compatible with osC 2.2 and lower

Log files are produced by Auto Backup Database ( http://addons.oscommerce.com/info/8374 )
which will create automatic backups periodically that are compatible with Database Backup Manager.

[mr_absinthe]

That was quick!
The file size that I tried to email is 9.28MB and I'm receiving the following error:
Fatal error: Allowed memory size of 67108864 bytes exhausted (tried to allocate 13150833 bytes) in /home/xxx/zzz/admin/includes/classes/class.smtp.php on line 368