[cobalt-developers] Cron job to backup MySQL

[Jay Nelson <jay@xxxxxxxxxxx>]

> I don't recognize the way that you are attempting to 'dump' the database.
> I'll take a look at that later today and see what gives.The way I do it
> is I put the command 'mysqldump -u root --password=password database >> 
backupfile.sql'
> where the second password field is the actual password, database
> is the database you want to dump, and backupfile.sql is a textfile dump of
> the database, in a cron job run by root. Create the cron job with 
'crontab -u root -e.'

mysqldump creates a file of create and insert statements.
mysqlhotcopy copies the databases to another directory while the server
is running.

I got around the problem by using the /etc/my.cnf file instead of /root/.my.cnf
I don't like to use the password in a command-line script as a parameter
because it will show up in all the history logs and possibly on the process
list as part of the process name in ps.

Is it necessary to run crontab?  I just put the file in the cron.daily 
directory.
I thought that the directory was monitored and the process automatically
added to the crontab because of the file timestamps.  It is running nightly
now and I have not used the crontab command.

---------------------------------------------------
DuoMark International, Inc.
6523 Colgate Avenue, Suite 325
Los Angeles, CA  90048-4410 / USA
Voice: +1 323 381-0001
FAX: +1 323 549 0172
Email: jay@xxxxxxxxxxx
WWW: http://www.duomark.com/