Skip to content

Instantly share code, notes, and snippets.

@avkosme

avkosme/Recreate idb table.sql

Created May 24, 2021 04:55
Show Gist options
  • Save avkosme/e239df901a4d5c2ae3a6af37bcebbfe8 to your computer and use it in GitHub Desktop.
Save avkosme/e239df901a4d5c2ae3a6af37bcebbfe8 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Recreate idb table.sql
CREATE TABLE <NEW.NAME.TABLE> LIKE <TABLE.CRASHED>;
INSERT INTO <NEW.NAME.TABLE> SELECT * FROM <TABLE.CRASHED>;
Rename NEW.NAME.TABLE and TABLE.CRASH
RENAME TABLE <TABLE.CRASHED> TO <TABLE.CRASHED.BACKUP>;
RENAME TABLE <NEW.NAME.TABLE> TO <TABLE.CRASHED>;
After work well, delete
DROP TABLE <TABLE.CRASHED.BACKUP>;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment