I'm completely down.. I have worked on my site for the past few months. Today I received errors and it looked like some datebase tables were missing... so I went ahead and restored database to yesterday (hosting with GoDaddy).. Normally I don't use any database restores or backups because I use the demonstration module and it works great in restoring in case I make some errors.
Well.. to make the long story short, the database right now is missing users (I had about 30 members so far) and I myself can't access it.
I changed settings.php so I can run update... update only recognized one module (SYSTEM) and shows errors still.. I can't log onto the site because acording to the database I am not a user. Many tables in the database are empty as well..
I can see on some profile tables that there are user ID's for profile values, but there are no users in the database.
Obviously I also had content on the site, ... Right now the table "vocabulary node types" is empty along with many other empty tables..
If I could somehow access my demontration site files, maybe I can try to restore database again... but I don't see any of that in the database.
PLEASE HELP.. I'm crushed.. I was working day in and out on this site, ready to make it more public, and it is all gone.
Most of the modules in the database are disabled, but I don't even know if I should bother enabling them..
I had to enable user module to run update.php.
The errors kept changing... Fatal error: Call to undefined function taxonomy_vocabulary_load() in /html/modules/forum/forum.module on line 175"
while most of the time the errors had to do with core includes folder, so I uploaded a fresh one again...
GoDaddy said that they will restore my database to another date.. for $150 but ended up waving the fee when they looked in the database and saw that most is empty.. however they were not optimistic and said that the database files from prior dates show the same file size as the one i restored to multiple times today.... They also said that it might take up to 10 days to do this :(
Thank you in advance for any help and tips.
Ela
By Ela on
Comments
Well, they helped faster than
Well, they helped faster than expected.. Site is back to normal with restore to 19th :)
_
FYI for future reference, demo module snapshots are stored at sites/default/files/demo by default, unless you change it at admin/build/demo.
Thank you so much for that
Thank you so much for that info!! I was able to restore site thanks to the demo module back to before the problem started, instead of the 19th.. I was wondering how that happen since I could not find any of these files... :) Excuse my lack of knowledge....
I did need to work some more to get the site back to what it was, but it's there now.. yey!!!!!
I am so glad... and knowing now where the files are stored, I assume that I will be able to move or copy them to the directory Godaddy gives if this situation ever happens again, and will be able to restore database from their control panel in case i can't access the site, like it happened to me.. (?)
This was such a scare.. but with a good ending. :) Lesson definitely learned!
ok.. this happened again, and
ok.. this happened again, and again while using the demo module, so I attached more detailed info to the post here: http://drupal.org/node/661678#comment-2477364
I wonder what can cause such crash? if this can happen while cron is running still?
Being that this happened to me before I first tried to go to the control panel with godaddy and First tried to use my own backup file from this module (Copied it to the folder that godaddy lets you use), that restore failed, .. so then I used their backup from yesterday, but that did not help at all... site was still broken. So i called godaddy... and they also were not able to use that back up... but got the site back for me with one of their own files from the day before. Spent more than an hour on the phone with them...
After that I was able to reach the site and use demo..
But now I'm scared about using it..
Can backups used with this module be used for restores using different method? (like godaddy control pannel)
What other ways are there to save your site??
So twice now upon trying to restore a site, it actually crashed it....
Thank you for any thoughts or input.
_
Sorry, I have no experience with godaddy or their control panel so I have no advice on that. I've never had a problem with the demo module, but I don't do resets, just quickie backups. I'd suggest not using the reset functionality until the issue you linked has been sorted out.
As for other backup tools, there's also the http://drupal.org/project/backup_migrate module which lots of folks seem to use.
Thank you for your
Thank you for your reply...
Since you use the demo for quick back ups.. how do you restore using the files that demo creates?
Do you just copy the files to a different folder and then run it with your own back up/restore tool?
Sorry if I'm being a pain.. just trying to learn how to use it well..
Like you said, i might not use it for restores anymore..., but backups are so quick, without loggin in to another site (like godaddy).. so I loved using it, until this happened to me twice now.
_
You're not being pain-- no worries.
I haven't had to restore often, but when I do I either use the command line or phpmyadmin. The demo module just creates a generic sql backup so you can use any tool you know to do the restore.
Thanks so much for your help
Thanks so much for your help :)
For now.. decided not to use the demo module.. though it was one of my favorites.
Will do back ups using godaddy control pannel for now.. see how I like it..
The only pain is the fact of going there and loging in.. :) but hey.. that's not so bad.
Might go with http://drupal.org/project/backup_migrate in the future... You're right a LOT of people are using it..
But I do see on the issues page that some are mentioning tables missing with back ups as well..
So.. for now, as this gave me such a scare, I will just use godaddy tools. That's what they recommended today to ensure backups are not "messing up" the database. Thank you again :)
_
Yeah-- I think the problems with all these backup tools are related to resource limitations or timeouts because they use the web interface. I use demo for quickie backups, but for serious backups i use shell scripts and command line tools.