sychn Posted February 2, 2009 Share Posted February 2, 2009 Does IPS have any MySQL tools to clean the non-official tables in the IPB database? Hope IPS can make a tool to delete the tables not belong to IPB/IBlog/IGallary/IDM/Tracker/Shoutbox someday. Link to comment Share on other sites More sharing options...
LeetScape Posted February 2, 2009 Share Posted February 2, 2009 Does IPS have any MySQL tools to clean the non-official tables in the IPB database? Hope IPS can make a tool to delete the tables not belong to IPB/IBlog/IGallary/IDM/Tracker/Shoutbox someday. I think I know what you mean (I'd like that too). I've installed some Mods previously and turned them all off now but am unsure at which tables I can delete in MySQL without it royally messing with my board, I wish there would be a way to (maybe when you update to IPB3) to clear all "unused tables" that haven't been accessed or even modified in 'x' days. Link to comment Share on other sites More sharing options...
AndyF Posted February 2, 2009 Share Posted February 2, 2009 Michael made a tool to help , link > DB Customization Manager v1.2 , however ( I don't want to put you off :) ), it is not automatic and you need to use it with care as you could cause a lot of damage. I'd certainly say to backup before doing anything. Having said that, it is very very useful, and I would not be without it after I tried it, but it needs to be used with care and by someone who knows what they are looking at :) Link to comment Share on other sites More sharing options...
hollland Posted February 10, 2009 Share Posted February 10, 2009 Another way I think would be to install a fresh copy of ipb at a test url or subdomain and then compare its database tables with those from your main forum''s database and the tables that are extra, come out of mods. Link to comment Share on other sites More sharing options...
Michael Posted February 10, 2009 Share Posted February 10, 2009 Another way I think would be to install a fresh copy of ipb at a test url or subdomain and then compare its database tables with those from your main forum''s database and the tables that are extra, come out of mods. Which is essentially what that tool Andy linked to above does. It scans the file used to create all of the database tables, finds the default tables and all default columns in those tables, and compares that to what you have installed, then tells you what extra stuff you have. Link to comment Share on other sites More sharing options...
hollland Posted February 18, 2009 Share Posted February 18, 2009 Which is essentially what that tool Andy linked to above does. It scans the file used to create all of the database tables, finds the default tables and all default columns in those tables, and compares that to what you have installed, then tells you what extra stuff you have. That is a very excellent tool, I use it as well. But I said the above, for those that are nit so comfortable with installing and using mods :) Link to comment Share on other sites More sharing options...
bfarber Posted February 19, 2009 Share Posted February 19, 2009 It's something we are considering adding in the future, but we do not have a tool presently for it. It's especially challenging because we'd want to support properly installed applications and hooks as well... Link to comment Share on other sites More sharing options...
rct2·com Posted February 24, 2009 Share Posted February 24, 2009 So you want IPS to take responsibility for you not carefully logging what you've done to mod THEIR product? Priceless. Link to comment Share on other sites More sharing options...
sychn Posted February 25, 2009 Share Posted February 25, 2009 So you want IPS to take responsibility for you not carefully logging what you've done to mod THEIR product? Priceless. Why do you think it's a responsibility? It's just a tool as same as others in the ACP. Link to comment Share on other sites More sharing options...
rct2·com Posted February 25, 2009 Share Posted February 25, 2009 But why should they CARE about helping you clear up a 'mess' which is nothing to do with them? If the code is no longer there to use the tables, it is completely transparent to their product base. It would cost them money to develop a tool [presumably you'd like them to support it too, if it doesn't work properly, which adds more cost], yet it does absolutely NOTHING to add value to their product. I think that maybe a kind hearted member of the community could provide a tool, but it's unrealistic to expect IPS to offer it, as it makes no commercial sense. Link to comment Share on other sites More sharing options...
sychn Posted February 25, 2009 Share Posted February 25, 2009 But why should they CARE about helping you clear up a 'mess' which is nothing to do with them? If the code is no longer there to use the tables, it is completely transparent to their product base. It costs them money to develop it [presumably you'd like them to support it too, if it doesn't work properly], yet it does absolutely nothing to add value to their product. With the opinions as same as yours, I am afraid Microsoft won't be the Microsoft and Apple won't be the Apple. Link to comment Share on other sites More sharing options...
rct2·com Posted February 25, 2009 Share Posted February 25, 2009 With the opinions as same as yours, I am afraid Microsoft won't be the Microsoft and Apple won't be the Apple. Is that good or bad? ;) Link to comment Share on other sites More sharing options...
sychn Posted February 25, 2009 Share Posted February 25, 2009 Is that good or bad? ;) It doesn't depend on me. :cool: Link to comment Share on other sites More sharing options...
rct2·com Posted February 25, 2009 Share Posted February 25, 2009 Oh. the more I post in this topic, the more my reputation plummets. I'm obviously being a bit strident here. I'm trying to find a 'win-win' in your suggestion. It costs them money to do it [They lose] Those tables remaining there don't break anything in the product [Nobody loses] If the tables are removed, you get some disk space and potentially some memory back, and potentially more performance out of the server [You win, maybe they win too because their software seems higher perfomance?] Maybe others here could add to this list? But at the moment, I just don't see enough value in your proposition to persuade them that it's a good idea. If there were some mods whose functionality is now built into their product, and a script could suck the tables into their product, then there is definitely a 'win-win'. But I don't think that is what you are suggesting. If you did a clean IPB install into a new database then issued a SHOW TABLES SQL command. Then you took your existing database and did a SHOW TABLES command, a quick line by line check would quickly identify the tables you no longer needed and could delete. What if your database had OTHER products installed in it? How would the IPB script know whether those tables were mods or not? If it prompted you, would you know? All in all, this is a lot more complex than it seems, and IMO a simple visual line by line table name comparison would perhaps be safest. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.