Remove All Messages

  • montanan

    (@montanan)


    6 years, 7 months ago

    I have a website built off an old one. I don’t want all the old messages in this new site’s database. Is there a way to delete all old messages. It should have an uninstall feature.

Viewing 5 replies - 1 through 5 (of 5 total)
  • Tinu

    (@tinuch1976)

    6 years, 5 months ago

    would be great, if there would be a “remove all messages” and a “remove all spam” button/possibility!

    Tinu

    (@tinuch1976)

    6 years, 5 months ago

    fortunately I got an only MySQL-Page for my DB

    did it this way:
    count, how many messages will be deleted
    select count(id) from YOURdbPREFIX_posts where post_status=’flamingo-spam’;
    delete them
    delete from YOURdbPREFIX_posts where post_status=’flamingo-spam’;

    if you want to delete trash? replace ‘flamingo-spam’ by ‘trash’

    wordpresslover7

    (@wordpresslover7)

    6 years, 2 months ago

    Hello @tinuch1976 @takayukiste !

    How to delete all records from flamingo – addres book and messages – step by step? I got over 7000 records.

    I have phpMYadmin, but if there is any other more convinient option I will be so grateful.

    I regret @takayukiste used wp_posts instead of seprate SQL table for flamingo which was very bad decision in terms of large websites performance, and even deleting all records for not that advanced users like me.

    Nevertheless @takayukiste is a living legend of Web history 🙂

    wordpresslover7

    (@wordpresslover7)

    6 years, 2 months ago

    I used phpmyadmin, SQL tab and pasted

    delete from wp_posts where post_status=’trash’;

    It removed all trash records from falimingo, posts and pages.

    lwestcott1

    (@lwestcott1)

    6 years ago

    Before you do any of the below MAKE A BACKUP OF YOUR DATABASE!!!

    To delete all flamingo posts and contacts, I used phpmyadmin, SQL tab each of these three queries:
    DELETE FROM wp_posts WHERE post_status="flamingo_spam"
    DELETE FROM wp_posts WHERE post_type="flamingo_inbound"
    DELETE FROM wp_posts WHERE post_type="flamingo_contact"

    Edit:
    Found more to delete from the table wp_postmeta (these meta_key’s likely dependent on your contact form fields):
    DELETE FROM wp_postmeta WHERE meta_key="_field_your-name"
    DELETE FROM wp_postmeta WHERE meta_key="_field_your-email"
    DELETE FROM wp_postmeta WHERE meta_key="_field_your-message"
    DELETE FROM wp_postmeta WHERE meta_key="_field_your-subject"
    DELETE FROM wp_postmeta WHERE meta_key="_from"
    DELETE FROM wp_postmeta WHERE meta_key="_from_email"
    DELETE FROM wp_postmeta WHERE meta_key="_from_name"
    DELETE FROM wp_postmeta WHERE meta_key="_subject"

    Cleared out hundreds of MB of space in my database by doing these queries.

    • This reply was modified 6 years ago by lwestcott1.
    • This reply was modified 6 years ago by lwestcott1.
    • This reply was modified 6 years ago by lwestcott1.
    • This reply was modified 6 years ago by lwestcott1.
    • This reply was modified 6 years ago by lwestcott1.
Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Remove All Messages’ is closed to new replies.