MySQL CLean Up

[blueflowers]

I would like to clean up my sql. I have a bunch of stuff on there that I dont use. The only things I want to keep have the prefix
phpbb2

Is there a way I can delete things in the mass instead of individually?

[mitchind]

Need clarification.

You say clean up my sql

Do you mean you want to clean up your SQL code, or do you mean your MySQL database?

If it's SQL - you'll need to provide examples.

If it's the database, you'll need to clean up with phpMyAdmin. Easy as click and drop.

[Buzzman25]

Using phpMyAdmin you can "check all" boxes and then deselect the tables that you want to keep (all the ones with the phpBB prefix) and drop the rest.

As always before you do this make a backup of your database to prevent loss of data.

[blueflowers]

Worked! Cleaned it out. Thanks