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.

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:


Then you need to enable the specific files cron in ACP => Configuration => Main Settings => 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

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.

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

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

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  h**p://***.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

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.

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.