lost my database

[xt3rm]

Due to the hurricanes in Florida, the server hosting my gallery died.  Now the server is back up but the database the gallery was using is gone.  All the files and photos are still on the server though.  What should I do??

Is there any way to get the gallery back up?  I don't mind if the users need to reregister cos theres only a couple, with only 2 user galleries, but theres heaps of photos.  Also there was a phpBB forum integrated but I don't mind if I lose that.

Any help would be appreciated thanks!

[Casper]

I would hope your host will be able to recover the database.  Have you contacted them?

[tanfwc]

Hope you got your copy of database back. I think your host should have offside backup. Let them know and they can help you happily. Don't use angry tone

[Pacjack]

Is there any other way to "regenerate" the database in some way? Or is there any way to add pictures to the database again, when the picture files are still on the server, but not in the database? (except for batch-add)

This because i lost the last two months of my database (pictures, comments) in some strange way...

[kegobeer]

You can't recover the data if there's no backup.  All you can do is batch add the pictures that aren't in your user's galleries and use a tool like phpmyadmin to manually add the other pictures back into your user's galleries.  You won't have any of the extra data, like comments and hits.

[xt3rm]

Thanks for the help guys, greatly appreciated.

I've contacted the host and unfortunately the database can't be recovered.
If I want to readd everything, how would I go about doing it??

I have recreated the database which is now empty and when I go to the site I get the error:

Notice: Undefined index: debug_mode in /home/www/photos/include/functions.inc.php on line 96
Fatal error :
There was an error while processing a database query

Do I need to run install again or something else??

[kegobeer]

Yes, you need to run the installer again.  If you dropped all the tables and recreated your database, there's nothing for Coppermine to connect to.

[xt3rm]

I've run the installer again by deleting the include/install.lock file and it installed properly but when I go to the site I get the error:

Fatal error :
There was an error while processing a database query

Is there somethine else I need to do?
I've tried delteing the database again and I still get the same thing.

[Nibbler]

Enable debug mode and post the real error. If you can't get into coppermine then you'll have to edit the debug_mode value in the config table to 1.

[xt3rm]

Thanks.

Sorry, it was the integrated board that was the problem.  I didn't tell u guys about it.
Anyway I changed the init.inc file to disable integration and it worked.  Then I just changed it back and it still worked.  

Anyway I'm adding all the photos back now.  The batch added files are all done. With the user photos, kegobeer you suggested using phpmyadmin, but that would seem tedious plus I have no idea how to do it.

Would there be another way to add them?  I thought maybe moving the photos over to the batch add area and adding them myself, but how would i go about making it seem as if the user uploaded it themselves and giving them access to their files?