I'm curious how other people deal with the problem of recovering
a single table in a database from the backup file and the update logs.
The backup may contain mysqldump output for an entire database, and
messing with that in an editor isn't an appealing prospect. That can
be alleviated by dumping tables individually, but you still have the
problem that queries for different tables are all interspersed in the
update logs. You can use --one-database with mysql to replay an update
log for a single database, but how to you deal with replaying updates at
the individual table level?
--
Paul DuBois, paul@stripped
