Open filefolder opened 6 years ago
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.
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.