Bookmarks

Yahoo Gmail Google Facebook Delicious Twitter Reddit Stumpleupon Myspace Digg

Search queries

dbf2mysql parameter, WWWXXXAPC, wwwxxxAPC, How to unsubscrube from dategen spam, docmd.close 2585, WWWXXXDOCO, nu vot, dhcpd lease file "binding state", WWWXXXDOCO, how to setup procmail to process html2text

Links

XODOX
Impressum

#1: Advice wanted on backing up large databases

Posted on 2007-10-27 00:28:01 by Mad Hatter

Hi
First off what I'm trying to do is export my mysql database to a file on my
server, preferably with an option of emailing it in compressed format. I've
tried quite a few mysql database backup programs, all of which work on a
small test database but all fail when trying to export an 10Mb+ database. I
get an the message 'Internal Server Error, this is an error with your
script, check your error log for more information.' My servers error log is
always empty. I assumed the problem was a timeout problem so added
set_time_limit(0); but still no joy. As I said, all the scripts I've tried
work fine on small databases but die on the large database. Can anyone shed
some light on where I'm going wrong?

Report this message

#2: Re: Advice wanted on backing up large databases

Posted on 2007-10-27 04:39:59 by Shion

Mad Hatter wrote:
> Hi
> First off what I'm trying to do is export my mysql database to a file on my
> server, preferably with an option of emailing it in compressed format. I've
> tried quite a few mysql database backup programs, all of which work on a
> small test database but all fail when trying to export an 10Mb+ database. I
> get an the message 'Internal Server Error, this is an error with your
> script, check your error log for more information.' My servers error log is
> always empty. I assumed the problem was a timeout problem so added
> set_time_limit(0); but still no joy. As I said, all the scripts I've tried
> work fine on small databases but die on the large database. Can anyone shed
> some light on where I'm going wrong?

I think it can be the memory limit that is too low for this job, check your
memory_limit.

--

//Aho

Report this message

#3: Re: Advice wanted on backing up large databases

Posted on 2007-10-27 08:56:37 by David Quinton

On Sat, 27 Oct 2007 04:39:59 +0200, "J.O. Aho" <user@example.net>
wrote:

>Mad Hatter wrote:
>> but all fail when trying to export an 10Mb+ database. I
>> get an the message 'Internal Server Error, this is an error with your
>> script, check your error log for more information.' My servers error log is
>> always empty. I assumed the problem was a timeout problem so added
>> set_time_limit(0); but still no joy. As I said, all the scripts I've tried
>> work fine on small databases but die on the large database. Can anyone shed
>> some light on where I'm going wrong?
>
>I think it can be the memory limit that is too low for this job, check your
>memory_limit.

Personally I wouldn't use PHP for this.
I have daily cron jobs that do it using a Shell script and then it
emails me the Gzipped file.
Let me know if you'd like to see it...
--
Locate your Mobile phone: <http://www.bizorg.co.uk/news.html>
Great gifts: <http://www.ThisBritain.com/ASOS_popup.html>

Report this message