Support » Fixing WordPress » Removing entries from database

  • Penny

    (@aroundadelaide)


    After uninstalling a plugin, there are about 420 entries remaining in the “posts” table that were created by the deleted plugin. They are all the same “post_type”. What is the best way of deleting these entries? I am guessing a SQL query can do it, however, I don’t know much about databases and SQL (usually just enough to get me in trouble 😉 ). I have access to phpMyAdmin.

    Also, is there a way to check beforehand that deleting entries won’t break something else I’m not aware of?

    Thanks!

Viewing 2 replies - 1 through 2 (of 2 total)
  • shamratdewan

    (@shamratdewan)

    you can take a backup of your database, some hosting also allow to just copy the DB to a new db.
    then you can delete your self using query/phpmyadmin.
    to stay on safe side you can use DB clean up plugins, I have used wp-sweep it hasn’t broke my site so far. Still backup first.

    Vishant

    (@vishant123)

    First take backup of you database . if you don’t have much knowledge of sql than must take backup doing anything before.
    Also wordpress store post in two table post and postmeta you need to delete data in both table.
    Happy to help you if you need any more help.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Removing entries from database’ is closed to new replies.