I am running freeBSD 4.9. Is there a cronjob or some kinda of script that will automaticly backup mysql in 1 week intervals or however long i set it?

call me old fashioned but I just tar.gz /var/lib/mysql

add the databases as you like. i.e. /var/lib/mysql /mysql
/var/lib/mysql /foo

Maybe there are cooler methods, but it seems to work.

well and then the whole cronjob thingy

#!/usr/bin/perl

# Backup stuff to a remote server

use Net::FTP;

# Create tmp tar file of the $ARGV[0] directory
my $dir = shift;
my $host = shift || yourhost';
my $user = shift || 'foo';
my $pass = shift || 'pass;
my $remote_dir = shift || 'backups';

die "No directory to backup! - $dir\n" unless ($dir && -d $dir);

# Times
# We need this so we can allow a weeks worth of backups
my ($sec,$min,$hour,$mday,$mon,$year,$wday,$yday,$isdst) = localtime(time());

my $filename;

if($dir =~ m|([^/]+)$|) {
$filename = $1 . '.tar.gz';
} else {
$filename = ' backup. '.$wday.'.'. $hour . '.' . $min . '.' . $sec .'.tar.gz';
}

# To the tar
system("tar zcf /tmp/$filename $dir");

my $ftp = Net::FTP->new($host, Debug => 0);
$ftp->login($user, $pass);
$ftp->cwd($remote_dir);
$ftp->delete($filename);
$ftp->binary;
$ftp->put('/tmp/'.$filename);
$ftp->quit;

unlink('/tmp/'.$filename);


then a shell script like

#!/bin/bash

./backup.pl /var/lib/mysql
echo "done mysql"
sleep 60
sync
./backup nextone


etc.

crontab -e

* * 1 * * /home/foo/backup

or so

Simple small efficient. Probably there are cooler things about i.e. webmin backup module depends really on your mileage.

If your ftp server supports the right commands maybe use ftpsync.

sftpd?

http://search.cpan.org/~drolsky/Net-...ib/Net/SFTP.pm


use Net::FTP; -> use Net::SFTP;


never used this but i assume its a starting point

http://www.stupidfool.org/perl/net-ssh/

etc

Thanks but i have figured out what im going to do. I am going to make a cronjob such as this:

1. Check to see if MySQL is running, and if not, to start it.
2. Run the script that performs the backup job.

This is a sample crontab entry for FreeBSD (which is what your server is running) that checks to see if MySQL is running (if it's not, it starts it) and does the backup:


Code:

*/15 * * * * your_userid /path/to/mysql startup_options
* 23 * * * your_userid /path/to/backup/script


The first line checks every 15 minutes to see if MySQL is running, and starts it if it's not

The second line runs the backup script every night at 11:00 PM.

The syntax for cron is:
minute hour day month wday user command

Also, the line that identified this system as FreeBSD is this:

FreeBSD 4.4-RELEASE (SERVER) #0

You can check the FreeBSD handbook for more info on using cron:

http://www.freebsd.org/doc/en_US.IS...uning-cron.html






sh name the script.sh
If the script has exe perms do

Code:

./name the script.sh


Examples how to set cron:
http://www.webmasters-central.com/t/cron.shtml

Code:

sh #!/bin/sh date=`date '+%m-%d-%y'`mysqldump -u database_username -pdatabase_password database_name > ~/mysql_backup/database_name.$date.sh


Where would the best place to put the .sh file?

Why ftp? FTP sucks and should be avoided if possible.

I say go with the last script mentioned using mysqldump to backup the database and then use scp or rsync using ssh keys for no password prompts mess in a script if you want to dump it to another server, which is smart for backing up, then its in two locations..

You use ftp when your ISP provides you with FTP backup space the size of your harddisk for free

nix sftp etc dimdadum paddabum.

But if you have a full linux system to backup .. then do the whole ssh shingy dingy

They do that in Scotland? Never heard of any ISP giving users backups space here in the USA. The most ISP's give with standard accounts is 5 to 10MB of space for a homepage...

Germany: 69 Euro all inclusive, really cheap. You can get Debian or Suse on it.
Free traffic of 300 Gig. 2 gig Pentium 80 Gig hard disk 1 gig memory (Probably now cheaper, but you gonna have to start sometimes). It comes with external reboot possibilities, remote tty login, remote repair system etc.

Before we were in the States dead dear.

The system is up now 7 months and runs fine.

Opps I think the term problem is in ISP; i ment hosting provider which is kinda an internet service provider. I worked in Germany at one who did hosting and connectivity, I always mix that up.

Sorry if that wasn't clear.

The FTP space is obviously some big backup solution, which has 100's on them so sftp aint an option until they install it. Traffic for backup is free.

Ahh.. yeah ISP here provides Internet.. Hosting provides hosting. I actually had a host provider that actually provided ssh access which was nice but now I don't believe in spending money for hosting, not when I can do it myself on my own ISP's connection.

We have some finance guys as customers, so it's better to outsource with all the crap they want. Exchange Server 9 Euro's to rent. I'll not gonna buy a windoze machine and then they suddenly decide they want something else next month. Also an NTL business line at home is more expensive than a hosted server with all quirks. Then I would to have buy an extra mchine for all that and when things get bigger and better I would have to buy the next machine.