Skip to content
This repository has been archived by the owner on May 10, 2023. It is now read-only.

quick method to clear all with scdbstrip? #175

Open
filefolder opened this issue May 23, 2018 · 0 comments
Open

quick method to clear all with scdbstrip? #175

filefolder opened this issue May 23, 2018 · 0 comments

Comments

@filefolder
Copy link

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.

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant