Jump to content
Sign in to follow this  

[Invisionize.eu] IPS Resources - Use the DB Customization Manager to cleanup your site!

Recommended Posts

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 Artykuł w pełnej wersji

Share this post

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

  • Recently Browsing   0 members

    No registered users viewing this page.

  • Create New...

Important Information

W celu świadczenie usług przez nasz Serwis na najwyższym poziomie, w ramach Serwisu wykorzystujemy pliki Cookies (tzw. ciasteczka). Korzystając ze stron Serwisu IPSBEYOND.PL bez zmiany ustawień przeglądarki będą one zapisane w pamięci urządzenia. Jeżeli nie dokonacie Państwo zmiany ustawień przeglądarki internetowej to wyrażacie zgodę na zapisywanie plików Cookies.