MySQL Problem
Seth Dimbert
seth at dimbert.net
Fri Dec 27 03:38:36 CST 2002
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
More information about the Kclug
mailing list