[IPS Blog] IPS Resources - Use the DB Customization Manager to cleanup your site!

[NewsBot]

One thing that comes up with pretty fair regularity on these forums is folks asking for something to remove all of the extra junk in their database that is left over from old mods they had installed. With the size of the IP.Board database, it can be a daunting task to go through and identify what all might be extra or what is actually needed. To address this, I've recently updated one of my own personal favorite modifications, the DB Customization Manager.

This application consists of a series of tools to cleanup various unused database objects. While the most common need is for cleaning up of database tables and columns, there are also tools to clean things like extra skin templates, settings, caches, and language strings.

The way this application functions is like this: It checks all applications you have installed, and looks at the appropriate PHP or XML file for the particular tool you are running to determine which objects it thinks you should have in your database. It then checks your actual database for the same type of object and sees what you actually have in your database. These two lists are then compared and a list of what extra items you have in your database is generated. You are then presented with this list of extra items to determine what to do with it. You can either delete the item or items it found, or leave yourself (or your other staff member) a note explaining what the item is used for. There's a bit of AJAX flashiness built-in to this that lets you do these delete or note-leaving commands on the same page without having to reload anything.

It's important to keep in mind that, in almost all cases, having any extra junk like this floating around in your database is not going to cause any real issues. But by using this tool, you can make sure everything is kept tidy and save a bit of database space. If nothing else, it's a good tool to run to at least determine what extra items you might have in there, even if you don't want to delete them.

Zobacz całą wiadomość