[TYPO3-english] Flags to give to mysqldump

Dmitry Dulepov dmitry.dulepov at gmail.com
Mon Mar 5 14:45:33 CET 2012


Koji Yanagisawa wrote:
> Does anyone pay special care to which flags to use when running mysqldump?  Since Typo3 uses both MyISAM and InnoDB, I sort of figure using --single-transaction should enhance consistency.  It locks tables by default via --opt.  Otherwise I just use --all-databases, but what do you do?

TYPO3 does not use transactions. InnoDB there is for speed only.

I use --opt.

Dmitry Dulepov
TYPO3 core team member
Blog: http://dmitry-dulepov.com/
Twitter: http://twitter.com/dmitryd

Simplicity will save the world.

More information about the TYPO3-english mailing list