I have version 4.3 installed.  The issue is that I somehow lost nearly all foreign key relationships of the tables.  I think this was from a backup tool that I used.

How would you recreate these?  I'm in desperate need as the problem will only compound if I upgrade.

Can somebody help me?

I wouldn't say it is painful.  More like impossible.  There are 62 files consisting of 1.5 megs of data.  There has got to be an easier way.

See, there hasn't been a functionality issue with it in a LONG time, so if I restore a previous database then I will lose a whole bunch of content/information.  I am pretty sure the entire issue was caused by backing the database up via a 3rd party component.  It backed up the data, but not the indexes/foreign keys.

It would be ideal if I had a tool where I would say here is one database with the data and here is another with the indexes/relationships, now add the relationships!

Anybody know something like this?  I really need some help with this.