[LoveStream]

Hello.

After restore from backup files, the charset went broken.
How could I set the charset for the backup.

[marianoblesa]

Hello

<!-- $Header: F:\CVS/4.x/Auto-backup/Auto-backup.txt,v 1.3 2010/12/04 22:52:33 Pem Exp $ -->

This code must be put somewhere.

Thanks.

[Miihawk]

How can I save the backup on a different server, using ftp ?

[DevOne5555]

Originally Posted by Miihawk

How can I save the backup on a different server, using ftp ?

To do an automated remote backup is a little beyond the scope of this script I think. That would require third-party server software (e.g. rsync); if memory serves, you need a set of passwordless ssh keys on both ends so the servers can connect automatically. rsync was really designed for backing up tape drives though, not 1 or 2 files. Cpanel has its own automated remote backup function which works over ftp, but it will only back up user accounts. Most web hosting plans offer some kind of automated backup service.

[washingtonboise]

My sql database is five gigabytes.
It appears that this mod can not support large databases.

This times out when ran manually (even if configured to do just 1,000 records at a time), it also fails when ran automatically via cron.

[Paul M]

There is no limit to the size it will process, if you get timeouts then you need to check php timeout settings and also mysql timeout settings.

That said, with a database that size, I would not rely on just this mod as a backup method.

[washingtonboise]

I have tried some other scripts like mysqldumper, and they are all timing out, probably mysql timeout.

I find it surprising that people are telling me I can log in to SSH, run a few commands (like five), and the server will make a perfect, fail-proof copy of the database.

Are scripts limited from using the same kind of commands like 'wget' that work so reliably in SSH? It's starting to look like I'm just going to have to buy a book and learn the shell commands.

[Paul M]

Originally Posted by washingtonboise

I find it surprising that people are telling me I can log in to SSH, run a few commands (like five), and the server will make a perfect, fail-proof copy of the database.

This is correct, read up on "mysqldump"

[Hostboard]

Back in 08ish I wrote a Perl script that not only backed up the database but also the physical files. I ran it via CRON but it could also be manually envoked. You can use the single line in the code below noting the mysqldump as Paul mentioned. The code below will give you an idea of what you need to read about (mysqldump switches) to get a proper backup.

#!/usr/bin/perl
# System Backup
#------ Variables ------
$backupdir = "/usr/local/DirectoryOfBackUpLocation"; # "." for current
$other_dirs = "/usr/local/DirectoryToBeBackedUp1 /usr/local/DirectoryToBeBackedUp2";
#-----------------------
print "Backup Initiated...\n";
@timenow = localtime(time);
$newfilename = sprintf("%02d",$timenow[4]+1) .
sprintf("%02d",$timenow[3]) . ($timenow[5] + 1900);
print "Using Filename: $newfilename.sql \n";
print "Starting database backup... \n";
system "mysqldump -qce -r $newfilename.sql -u root DataBaseName";
print "Starting Compression... \n";
system "tar czf $backupdir/$newfilename.tar.gz $other_dirs $newfilename.sql";
unlink "$newfilename.sql" || print "Error: Cannot delete file specified: $newfilename - $_ \n";
print "Done. \n"


I use Paul's modification on ALL my sites and am surprised it is not a default VB option. As backups are critical if you run a site.

If I had any requests it would be to have an option to also include the physical files and auto purge backups X days old.

[cameraguru]

What a life saver a good backup can be!

Thanks

[grasshopper1983]

hi paul

someting wrong here

It make a date folder in my backup folder... but its not wrinting the .sql files...

and still getting the Backup Error : Could not write to destination file

what i'm i doing wrong?

thanks

[Paul M]

That would be a permissions error.

[Hostboard]

Originally Posted by grasshopper1983

hi paul

someting wrong here

It make a date folder in my backup folder... but its not wrinting the .sql files...

and still getting the Backup Error : Could not write to destination file

what i'm i doing wrong?

thanks

CHMOD the backup folder to 777 Also make sure the backup folder is NOT in your websites directory but rather off of the root of your account.

[BadgerDog]

This may sound silly, but to get it to just backup every day of the week and overwrite the previous weeks files so it doesn't keep growing, do I change the field Y-m-d and put a lower case letter "L" l in that field?

Thanks ..

Regards,
Doug

[Paul M]

Yep, that sounds about right.