Disk Crash :o( - inconsistencies to find.

Hi All

Following a disk problem, all our data has been restored. The data doesn't tie up completely with the database. There were lots of changes going on between the backup of the images and the backup of the database.

As we find them, we're correcting them and all's basically running OK, but there are still some photos without a row in the database (not too serious) and entries (perhaps whole albums) in the database without photos - generates errors.

I ran the process to regenerate thumbnails and it hung about half-way through.

What's the best way to find all these inconsistencies?

Thanks

Alan

Gallery version = 2.2.4 core 1.2.0.6
PHP version = 4.4.8 cgi
Webserver = Apache/2.0.55 (Red Hat)
Database = mysqlt 5.0.45-community, lock.system=flock
Toolkits = Gd, LinkItemToolkit, Thumbnail
Acceleration = none, none
Operating system = Linux web30.extendcp.co.uk 2.6.9-55.0.2.ELsmp #1 SMP Tue Jun 26 16:25:19 BST 2007 i686
Default theme = classic
gettext = enabled
Locale = en_GB
Browser = Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 2.0.50727)
Rows in GalleryAccessMap table = 313
Rows in GalleryAccessSubscriberMap table = 3006
Rows in GalleryUser table = 80
Rows in GalleryItem table = 3002
Rows in GalleryAlbumItem table = 464
Rows in GalleryCacheMap table = 0