Barlee Posted November 13, 2017 Share Posted November 13, 2017 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.. Link to comment Share on other sites More sharing options...
Joel R Posted November 13, 2017 Share Posted November 13, 2017 You could create your own testinstall forums with a new database, and then do a comparison check. Link to comment Share on other sites More sharing options...
bfarber Posted November 21, 2017 Share Posted November 21, 2017 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. Link to comment Share on other sites More sharing options...
media Posted December 19, 2017 Share Posted December 19, 2017 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) Link to comment Share on other sites More sharing options...
Faqole Posted December 19, 2017 Share Posted December 19, 2017 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. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.