From: Date: July 29 2003 11:01pm
Subject: Deleting unused backup history - Was: Adminstrating backup mediums
List-Archive: http://lists.mysql.com/maxdb/17136
Message-Id: <3F26E0C5.6C94243@Czekalla.COM>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Hi Chris,

Chr.Zink@stripped wrote:
> 
> With the help of the dbmcli commands "medium_get" and "medium_getall" it is
> posible to list all the created mediums for a database. "medium_delete" is
> used to delete a specific medium.
> 
> Every backupfile of a medium also has an unique id (as you can see in the
> dbm.knl of a specific database).
> 
> The "medium_delete" command only excepts mediumlabels as option. My problem
> at this point: I've created a medium serveral times with different
> backupfiles. So how is it posible to delete a specific backupfile (via backupfilename
> or the unique id)?

you are right, medium_delete is only for deleting unused media
definitions.

There were already many questions also mentioned to me and I forwarded
this wishes to the development but so far there is no solution for
steady growing backup histories. Especially database users which do
hourly log backups get huge histories in a very short time!

Some couldn't wait for an official tool and started to delete manually
entries in the history files but this is a little bit more complex than
to delete lines in one file. Instead, as far as I know, up to three
files has to be manipulated in a consistent way so that you don't loose
the very important backup history.
So, please be careful.

But maybe this list can help to get a simple functionality here :-) ...

Ciao Ralf