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
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, mikesz@stripped 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:
> This email has been scanned by Netintelligence