List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:September 30 1999 3:01pm
Subject:Recovering individual tables from backups
View as plain text  
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
Recovering individual tables from backupsPaul DuBois30 Sep
  • Recovering individual tables from backupsMichael Widenius30 Sep
  • Re: Recovering individual tables from backupssasha30 Sep