Database clean up tool

[FCB-Mo]

Are IPS going to provide a tool which cleans up the database from all the redundant clutter from IPB 2.x mods so that we have a fresh database for IPB 3?

[rct2·com]

How do you expect them to know what mods you have installed?

And if you have installed mods. how do you expect them to know which ones you want to keep, and which ones you want to delete?

[Graeme S.]

How do you expect them to know what mods you have installed?

And if you have installed mods. how do you expect them to know which ones you want to keep, and which ones you want to delete?

That's not exactly what he meant.

Basically, it would be nice to have a tool that essentially takes all the original tables, etc and removes everything that shouldn't be there by default.

So the tool just takes what is known, and leaves everything that isn't known.

[stetye]

That would be a good tool to have, could do with something like that being made up ;)

[Mark]

We're not intending to provide one I don't think, but there is a third-party one available which I believe the author has stated will be upgraded.

[AndyF]

As far as I know, Michael will be updating his Database tool.

I've used it on 2.3.x and its great :cool: , although given the nature of it its not something you can just use without taking care. :)

[teraßyte]

I've used it on 2.3.x and its great :cool: , although given the nature of it its not something you can just use without taking care. :)

+1

This is not a tool that can be used by anyone (plus it has also a bug in my opinion but Michael is ignoring me so...)

[rct2·com]

Never tried it but.... http://adamspiers.org/computing/mysqldiff/ You will need root access and to be Perl/CPAN literate to install it.

See the example:

$ mysqldiff --debug 4 db:foo --host2=remote.host.com --password=secret bar

Now if InVision were kind enough to provide a remote host with a read-only user and password onto a vanilla IPB database .....