I'm assuming you're doing this as root (hence the # sign). The way to debug this, as with any script, is to run it manually on the command line and see what errors you get. So if you run the following, what happens?
mysqldump --opt -c -C dp > /var/tmp_save/dproject.sql (not sure if you ran that on the command line, or through cron). mysqldump --opt -c -C dp One of these should give you an error. I'd guess that you need to specify a username and password, since you haven't specifically said you'd set them in a .my.cnf. -Sheeri On 2/20/06, Reynier Perez Mira <[EMAIL PROTECTED]> wrote: > I try to create a cron in Linux (Debian Sarge) and the content for this cron > is a mysql database backup. I read documentation about mysqldump command and > use, but I forgot something because it not works for me. I put this in bash: > # mysqldump --opt -c -C dp > /var/tmp_save/dproject.sql > But when I open .sql file none INSERT statement was added. Is wrong my > command or ... > Regards, > -- > ReynierPM > 4to. Ing. Informática > Linux User: #310201 > El programador superhéroe aprende de compartir sus conocimientos. Es el > referente de sus compañeros. Todo el mundo va a preguntarle y él, > secretamente, lo fomenta porque es así como adquiere su legendaria sabiduría: > escuchando ayudando a los demás... > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
