Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Backup Mysql send to your email, in parts


ledave

Recommended Posts

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:

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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)

Link to comment
Share on other sites

  • 4 weeks later...

i´m having a error message

 

500 - internal server error....

 

anybody knows and can help-me ??????

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

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.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...