Re: [cobalt-users] backup script

["E.B. Dreger" <eddy+public+spam@xxxxxxxxxxxxxxxxx>]

IS> Date: Wed, 12 Jun 2002 17:31:36 +0200
IS> From: Ismael Simoes


IS> When I launch this script with root session, everything works
IS> fine.  But when I put the script in crontab job, everything
IS> works fine ... but dump file is empty!!!

"When I launch this script with root session" is key.  Mysqldump
assumes the mysql username of the current Unix user, and a blank
password.


IS> /usr/bin/mysqldump $BASENAME --add-drop-table > $FILENAME

Try changing to:

/usr/bin/mysqldump -uroot $BASENAME --add-drop-table > $FILENAME

and see what happens.  Note that the above assume you needn't
enter a password.

If that works, I'd suggest reading up on MySQL permissions and
tightening things a bit.


Eddy
--
Brotsman & Dreger, Inc. - EverQuick Internet Division
Bandwidth, consulting, e-commerce, hosting, and network building
Phone: +1 (785) 865-5885 Lawrence and [inter]national
Phone: +1 (316) 794-8922 Wichita

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Date: Mon, 21 May 2001 11:23:58 +0000 (GMT)
From: A Trap <blacklist@xxxxxxxxx>
To: blacklist@xxxxxxxxx
Subject: Please ignore this portion of my mail signature.

These last few lines are a trap for address-harvesting spambots.
Do NOT send mail to <blacklist@xxxxxxxxx>, or you are likely to
be blocked.