UBB.Developers Forums UBB.threads 6 V5.php Modifications Database backup

Carl,

here is how I have my backup setup... I telneted to my machine, created a .sh file (shell script) called dodump.sh. The contents are a series of commands to create/update 5 days worth of database backups for you... contents are:

#!/bin/sh

mv /home/mattyj/db_dumps/w3t.dump.4 /home/mattyj/db_dumps/w3t.dump.5
mv /home/mattyj/db_dumps/w3t.dump.3 /home/mattyj/db_dumps/w3t.dump.4
mv /home/mattyj/db_dumps/w3t.dump.2 /home/mattyj/db_dumps/w3t.dump.3
mv /home/mattyj/db_dumps/w3t.dump.1 /home/mattyj/db_dumps/w3t.dump.2
mv /home/mattyj/db_dumps/w3t.dump /home/mattyj/db_dumps/w3t.dump.1

/usr/local/bin/mysqldump --password=mydbPasswd myDBname > /home/mattyj/db_dumps/w3t.dump

obviously, you need to create the appropriate folders and make sure the paths are correct....
save your file, exit, and be sure to chmod 755 dodump.sh to make it executable...

Then, set up a crontab entry by typing crontab -e and entering something similar to: 15 2 * * * /home/mattyj/bin/dodump.sh

That's it!

you might want to run it a couple of times manually to make sure it is creating the files you need...

Does this help at all?

Matt