Advice wanted on backing up large databases

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?

Re: Advice wanted on backing up large databases

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

Re: Advice wanted on backing up large databases

On Sat, 27 Oct 2007 04:39:59 +0200, "J.O. Aho"
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:
Great gifts: