mr_absinthe

I just want to let you know that I've tested on my other server and the results are almost identical to what I've reported earlier: File Mode Zipping - no problems at all. Memory Mode Zipping 7zip and WinRAR kept asking to confirm file replace and throwing errors. Memory Mode GZipping PHP Version: 5.3.10 Method: Tar Server OS: Linux Fatal error: Allowed memory size of 41943040 bytes exhausted (tried to allocate 4720129 bytes) in /hosting/www/mystore/www/admin/includes/classes/tar.class.php on line 325 I've changed the error_reporting to 1 to see that error.

Thank you for the update. It seems correct, I made sure that Optimise Database Period has the lowest value of 7 days and this was the result: Store database has been optimized. Customers tables were trimmed. Credit Card data was removed from the orders table. Sessions table was trimmed. Database was analyzed. Database was optimized. Initial size was 48287307. Final, optimized, size is 47349379. Also I believe that you should add the following to the Update_1.1_to_1.2.txt file: 2) Upload the admin\database_optimizer.php otherwise the version number will be incorrect.

I can confirm that the File Mode Zipping method is fine now, thank you! :thumbsup:

Sam, thank you for the update. I have tested using all three methods and this is the result: Backup was always created and saved successfully. $guess = -10; (I hope that this is not causing any problems?) Memory Mode GZipping PHP Version: 5.2.9 Method: Tar Server OS: Linux Website size: 143.15 MB Estimated compressed file size: 83.03 MB Containing 343 folders with 5484 Files. Downloaded file size 28,913 KB WinRAR and Opus Directory Error message while unpacking: The archive is corrupt. I was however able to unpack it with 7zip. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ File Mode Zipping Website size: 143.15 MB Estimated compressed file size: 83.03 MB Containing 343 folders with 5484 Files. Downloaded file size 31,034 KB No errors while unpacking using WinRAR or 7zip. There is a home folder (with folder structure) created within backup containing no files as well as Website-Backup folder containing all folders and files. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Memory Mode Zipping Website size: 143.15 MB Estimated compressed file size: 83.03 MB Containing 343 folders with 5484 Files. Downloaded file size 31,515 KB I am able to unpack using WinRAR or 7zip, however 7zip and WinRAR keep asking to confirm file replace and throwing errors. These errors look in 7zip as follows: ERROR: Can not delete output file C:\Data\Destinatin backup folder\My-Website-Backup\admin\includes\local 334 lines of errors in total, however the unpacked backup seems to look OK but it's rather hard to confirm for sure without uploading back to server I guess. Always suspicious to see errors. There is only Website-Backup folder containing all folders and files, no home folder. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ That's all I was able to find out at the moment. For me, the File Mode Zipping is the most reliable method at the moment.

OK, I'll wait for it.

And I was looking at another server... the server where I'm testing it atm has gzip compression enabled as well as: _SERVER["HTTP_ACCEPT_ENCODING"]gzip, deflate _ENV["HTTP_ACCEPT_ENCODING"]gzip, deflate Is that line also in the backup manager or auto backup?

All that I can see in the server information is: HTTP_ACCEPT_ENCODING gzip, deflate _SERVER["HTTP_ACCEPT_ENCODING"]gzip, deflate But... whether it's enabled or not, what can I do about it? Is it being gzipped again when emailed?

I've asked them. I was comparing the size of those two files in directory opus after downloading them both (one was downloaded directly from the manager, the other one from gmail).

I forgot to mention, all of the above tested on Windows7 64bit.

OK, I've updated also the Auto Backup release and all files related to the backup manager have been overwritten. The update was OK - Installation successful, setup has past all checks OK! I've double checked that line 27 in mail_backups.php reads: $lf = "\r\n"; and also the line 44 is: if ( @include_once('Mail/mime.php') ) After hitting the e-mail button, I receive this message: Warning, PEAR Mail not found or insufficient to email backup, reverting to standard mail function. Backup db_file_201203280928.sql.gz sent by email OK Unfortunately, the emailed file is still corrupted - I was unable to open it using 7zip nor winRAR. The file that I've downloaded directly from the manager is fine. I've also noticed that there is a difference in size of these two files: emailed: sql.gz 870 KB downloaded: sql.gz 644 KB

I've tested the latest, not sure what this line does (clicking the link does nothing): $test = '<a href="' . tep_href_link(FILENAME_BACKUP, 'test=at_backup' . $listing_link) . '">Auto</a>'; This was the output message: Warning, PEAR Mail not found or insufficient to email backup, reverting to standard mail function. Backup db_file_201203271645.sql.gz sent by email OK The file was received just fine... Unfortunately the file is corrupted, tested in Directory Opus as well as in WinRAR - ! C:\Users\User\Downloads\db_file_201203271645.sql.gz: The archive is either in unknown format or damaged. When I download the same file directly from the Manager, I can extract it just fine.

It is Linux, php 5.3.10. $guess = 1; File on the server is OK and the file that was downloaded is corrupted. Estimated compressed file size: 17.96 MB - real size 12MB. So I played with $guess just for fun and the most realistic estimated was achieved with value $guess = -20;. I've made no changes to ZipStream.php BTW.

I've added the code as instructed: $exclude = 'DIR_FS_BACKUP, DIR_FS_CACHE, SESSION_WRITE_DIRECTORY, contest/'; // add excluded as required, include full path from catalog folder i.e. includes/languages/ ini_set('memory_limit', '128M'); // set memory limit, increase if you receive an out of memory error, you may need to speak to your host!! $guess = 4; // increase if size estimation is too low error_reporting(E_ALL & ~E_NOTICE); The backup folder is not empty, but I've added the @ anyway: @array_map( "unlink", glob( DIR_FS_BACKUP . $filename."*" ) ); $guess = 1; - corrupted file $guess = 2; - corrupted file $guess = 3; - corrupted file $guess = 4; - corrupted file Tested with both backup modes.The good news is that there are no errors, at least visible ^_^

I've increased $guess = 1; and now receiving this error when I use both File Mode Zipping and Memory Mode Zipping: Warning: array_map(): Argument #2 should be an array in /hosting/www/xxx/www/admin/backup_website.php on line 121 plus many headers already sent warnings. When I changed it to $guess = 2; - file downloaded but unable to open - corrupted. (Estimated compressed file size: 18.22 MB - real size 12 MB - quite a difference) When changed to $guess = 3; - same as $guess = 1;

The solution above worked, however none of the .zip files could be xtracted, receiving errors in Directory Opus as well as in WinRAR - ! C:\Users\User\Downloads\Website-Backup-26-03-2012 (1).zip: The archive is either in unknown format or damaged.

Not sure what is happening to the language files - the czech language is there as the shop runs in the Czech Republic and the whole language pack has been added as usual - no other errors in any other contributions has been detected or seen. The previous version Backup Store Files has been working fine as well. Same errors do appear if I switch admin language to English.

Sam, after clicking the "here" button in both the File Mode Zipping and the Memory Mode Zipping I receive the following errors: Notice: Constant PREVNEXT_BUTTON_PREV already defined in /hosting/www/xxx/www/admin/includes/languages/czech.php on line 388 Notice: Constant PREVNEXT_BUTTON_NEXT already defined in /hosting/www/... .../includes/languages/add_ccgvdc_english.php on line 32 Notice: Constant TEXT_VALID_CATEGORIES_NAME already defined in /hosting/www/xxx/www/admin/includes/languages/add_ccgvdc_english.php on line 33 Fatal error: Call to undefined function tep_href_link() in /hosting/www/xxx/www/admin/includes/languages/czech.php on line 440

Would it be possible to have the backup file emailed automatically without the need hitting the email button?

Thank you, that works fine as a temporarily solution - I'll have to remember to keep an eye on that line with every update of the contribution. Is there a chance that the backup file could be sent automatically (cron job)?

OK, getting somewhere... After adding ini_set('memory_limit','256M'); to includes/mail_backups.php, I'm able to email the backup file IF I'm using the class.smtp.php file from V_1_5. However, with this class.smtp.php file, I'm unable to send emails (admin->Tools->Send Email) nor I'm able to send change of order status, receiving this error: Fatal error: Call to undefined method email::connected() in /home/xxx/yyy/admin/includes/classes/class.smtp.php on line 117 The problem is probably causing the contribution http://addons.oscommerce.com/info/901 that contains the class.smtp.php file.

there is a newer version of the phpMailer at:http://code.google.com/a/apache-extras.org/p/phpmailer/downloads/list however it is throwing the same error: Fatal error: Allowed memory size of 67108864 bytes exhausted (tried to allocate 12980575 bytes) in /home/xxx/yyy/admin/includes/classes/class.smtp.php on line 370

Thank you for taking time to have a look at it. I have a limit of 64M for both post_max_size and upload_max_filesize, therefore it should be just about OK. Not sure about the message_size_limit but I guess it could be similar. Pity about the phpMailer. Also, it appears that there might be more hidden problems as a part of the phpMailer, particurarly in the class.smtp.php as I'm receiving the following error while trying to send order status change from admin: Fatal error: Call to undefined method email::connected() in /home/xxx/yyy/admin/includes/classes/class.smtp.php on line 117 I have therefore switched back to previous version of the class.smtp.php and the error that I'm receiving now after hitting email button in Database Backup Manager is this: Fatal error: Call to undefined method smtp::Connected() in /home/xxx/yyy/admin/includes/classes/class.phpmailer.php on line 780

Thank you for taking time to have a look at it. I have a limit of 64M for both post_max_size and upload_max_filesize, therefore it should be just about OK. Not sure about the message_size_limit but I guess it could be similar. Pity about the phpMailer.

Yes, the file that I'm trying to email is compressed - db_xxx_zzz-201203140434.sql.gz - 9.12MB. My host confirmed that the script command is using more than the 64MB allocated and hence I see the error.

I should also mention that the memory_limit is 64M so why am I receiving the error while trying to send only 10MB?