Remove multiple rows from table

[Rafa-el]

Originally Posted by Fynnon

thanks for the suggestions
the mod does have a prune option but that removes everything from the chat and i want to keep some of it

i want to delete only specific rows from that table, basically just the last 2/3 of the table, by using an sql command
the size of the is around db if 80MB which is 1/3 of the total so i was thinking maybe i can reduce it to improve speed

In one word: NO.

Besides, even tough reducing the DB size is always good, the main issue is your shoutbox plugin, you're better off with it so I strongly advise you to uninstall it, anyone with minimal knowledge could get into your site and dump the DB with a simple exploit if you use a nulled or abandoned product.