Icy Phoenix

Old Support Topics - Backup via cron

TheSteffen [ Mon 20 Aug, 2012 16:18 ]
Post subject: Backup via cron

I now it is possble to use the DB backup in ACP
adm/admin_db_backup.php?mode=backup

Is it possible to run this as cron?

I normaly don´t use it, because I use mysqldumper.
But some users of my forum are asking.

Mighty Gorgon [ Sun 26 Aug, 2012 13:51 ]
Post subject: Re: Backup via cron

It is possible, but I wouldn't do that, because as the DB is getting bigger, is not the best way to accomplish a backup, as PHP may run out of time or memory. Other instruments should be used instead, since backup is a very important resource.

Icy Phoenix also support external file inclusions as a cron, so it would be enough to create a file which runs a backup through another PHP script.

Have a look in constants.php:

Code: [Hide] [Select]

// Add all files separated by commas... e.g.: 'cron_file_1.php,cron_file_2.php,cron_file_3.php'

define('CRON_FILES', '');

Then you need to enable the specific files cron in ACP => Configuration => Main Settings => Cron

spydie [ Sun 26 Aug, 2012 16:46 ]
Post subject: Re: Backup Via Cron

I did that some time ago with MysqlDumper.

in the cron.php file you need to create, you only need to include the path to the cron execution of the dumper.

something like

Code: [Hide] [Select]

<?php

include("http://your_site.com/msd/msd_cron/crondump.pl?config=mysqldumper");

?>

call the file "cron1.php" for example and safe it to includes.

then open the msd/msd_cron/crondump.pl and set the absolute path the dumper gave you.

then you should be able to make cron_dumps via the acp cron settings.

But this will only work, if you don´t use a password-protected dumper

and, your server allows Perl.

better is, to set the cron in your server cron-settings.

Torgils [ Sun 02 Sep, 2012 13:01 ]
Post subject: Re: Backup Via Cron

Hello,

i am asking in the german support forum to this.

We have no mysqldumper. On DB we work Plesk and phpmyadmin.
In Time, i have a phpbb3 Forum, for this is give a MOD for the Cronjob and its work fine!

The new Forum for a friend is a IP-Forum. He don´t no what is it of works to make Forum from technikside and for this is a cronjob the ideal work for him and the team from the forum.

I will run this and any other features bevore i go to IP too.

Sorry for my bad english

Regards, Mike

mort [ Sun 02 Sep, 2012 14:14 ]
Post subject: Re: Backup Via Cron

I do recommend that you use mysqldumper and not rely on any forum software to handle everything that you require. Particularly when most of them can't handle huge database dumps.

Maybe this will help

http://www.squidoo.com/automatic-da...ing-mysqldumper

Torgils [ Tue 04 Sep, 2012 11:07 ]
Post subject: Re: Backup Via Cron

Hi,
i don´t use mysqldumper! For DB actions i used my Plesk with myphpadmin.
In my phpbb Forum is the cronjob for daily backup a little MOD with little code. Look here http://www.phpbbhacks.com/download/8608 . It is a little Code for work it an not a additionally Programm. The mysqldumper is a great Tool, but only for the cronjob?

Regards, Mike

mort [ Tue 04 Sep, 2012 14:16 ]
Post subject: Re: Backup Via Cron

Mike, I think you are missing something?

MG wrote:
It is possible, but I wouldn't do that, because as the DB is getting bigger, is not the best way to accomplish a backup, as PHP may run out of time or memory. Other instruments should be used instead, since backup is a very important resource.

PhpBB may have this "great" mod that you can run a cron with, but it doesn't do anything to address the fact that phpMyAdmin is limited in the amount of data it can handle both IN or OUT.

And for that reason I doubt that anyone here would recommend using phpMyAdmin for backup.

Some IPS offer free or paid site-backup with options, some don't - So "since backup is a very important resource" you need the best possible ways of doing it - - Not the easiest.

Mighty Gorgon [ Mon 10 Sep, 2012 23:56 ]
Post subject: Re: Backup via cron

Torgils wrote: [View Post]
Hi,
i don´t use mysqldumper! For DB actions i used my Plesk with myphpadmin.
In my phpbb Forum is the cronjob for daily backup a little MOD with little code. Look here http://www.phpbbhacks.com/download/8608 . It is a little Code for work it an not a additionally Programm. The mysqldumper is a great Tool, but only for the cronjob?

Regards, Mike

It's quite easy to be ported, maybe it will require 30/60 minutes of work, but I wouldn't use that for large DB, since it is very likely to not work properly.

As advised, you should use different (and much more reliable!) tools for backing up your DB. If you really want to use this or similar tool, you currently need to work a bit to adapt to Icy Phoenix, but you have to know some PHP and Icy Phoenix basics to be able to port that mod. I can help if you wish, but I don't have the time to do the job entirely right now.