"Error" Serious Database Problem
|
Bluegoldfish
Joined: 2003-01-30
Posts: 2 |
Posted: Fri, 2010-06-04 15:43
|
|
My users are just getting the single word "Error" when they access the gallery. On inspection I have found that although the database admin programme, phpMyAdmin 2.11.9.5, lists the database and the table names, it reports that the table files are missing, e.g. [img]http://east-lancs-rly.co.uk/photogallery/images/dberror.gif[/img] All the gallery software seems to be intact, it appears that the database causing the problem. All the image files are also OK. Now for the worst part... The database backup I have is also corrupted as so I have nothing to restore or rebuild the database from. My hosting company are unable to help as it is not their policy to backup databases for users... annoying but I do understand their position. I know I am grasping at straws, and about to go down for the third time, but does anyone know of a way that I can rebuild or repair the database, short of restoring a backup (which I don't have. See above) and get the gallery back on the air? I could just cope with restoring all the albums and getting the users to re-register, then reassign the appropriate albums to them later. Any help would be appreciated. If I'm on a looser then please also let me know and I can cut my losses, tell all the users what's happened, do a fresh install of the latest version, and walk away quietly. System info follows...
Thanks, Chris Morgan |
|
Posts: 4342
Sorry, but yes
There is no such way
You are on a loser
That would be best.
Actually before doing that, see if you can find out what happened to the db files. Who's the db manager? Is it a shared host? Ask the hosting support to investigate. Maybe there's something borked with the MySQL config that can be fixed.
Posts: 16504
Just an FYI, you can use the add From Local Server method to re-import the images and album structure into your fresh G2 install. But I'd follow Alec's advice first and try and see what went wrong and why, you surely don't want this happening again.
____________________________________________
Like Gallery? Like the support? Donate now!!! See G2 live here
Posts: 4342
This will be of no comfort to you, but might help someone reading this thread in the future: a backup has absolutely zero value - none - nothing - zip - nada - not a jot - unless and until you have demonstrated that you can adequately recover the data from it. A backup plan that deserves the name involves not only taking backups but regularly demonstrating and practising the restoration of data - to a dummy installation, if you like. Otherwise you will only find out too late that the backups that you thought you had are totally useless.
Posts: 2
Thanks for the comments and suggestions. It's pretty well what I expected but nevertheless it was worth asking.
My hosting company does not allow direct access the MySQL files area as the site is on a shared server. This means that I am a little limited in what investigations I can carry out. I have several other databases supporting other parts of the web site and they are OK at the moment. Needless to say I have taken a backup of all of them, and tested restoration. I have used MySQL and phpMyAdmin for many years on a variety of different web sites and have never come across the phenomenon of phpMyAdmin reporting the database and its associated tables when the files containing the tables apparently do not exist.
I shall put it down to experience and reinstall the software. I'll also make an attempt to use add From Local Server to get the images back.
BTW any thoughts as to whether I should install Gallery 2.3.1 or try the new Gallery 3.0 RC1?
Regards,
Chris Morgan
Posts: 16504
G2 or G3? Depends on what you are doing with G2. Do you have lots of users? Do you sell photos? Anything else you do with your G2?
____________________________________________
Like Gallery? Like the support? Donate now!!! See G2 live here