seiscomp3 icon indicating copy to clipboard operation
seiscomp3 copied to clipboard

quick method to clear all with scdbstrip?

Open filefolder opened this issue 7 years ago • 0 comments

ideally it seems there should be some sort of "--all" flag in scdbstrip (or when --days 0) that can instantly perform something like:

CREATE TABLE new_foo LIKE foo; RENAME TABLE foo TO old_foo, new_foo TO foo; DROP TABLE old_foo;

on each of the pertinent tables, which would take a few moments instead of all but assuring a hard mysql reset.

fwiw the copy/drop method above seems a bit more reliable than "truncate" which invalidates my database in a way i can't comprehend.

filefolder avatar May 23 '18 05:05 filefolder