Yes and no
If you are taking info from a live database you would have it in a steady
state to copy it. This means locking the tables.
But once you have a copy of the table all you would need to do is update the
changes from the logs.
Using replication for this I is the most simple way but
Yes. Setup replication and peform the backup on the slave. Provided this is your only
purpose for having a slave, and there are no queries running on the slave, the specs
can be a lot lower than your master/production machine.
-Original Message-
From: Kathy Reyes [mailto:[EMAIL
not quite sure what you mean by locking.
each table will be locked during readout for the dump automaticly for the
time the select runs and delivers data to the dumping program.
it is not needed to lock the tables (more than one) in advance for a dump, but
that, might better for dataintegrety.