[smithygotlost]

Now ive had a google and this seems to be a very complex area. but i wanna try and make a cron that runs every day at midnight back our database up to a file or email it to us. just not idea how to start.

How do i go about making php back the database up ?

Thanks for your help in advanced
Mike

[End User]

Originally Posted by smithygotlost

How do i go about making php back the database up ?

You don't need PHP. RUn this every night and it'll do a full backup and zip it up. Change the parts in BOLD and also the parts that say "/path/to/..."

#!/bin/bash

# generate the filename for the main DB
BACKUPFILE=$(date +%m-%d-%Y)-main.sql
echo -n "Main database backup file name is: $BACKUPFILE
"
# dump the database to a file
/path/to/mysqldump DBNAME -uDBUSER -pDBPASSWORD --quick -n> /path/to/backup/file/$BACKUPFILE

# zip the file up
/bin/gzip --best /path/to/backup/file/$BACKUPFILE

[wirehopper]

Then, email the file with:

PHP Email Attachment Function | Edmonds Commerce Blog

[smithygotlost]

O very nice

thank you, never thought of doing like that. cant wait to get this running