HELP! I need a Backup Script to Backup SQL Nightly... [moved]

This might help

It´s no a linux app. but I use backupwhatcher for mysql, it backups databases to local PC



http://www.dswsoft.com/index.php

 

it shouldn't be hard to write a cron job to dump the sql databases via the command line and use some lightweight command line ftp app to send it off.. or it doesn't even have to go anywhere.

I used to have one...
Let me see if I can dig it up.

Chew

 

Checkout MySQLdumper. It is a very useful script that can be tweaked as per requirement.

http://www.mysqldumper.de/en/index.php

 

and this:

"This script will allow you to maintain a database backup at any time interval you set. When you upload it to your server, you may set it up on a crontab and let it run daily, weekly or monthly. This script connects to your database, builds a backup "dump" file, gzip's it and either sends it to your email address or uploads it to an ftp server that you configured and cleans up the temporary files."

http://www.phpfreaks.com/script/view/11.php

 

If it is only nightly - why can you not simply copy from the Cpanel backup that was already made?

/backup/cpbackup/daily/*/mysql

Has all the mysql databases.

You can rsync them or whatever.

 

try

#!/usr/bin/expect -f



set root_pass "123456789"

set hostname "123.45.678.910"



set folder "/backup/cpbackup/daily"



spawn /usr/bin/scp -r $folder root@$hostname:/backup/servername/daily

sleep 3

expect "password: "

sleep 3

send "$root_passr"

interact

 

Bad idea. Never ever have your root password in plain text.