FoolFuuka/Housekeeping

Revision as of 04:58, 2 January 2019 by Antonizoon (talk | contribs) (Created page with "== Undelete post == Deleted posts by moderators are thrown in the deleted table. It is a hassle to grab stuff, but its not gone forever. # Get mysql workbench and login # ty...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

Undelete post

Deleted posts by moderators are thrown in the deleted table. It is a hassle to grab stuff, but its not gone forever.

  1. Get mysql workbench and login
  2. type in the command SELECT * FROM asagi.a_deleted;
  3. Click that lightning button
  4. The results are the posts. Observe if they are the posts you want.

These commands can be run in mysql console or the mysql workbench

  • Single posts: INSERT INTO `asagi`.`<board>` (SELECT * FROM `asagi`.`<board>_deleted` WHERE doc_id = <doc_id>);
  • Entire thread: INSERT INTO `asagi`.`<board>` (SELECT * FROM `asagi`.`<board>_deleted` WHERE thread_num = <thread_num>);