Unable to delete a backup set

17 views

Skip to first unread message

Prashant

unread,

Oct 25, 2011, 5:27:38 AM10/25/11

to Xtrabackup Manager

Hi,

I am new user to this excellent tool. I followed the instructions in
the Wiki-QuickStartGuide and Design-Doc.I am using the SVN version
exported as suggested in the Wiki

First I added a volume, where backup would be stored as
./xbm volumes add mydbbackup /path/to/backup/folder/xbm/

Secondly, I added my host which needs to be backed up as
./xbm host add 127.0.0.1 Archive

Third, I added the backup schedule as:
./xbm backup add 127.0.0.1 ondemand-backup ROTATING "45 14 * * *"
mydbbackup /var/lib/mysql/data xbm xbm

Then I tried to delete the backup schedule as:
./xbm backup delete 127.0.0.1 ondemand-backup ROTATING "45 14 * * *"
mydbbackup /var/lib/mysql/data xbm xbm
and
./xbm backup delete Archive ondemand-backup
Both the above resulted in return to the prompt without any error
outputs

The backup schedule list says:
./xbm backup list

XtraBackup Manager v0.5 - Copyright 2011 Marin Software

-- Listing all Scheduled Backups --

and ./xbm-info -l produces

xbm-info -- XtraBackup Manager v0.5 - Copyright 2011 Marin Software

Listing Hosts:

Host ID: 11 Hostname: 127.0.0.1
Description: Archive
Active: Y Last Backup: Display broken for now

Host ID: 1 Hostname: mybackuphost.mydomain.com
Description: Example DB to Backup
Active: Y Last Backup: Display broken for now

How to delete a backup schedule created above ?

BTW, there are no crontab entries which were created earlier by
running the "backup add" command.

Lachlan Mulcahy

unread,

Oct 26, 2011, 5:01:36 PM10/26/11

to xtrabac...@googlegroups.com

Hi Prashant,

The xbm command line configurator that you are using is actually still under development.

Many of the documented commands in the help output do not actually do anything, nor do they return any errors.

Unfortunately I think "delete" is perhaps one of them.

In addition, right now you must use the xbm-flush command to flush your schedule to the crontab - it does not happen automatically.

This will change once the xbm command line configurator is complete.

I'm actually hoping to finish this up over the next few weeks - so my apologies for the half complete tool you are experiencing right now.

I'm glad to see that you somehow managed to get things going a little.

I hope you'll stay tuned to my blog and/or the Google code project and try it out again once I have actually finished the development!

Right now if you want to DELETE the scheduled backup you created, I believe that you will need to go into the database and DELETE the row from the scheduled_backups table corresponding to the scheduled backup you created.

Note: This is really a hack and will leave some orphaned rows behind -- as I said, this will be all handled by the xbm command line tool once it is finished.