I need a favour from a Linux user.

[Dannik]

Folks:

I need a favour. I need to write a cron job to backup a MySQL database. I know precisely how it all works, but frankly, I don't feel confident with the syntax of the *.sh file. I know it's pretty basic stuff, and I could figure it out pretty quickly, but this is for an important project, so it's just got to be right the first time.

If you can and are willing to lend a hand, let me know! The context is somewhat confidential, so details will be exchanged via PM, email, IM, or some other method. The reward? Fame and fortune. Well, a nice thank you, anyway, and the warm fuzzy feeling that you helped me learn something I've wanted to learn for a while now.

[ROCO*AFZ*]

Folks:

I need a favour. I need to write a cron job to backup a MySQL database. I know precisely how it all works, but frankly, I don't feel confident with the syntax of the *.sh file. I know it's pretty basic stuff, and I could figure it out pretty quickly, but this is for an important project, so it's just got to be right the first time.

If you can and are willing to lend a hand, let me know! The context is somewhat confidential, so details will be exchanged via PM, email, IM, or some other method. The reward? Fame and fortune. Well, a nice thank you, anyway, and the warm fuzzy feeling that you helped me learn something I've wanted to learn for a while now.

Your host doesn't have it in cpanel?

like... http://www.tutorialized.com/tutorial/Backu...Cron-Jobs/10745

Maybe this will help

http://www.alphaone-tech.com/tech-support/...;kbarticleid=68

I don't use Linux consistantly enough and our website uses cpanel and can backup from there but the above may assist.

[Dannik]

I've been through those tutorials, and though I understand them perfectly, I'm still looking for the hands-on assistance of someone who's actually done it before.

It would be different if it was a casual situation, but this is a production environment, and I don't want to take even the slightest chance with regards to me hacking out the solution. I know I can do it. It's just that I want backup first.

[firefly2442]

Rsync is a really great backup commandline tool. My backup script is as follows:

#!/bin/bash

echo "Starting backup..."

rsync -a --delete /home/patrick/ /media/ieee1394disk/Documents/

echo "Backup finished!"

exit 0

That's about the extent of my bash scripting knowledge. If you want any help just send me a PM but I think you might be better off going to a more experienced user base for help. Maybe try here?

http://www.linuxquestions.org

edit:

If this is a MySQL backup are you going to do an SQL dump of the database or copy the relational database file (wherever it is...)?

Edited March 5, 2007 by firefly2442