Wordpress database optimization

I have a wordpress website, I moved hosting 3-4 times and now the database doesn’t seems to right. There are a lot of database entries that are not set auto increment. I did that manually. Also, there are a lot of tables with similar database entries having different prefix. Like the actual table that I assume is storing the data starts with wp_options and then there is another entry wpndw_option. Should I just go ahead and delete the later one?

I don’t know how you moved your WP installation, but some of the duplicators replicate the database tables with a unique prefix each time. You would need to check the documentation to be sure.

If you’re going to make any changes to your database, make sure you have a backup in case anything goes wrong.

3 Likes