I have had my forum for many years but want to clean out the database, what tables should I keep? I have like 260 of them and would like to remove ones that are no longer in use, I only have the standard forum running now, no p;lugins etc..

You could create your own testinstall forums with a new database, and then do a comparison check.  

There are a few generic things you can do first:

• If you are using a database table prefix (such as ibf_) then you can start by removing any tables that do not start with this prefix
• After the table prefix, all tables are now prefixed with their application (e.g. ibf_core_*, ibf_gallery_* and so forth) so you can remove any tables that do not correspond to a current valid installed application.

Beyond that, you would need to compare the tables to what are presently used. The easiest route as suggested by Joel is probably to perform a fresh installation somewhere and then manually compare the tables.

I am not comfortable to do this by myself....  

Is there anyway IPB would write a new script and figure out which database are not in USE or OLD?

Then I can check those and make sure that safe to delete (double check)

24 minutes ago, media said:

I am not comfortable to do this by myself....  

Is there anyway IPB would write a new script and figure out which database are not in USE or OLD?

Then I can check those and make sure that safe to delete (double check)

I doubt that Ipb would write a script for it. But you can request one in the request section.

Anyways, make a backup of the database before you start deleting stuff from it.

Edited December 19, 20177 yr by Faqole