[opencms-dev] [OC5] Clearing Table cms_backup_files

[Thomas Maerz]

"Roth Olivier" <olivier.roth at think-solve.com> writes:

> I'm using OpenCms5 with a mysql DB on Linux.
> The file cms_backup_files.MYD has reached the filelimit of 2GB, therefor I
> want to clear the table cms_backup_files.
> I presume in this table the files from the OpenCms history is stored, how can
> I empty the history or better how can I reduce it (say: delete history except
> for the last change) ?
>
> Is there a way to do it with the OpenCms workplace ? Or do I have to work
> directly on the DB ? How can I find out wich entries I can delete ?

I think my suggestions won't be the best, but I'd
 
  - make a backup

  - install a new OpenCms B to B
  - install OpenCms B (calling your current installation A)
  - export from A (including all)
  - import to B
  - shutdown your A database server
  - copy your database from B to A


and you will loose your history,
but everything should work.

Regards,
Thomas