Re: [Dump-users] Listing the content of a dump file without writing any data?

[Stelian P. <st...@po...>]

On Fri, Jan 04, 2008 at 11:50:44AM +0100, Ernest Beinrohr wrote:

> Hi, I would like to index all my dumps and would therefore like to read 
> the contents of a dump file somehow. I can extract it, I know. But my 
> dumps are quite big 500gb so writimg whem somewhere might be a problem.
> 
> I have found that "restore tvf dumpfile.dmp" gives me a file listing, 
> but it is not sufficent, as there ano NO file sizes and no dates also. 
> How could I get this information from the dump?

Unfortunately 'restore -t' reads a table of contents which is located at
the beginning of the dump, and this table does not contain size and 
date information.

In order to print such information the restore code should scan the entire
dump just like when it does a 'restore -C' for example, and instead of
comparing the file just print out the information. It shouldn't be very
hard to implement if you feel like doing it :)

Stelian.
-- 
Stelian Pop <st...@po...>