Hello: Can you give us more details ? It is in order to narrow your problem
eg. - script used - crontab line where yo call it Are you running that script as root from crontab ? Also I sugget that you must stop mysql before run Any kynd of dump, it is safe way to obtain a "real" database content. --- Ing. Julio Alvarez Tejera Senior Consulter *BSD, Solaris, QNX and Linux Systems Grounding and Lighting Protection Systems Automatic Fire Detection Systems ------------------------------------------ GUVAL Consultores SA, San Jose, Costa Rica Tel./FAX (506) 225 9965 Cell (506) 374 6282 > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > Christine Ross > Sent: Friday, April 16, 2004 9:04 AM > To: [EMAIL PROTECTED] > Subject: [Solaris-Users] cron job to backup mysql database > > > I have 2 servers running mysql and a cronjob that does a > mysqldump to a > file and then backs up the file. On one server where there > is no root > password on the database, the dump works. On the server with > the root > password for the mysql database, the cron job runs but > generates an empty > dump file. If I run the same backup script manually, it dumps > correctly. When it runs as a cron job, it dumps to a zero > length file. I > do not see any errors. Any ideas > > _______________________________________________ > Solaris-Users mailing list > [EMAIL PROTECTED] > http://www.filibeto.org/mailman/listinfo/solar> is-users > _______________________________________________ Solaris-Users mailing list [EMAIL PROTECTED] http://www.filibeto.org/mailman/listinfo/solaris-users
