ledave Posted April 23, 2007 Share Posted April 23, 2007 hi all, I think the Backup Mysql send to your email contribution is very usefull, for me at least: so I can work on localhost with the up to date information of my shop. But (there is always a but), as my db is very big, it doesn't work for me: I got a Fatal error: Allowed memory size of 8388608 bytes exhausted So I think the solution would be making a loop with a limit of bytes and creating as many files as will be needed. I have no problem in doing it and sharing the results, but the thing is that I don't know where to begin/look at. So, if anyone have an idea, it will be welcome. Thanks to soso93, by the way, for doing and sharing the job :thumbsup: Quote Link to comment Share on other sites More sharing options...
oschellas Posted April 23, 2007 Share Posted April 23, 2007 Or you can try to override the memory limit set in php.ini by adding following on top in your script: //override time and memory limit set_time_limit(0); ini_set("memory_limit","256M"); Quote Link to comment Share on other sites More sharing options...
ledave Posted April 23, 2007 Author Share Posted April 23, 2007 waw, that is FAST!!! :) I've tried this solution, but my db is far too big. Now I've this error message: Fatal error: Allowed memory size of 268435456 bytes exhausted (tried to allocate 545 bytes) So I could change the memory limit, from 256 to a bigger number...but i think that this is not the solution because after this I'll have a huge *.sql file that I cannot insert in my db and that will take all my pc ressources to open and cut it in smaller pieces. thanks anyway oschellas for your sugestion. Quote Link to comment Share on other sites More sharing options...
oschellas Posted April 23, 2007 Share Posted April 23, 2007 In that case I would not try to email the file also (w00t) I would create a crontab on the server to make a zipped backup (existing backup function) with a certain interval. Locally you can add a task (if windows/taskmanager) to ftp the file. Quote Link to comment Share on other sites More sharing options...
zchlomo Posted April 29, 2007 Share Posted April 29, 2007 You guys seem to know what you're talking about.. Is there any software that lets you connect to a external server (web hotel) to do a backup of your database? Or is there any way to get the admin backup to not time out on large backups? (mine is over 9 MB's now) Quote Link to comment Share on other sites More sharing options...
apopular Posted May 22, 2007 Share Posted May 22, 2007 i´m having a error message 500 - internal server error.... anybody knows and can help-me ?????? Quote I did, helped or traslate. http://addons.oscommerce.com/profile/104964 My english it´s só poor, but of you need help in portuguese, like shipping and payment that´s make a diference in brazil, come one, Obrigado (thank´s) Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.