> 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: [EMAIL PROTECTED] WWW: http://www.duomark.com/ _______________________________________________ cobalt-developers mailing list [EMAIL PROTECTED] http://list.cobalt.com/mailman/listinfo/cobalt-developers
