|
Page 1 of 1
|
TheSteffen 
Joined: August 2006
Posts: 1607
Location:  Magdeburg
|
 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.
____________ TheSteffen
Often SEARCH is the quickest way to get support.
IcyPhoenix German Support
|
#1 Mon 20 Aug, 2012 16:18 |
|
Sponsors

|
Icy Phoenix is an open source project, you can show your appreciation and support future development by donating to the project.
|
| |
Mighty Gorgon 
Luca Libralato
Joined: August 2006
Posts: 6814
Location:  Borgo San Michele
|
 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:
// 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
____________ Luca
SEARCH is the quickest way to get support.
Icy Phoenix ColorizeIt - CustomIcy - HON
|
#2 Sun 26 Aug, 2012 13:51 |
|
spydie 
Joined: December 2008
Posts: 1789
Location:  In the Boxes
|
 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 <?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.
____________ Driving me and my PC crazy, trying to create some pluggins
Icy-Mods.com ( IP 2.0 RC-1)
|
#3 Sun 26 Aug, 2012 16:46 |
|
Torgils 
Michael Schlomm
Joined: September 2012
Posts: 2
Location:
|
 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
|
#4 Sun 02 Sep, 2012 13:01 |
|
mort 
Joined: August 2010
Posts: 761
Location:  Behind You
|
 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
____________ My advice is freely given on the assumption that you will ignore any part or all of it!
My Hobby
|
#5 Sun 02 Sep, 2012 14:14 |
|
Torgils 
Michael Schlomm
Joined: September 2012
Posts: 2
Location:
|
 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 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
|
#6 Tue 04 Sep, 2012 11:07 |
|
mort 
Joined: August 2010
Posts: 761
Location:  Behind You
|
 Re: Backup Via Cron
Mike, I think you are missing something?
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.
____________ My advice is freely given on the assumption that you will ignore any part or all of it!
My Hobby
|
#7 Tue 04 Sep, 2012 14:16 |
|
Mighty Gorgon 
Luca Libralato
Joined: August 2006
Posts: 6814
Location:  Borgo San Michele
|
 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
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.
____________ Luca
SEARCH is the quickest way to get support.
Icy Phoenix ColorizeIt - CustomIcy - HON
|
#8 Mon 10 Sep, 2012 23:56 |
|
|
Page 1 of 1
|
Was this topic useful?
Was this topic useful?
| Link this topic |
| URL |
|
| BBCode |
|
| HTML |
|
Similar Topics
Similar Topics
You cannot post new topics You cannot reply to topics You cannot edit your posts You cannot delete your posts You cannot vote in polls You cannot attach files You can download files You cannot post calendar events
|
|
|
|