Perl/Cron job not successful on large database

**uses MSD regulary** Joined: 24 May 2006 Posts: 14

Hello All,
I use MySQLDumper to backup four different DB over night, via cronjob.de
3 DBs are successfully backed up, the 4th one not. When I perform a manual backup from the Mysqldumper web interface (so a Php backup), it works fine but takes a while (an average of 2 mns). My DB has a 70 Mb size almost.
Is the cron failure due to the DB size ? If yes, what can I do to improve the result, knowing that I cannot change the time out on the server, it is a mutualized one.
Any help will be appreciated Smile

Thanks/Merci/Danke

Posted: 2007-02-07, 19:50 (No subject)

Yes, you are running into timeout-limits.
You can avoid that by backing up each database with an own cronjob.
Therefor you can save different config-files (notice the name-inputfield on the perl-screen) and hand over this parameter (config=myconfig2.conf) to the perlscript when executing it.

**uses MSD regulary** Joined: 24 May 2006 Posts: 14

Thanks for the answer,
If I do so, do I keep the choice to select which table is backed up by a given config-file ?? I did not see where this is configured ... Using 1.12 b11 alpha

Posted: 2007-02-08, 19:52 (No subject)