Was just wondering, as a request or idea, if the next version of CPG Nuke could have a Auto Backup functionality for the database. Currently my ISP doesnt do a auto backup of our database so i´m using 3rd party software to do that for me.

I think it would be great if you could select the auto-backup functionality (on/off) and that the backup file is saved in a seperate folder or ftp-ed to another fileserver or even emailed.

I second this as I can't get a cronjob to work for me.

My host says to use PHP instead of Perl, so integrated into the system would be great!

I could code a raw dumping one easily, and it'd be tar'd then bz2'd so it'd take like no space at all. But df already has 'proper' db backup function so we should use that instead, and just stream its output into a local file, then exec() tar followed by bzip2 on the php-created text file.

However to make it do this when no ones visiting would be hard. I do not think that you can have a php script just invoke itself. It'd have to keep a last_updated record, and when it is next run if it is a certain time after that then it performs a backup. Maybe put a call to it in each of your theme header templates so someone just needs to visit the page to activate it.

Sounds do-able, but i haven't looked at it.

Perl and PHP are both not adviced for cronjobs because they will produce an overhead.
I already provided somewhere in these forums a shell script to use as cronjob. FYI maybe it's already in the FAQ or Wiki

Secondly the shell script could be easily converted to PHP if you realy need such bad thing.

Sorry, I think I meant Shell. I've tried the one from the a post of yours in the forum, the one in the Wiki, and the PHP script there, but none of them seem to work.

My host just said they recommend using PHP rather than Shell/Perl.

norbie wrote:

My host just said they recommend using PHP rather than Shell/Perl.

Time to recommend a new host? I use a script written by Tsykoduk that works great!

Nah, apart from that they're brilliant in what they offer.

I was told

Quote::

Perl/CGI scripts can be tricky to setup and we do always recommend using PHP scripts. Check list for CGI scripts: - Upload using ASCII - Set permissions correctly (chmod), this seems to be correct - Use the correct Perl path I hope this may help,

I could take a look at that script though please?

Currently trying to use phpMyBackupPro 1.7.1. Installed and configured it today, so that it auto backups the database once every 24hours. Need to see if it works properly tho. If CPG Nuke could include that into the backup module, it would be great.

If you have shell access and cron access, you can crop together a quick script liek the following..

Code::

cd ~/backup rm backup5.sql mv backup4.sql backup5.sql mv backup3.sql backup4.sql mv backup2.sql backup3.sql mv backup1.sql backup2.sql mv backup.sql backup1.sql mysqldump --all-databases >backup.sql

I have a backup folder off the root of my site, and the script lives there. Each day, it rotates 5 days worth of backups and then grabs a complete mysql backup of all of the DB's on my host.

Quick, painless and easy.

Tomorrow FTP'ing it to a remote host for even more backup goodness.

I use this script for more than two years:
sourceforge.net/projec...ysqlbackup

and never had a porblem. It makes incremental backup - daily, weekly, monthly and reports you by email.

Do not invent the wheel - improve it!

Hi,
Is there a way to do a backup and email a link to that backup. Because all the cron backup I looked at (automysqlbackup.sh, cronjob.sh) seem to email the all backup?
Thanks

tour93 wrote:

Hi, Is there a way to do a backup and email a link to that backup. Because all the cron backup I looked at (automysqlbackup.sh, cronjob.sh) seem to email the all backup? Thanks

I think that it should be possible with a little hack of these scripts (soz, i cant do it). What I´ve done is opened an additional Gmail-account (it can hold 2,7gb of data) and have my back-ups emailed to it! That way i have a back up on the server and one in gmail.

If you´re in need of an gmail account, contact me!!

ok thanks, but I already have some gmails account.

Hold on a sec...

Try this script:

Code::

cd ~/backup rm backup5.sql mv backup4.sql backup5.sql mv backup3.sql backup4.sql mv backup2.sql backup3.sql mv backup1.sql backup2.sql mv backup.sql backup1.sql mysqldump --all-databases >backup.sql cat backup.sql |mail -s "Backup" -t tsykoduk @ gmail.com

This did not work on my host - the mail command is disabled. If your host is more freindly, that should work fine. I use a simlar command to email me reports from my work servers.

Hi tsykoduk,

Quote::

cd ~/backup

I create this folder, backup, where the "blocks" folder is?

Quote::

mysqldump --all-databases >backup.sql

Do I need to replace all-database with the name of my db?

Do I need to save that script as a .sh and call it with a cron job?