On Wed, 2009-01-21 at 13:36 +0800, mik...@qualityadvantages.com wrote: > Hello mysql, > > I would like to run a PHP script to perform a CRON Database backup to > avoid passing database credentials to the CRON process. Does this make > sense? > > What are the recommended MySQLDump options that should be used in > script and interactive? I am currently only using --opt but should I > be using any others? My Database is running MYISAM.
--opt --complete-insert --flush-logs --force --quote-names --add-drop-database --lock-tables --ins ert-ignore --comments is what I use. If you want my script too, it's here: http://www.daevid.com/content/examples/daily_backup.php