Add new comment
Want to support HowtoForge? Become a subscriber!
|
Hi,
If your tables are in innodb you can use the --single-transaction option.
You can do your dump with your slave active with this.
--single-transaction
Creates a consistent snapshot by dumping all tables in a
single transaction. Works ONLY for tables stored in
storage engines which support multiversioning (currently
only InnoDB does); the dump is NOT guaranteed to be
consistent for other storage engines. Option
automatically turns off --lock-tables.I use kls backup for backing up my system.
Reply |



Recent comments
5 hours 51 min ago
9 hours 34 min ago
9 hours 44 min ago
9 hours 50 min ago
11 hours 35 min ago
15 hours 33 min ago
1 day 3 hours ago
2 days 12 hours ago
2 days 16 hours ago
2 days 17 hours ago