MySQL Problem

[Seth Dimbert]

I've got a PostNuke site that runs off of a central MySQL database. When you
install PostNuke, it builds the database. Then, as you add Modules and
Hacks, they write tables around the core tables in the databse, and - in
theory - leave the core tables untouched.

Something I installed didn't. And now my site is broken. (Grrrrr...) The
database is called "biavorg_nuke".

I want a SQL statement that I can run via phpAdmin that will:

1) Make a copy of biavorg_nuke, called biavorg_nuke_copy.

2) Delete biavorg_nuke, making way for me to run the installer and create a
new biavorg_nuke database containing only the core tables.

Then I will run the installer and re-create biavorg_nuke.

Then, I need another SQL statement that will copy all the tables from
biav_nuke_copy that don't exist in biavorg_nuke into biavorg_nuke.

In theory, that will rebuild the site's database, right where it wants it to
be. Whichever offending Mod or Hack that that broke the site by modifying a
core table will be broken... So I'll be able to identify which the little
bugger was.

Can anyone help me out?

-SD