Blog Documentation Book a Demo

how to delete everything inside /activity

sollyboisollyboi New
in Vanilla 2.0 - 2.8

i want to delete everything inside /activity since it's causing overloads. i have it self hosted. how can i delete them using sqlquery from phpmysqladmin?

Answers

  • GaryFunkGaryFunk ✭✭
    edited January 2013

    sql="DELETE FROM gdn_activity"

  • sollyboisollyboi New

    will this delete the comments as well inside the discussions? i fear it might... :|

  • GaryFunkGaryFunk ✭✭

    No. It only deletes things that show as Activity.

  • sollyboisollyboi New

    my site is now broken after restart on server after deleting activity contents db :(

  • UnderDogUnderDog MVP

    @sollyboi said:
    my site is now broken after restart on server after deleting activity contents db :(

    Define 'broken'. You made a backup, right?
    Deleting Activity from phpMySQLAdmin is ok to do, so 'broken' might be easy to fix.

    There was an error rendering this rich post.

  • sollyboisollyboi New

    @UnderDog i've fixed the problem it happened because my gdn_discussion db was corrupted

Sign In or Register to comment.