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
First of all, I'd like to point to the documentation =]
http://www.mysql.com/doc/B/a/Backup.html
The other option not mentioned there but that another list member
suggested is the best way to backup a live database. The above two
methods work, but with larger databases, having the tables locked
Ok, based on the given syntax from the mysql manual..
UPDATE [LOW_PRIORITY] [IGNORE] tbl_name
SET col_name1=expr1, [col_name2=expr2, ...]
[WHERE where_definition]
[ORDER BY ...]
[LIMIT #]
I've been trying to update some records in a test database I've been
playing with. I'm