On 19 Nov 2010, at 15:23 , Raphael Mazelier wrote:
> Ou utiliser les merveilleux outils perconna, xtradbbackup et innobackupex.
> Parce que ta solution elle lock la base, et ce n'est pas toujours possible.
>
non, elle ne lock rien justement.
man page:
This option issues a BEGIN SQL statement before dumping data from the server.
It is useful only with transactional tables such as InnoDB
and BDB, because then it dumps the consistent state of the database
at the time when BEGIN was issued without blocking any applications.
When using this option, you should keep in mind that only InnoDB
tables are dumped in a consistent state. For example, any MyISAM or
MEMORY tables dumped while using this option may still change state.
The --single-transaction option and the --lock-tables option are
mutually exclusive, because LOCK TABLES causes any pending transactions
to be committed implicitly.
Ou alors tu parles des alter/drop/truncate ?
jym
_______________________________________________
Liste de diffusion du FRsAG
http://www.frsag.org/
