I have a database where 5000 records have been made by injection. Now I want to remove the bad records over the good one. I've been told that I can do it with a query inside phpmyadmin interface. But i don't know the request I should type.Please help me.
what's the difference between the good and the bad ones?
I mean that hackers have made 5000 insertion into my database. The bad ones are the insertion made by the hacker. The good one are the first 50 records. That is what I need to delete them once with one request.
CREATE TABLE temporary_tableau SELECT * FROM hacked_table LIMIT 50;
DROP TABLE hacked_table;
CREATE TABLE hacked_table SELECT * FROM temporary_tableau;
TRUNCATE TABLE temporary_tableau;
or it may be an automated process just creating entries using the registration page -- if you have one. If that is the case, use captcha in your registration page.