[13/01/07] Clean phpBB SQL Tables

[MOD Robot]

MOD Name: Clean phpBB SQL Tables
Author: Vic D'Elfant
MOD Description: Originally designed to clean your database prior to re-installing phpBB, this tool allows you to remove all SQL tables, fields contained by the phpBB tables, and unknown entries in phpbb_config which do not belong to a so-called "vanilla" phpBB installation. This tool is particularly useful if you want to remove all tables/fields which have been created by MODs if you want to start all over again, or to remove a specific MOD.

A resource related to this MOD is the "Re-install / Update phpBB" Knowledge Base article, which can be found here: http://www.phpbb.com/kb/article.php?article_id=271

Note that this MOD currently only works in combination with a MySQL database.


MOD Version: 1.0.9 (Updated 01/13/07)
Tested on phpBB Version: 2.0.22

Download File: clean_tables_1.0.9.zip
mods overview page: View
File Size: 43730 Bytes



Support for this MOD needs to be asked within this topic. The phpBB Teams are not responsible or required to give anyone support for this MOD. By installing this MOD, the phpBB Support Team or phpBB MODifications Team may not be able to provide support.

This MOD has only been tested by the phpBB MOD Team with the phpBB version listed in the topic. It may not work in any other versions of phpBB.

[Darkmonkey]

MOD Validated/Released

Notes:
This tool allows you to remove any alien SQL tables and fields in your database (Those which do not belong to a "vanilla" phpBB installation). It is particularly useful if you want to remove any tables/fields created by a MOD.

A resource related to this MOD is the "Re-install / Update phpBB" Knowledge Base article, which can be found here: http://www.phpbb.com/kb/article.php?article_id=271

Note that this MOD currently only works in combination with a MySQL database.

[Vic D'Elfant]

Although the word "MOD" probably makes you think "let's install it with EasyMOD", I'd recommed you to do it the manual way, as that probably would save you some time. It's just one file which you have to upload anyway.

How to use this tool

Step 1
Open the zipfile and extract the /install directory to your hard drive

Step 2
Create a directory called "install" in the root of your board, and copy the contents of your local /install directory into it

Step 3
Point your browser to the file (e.g. http://www.domain.com/forum/install/clean_tables.php), and you'll see a list of all tables, fields and configuration settings from your SQL database which don't belong to phpBB itself (if any). Remove the checks in front of tables, fields and configuration settings which you don't want to drop. After having double-checked that you are not about to remove valuable data, click the "Clean tables" button on the bottom of the screen

Step 4
Remove the /install directory from the root of your forum. Your board will remain disabled as long as you haven't removed it

Disclaimer

Note that it is entirely your own responsibility to create a backup of your SQL table prior to running this tool. This tool should only be used if you know what you're doing! Assistance on how to remove a specific MOD should be gained from that MOD's support topic

Related resource

The Re-install / Update phpBB Knowledge Base article might be useful in case you're going to use this tool to clean all MOD traces prior re-installing your board

[afterlife_69]

Thanks, This has been extremly useful for eXtreme phpBB

[Vic D'Elfant]

You're welcome

Vic

[Iv@n]

does this remowes all post and users and categories etc. from my forum

[Vic D'Elfant]

... this tool allows you to remove all SQL tables and fields from your database which do not belong to a so-called "vanilla" phpBB installation. This tool is particularly useful if you want to remove all tables/fields which have been created by MODs ...

So no, it will not remove any data like posts, users, categories, etc. It will, however, remove fields which do not belong to a "vanilla" phpBB install (and if you choose to)

Vic



Edit: fixed typo... heh

[DemonBob]

Wow vary usefully. Got rid of all my uninstall mod's tab;e alterations very quick Faster the phpmyadmin

[Vic D'Elfant]

I'm glad to hear it was useful to you

Vic

[Iv@n]

It is must have mod. Excellent.

[whatusername]

This is the I'm looking for! Now I can update to Olympus when it comes!

[Vic D'Elfant]

Hehehe... thanks

The phpBB 2 -> phpBB 3 convertor will probably only extract data from the fields which it'll be able to store in its database though

Vic

[Iv@n]

I started it and it said i have no mods and i have.

[Paul]

Does it delete also not default rows at the config table?

[Anon]

I started it and it said i have no mods and i have.

Well your ones didn't edit SQL did they?