Mysql DB taking loads of space.

  • andreaog79

    (@andreaog79)


    8 years ago

    Hi all,

    First of all apologise if this isn’t the right section.

    I’ve around 20 wordpress websites which feed twitter taking pics from blogs and posting them on twitter using SNAP – Social network Autoposter.

    Lately I’ve been contacted by the support team to delete stuff as my websites were taking much of space.

    So I went and deleted the pics in wpcontent–>upload, since they were already on twitter so I didnt care.

    Afterwards I’ve noticed loads of space is taken by MySQL database and I was wondering if it’s safe to empty the tables via MYphp admin page. (screenshot below).

    https://i.imgur.com/Sjt80P1.png

    Again I don’t care deleting post and pictures as they’re already on twitter.

    I was also searching for a plugin that deletes post and pix after X days but I could only find AUTO PRUNE POST plgin which didnt work, are you aware of any other plugin?

    Thanks all in advance.

    • This topic was modified 8 years ago by andreaog79.
    • This topic was modified 8 years ago by andreaog79.
    • This topic was modified 8 years ago by andreaog79.
Viewing 4 replies - 1 through 4 (of 4 total)
  • catacaustic

    (@catacaustic)

    No, you can’t delete them. Well, not easily anyway.

    Deleting or emptying the wp_posts or wp_postmeta tables will remove all content from your site.

    If you know what you’re doing you could go through your admin area and delete posts and pages that are no longer needed, and this will remove a bit of space form your database.

    To be honest, the best thing that you can do is upgrade your hosting account to give you more storage space. That way you can keep everything there without the need to delete anything off the server.

    Thread Starter andreaog79

    (@andreaog79)

    Hi catacaustic and thanks for your answer.

    It doesn’t matter if all the post, pages, pics etc are deleted as once the post is generated, the post content is posted as tweet on twitter, therefore stored on twitter server.

    I don’t use wordpress as a landing page or website purposes, the only purpose of my WP websites are as follow:

    – RSS Syndication plugin which feeds wordpress creating a post.
    – Once the post is created, a pluging post the WP post content on twitter.

    Therefore once the post is on twitter I don’t need the contant on WP anymore.

    Just wanted to know if it’s safe emptying wp_posts and wp_postmeta

    without messing up the functionality of the website and other plugins.

    Thanks again.

    catacaustic

    (@catacaustic)

    If you want to delete everything like that it can work – but both tables hold information for more than just posts so emptying them will remove everything (yes, I really mean everything) from your site. They also hold eveyrhing for pages, menus, custom post types, and almost everything else on the site that’s not a taxonomy. Emptying these will most likely create issues somewhere, but it’s mpossible to say without knowing exactly what your site is using and how eveyrthing is set up.

    Thread Starter andreaog79

    (@andreaog79)

    Thanks @catacaustic,

    Understandable, thaat makes sense.

    I’ll clone a WP and be safer deleting first wp_posts and then wp_postmeta and see how it goes.

    Thanks again for your time.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Mysql DB taking loads of space.’ is closed to new replies.

Tags