Fixing database phpmyadmin

I’m having a bit of trouble with my site, things are in places where they shouldn’t be. I have recently done a big deletion of products and it has thrown the site out and I have an idea how to fix it, but I just want confirmation… please help.