You need to consider things like how you plan to carry out recovery in the event of a failure and portability, then choose options which best meet your needs. You don't really want to go trying someone else's settings without knowing exactly what output you are going to produce and whether that output is usable to you.
'--opt' is default so doesn't need specifying and seems to meet most peoples requirements as it includes many of the most commonly needed options together. John Daisley Email: john.dais...@butterflysystems.co.uk Mobile: 07812 451238 MySQL Certified Database Administrator (CMDBA) MySQL Certified Developer (CMDEV) MySQL Certified Associate (CMA) Comptia A+ Certified Professional IT Technician On Wed, 2009-01-21 at 11:09 -0800, Daevid Vincent wrote: > 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 > > > > ______________________________________________ > This email has been scanned by Netintelligence > http://www.netintelligence.com/email
