K_Rivers Posted November 13, 2012 Share Posted November 13, 2012 Hion the 12th of Nov around 17:00 GMT i had a mysql database mishap whilst installing an addon in my xenforo forum.The Database is unretrievable in its current state from my perspective.Lucky enough i made a mysql DB backup at 8:41 and a full site backup in the morning around 9:50. when trying to reimport the tables of the backup into a new DB, i noticed to my horror that it was a partial download, only 774kb compressed..So i compared a previous backup i made from the 7th of nov and the size was staggeringly different, uncompressed it was 33.7mb on the 7th of nov and the backup i made on the 12th in the morning was 9mb, the 12/11/12 8:41 GMT backup is what i need to retrieve. I must point out that i renamed the DB i want to retrieve from krivers_prserver to krivers_prserver_old, created a new krivers_prserver and tried to reimport the tables from a previous DB i made on the 7th of nov. I believe this partial download was through some error of my browser, and i didnt notice until it was too late. What im hoping for is if one of the heliohost techs can somehow retrieve the backup of that mysql DB i made on the 12th nov @ 8:41 GMT? or perhaps a day earlier. Like ive previously stated a backup made later that evening around 17:00 will be of no use as that is around the time when the db error occurred. My Account name is: kriversthe DB name at the time was called : krivers_prserver now renamed to krivers_prserver_olddont know if that bares any relevance any help is much appreciatedRivers __________________________________________________________________________________________________________________________________________EDIT so i seems to me that something went wrong with the backup on the server somehow, because both the partial mysql db downloadand the fullsite backup download both have the DB's missing or corrupted. As you can see below the backup selected is only 778KB in size made on the 12.11.12 and the previous one made on the 7.11.12 is at 4mb Here you can even see the size difference between the full site backup, between the 11.12.2012 and the 11.6.2012 (mind the american dates and the timezone differences.) this size difference is due to the fact that all my personal DB's are missing from the full backup some how... the most recent fullsite backup ont he right is missing all its mysql db'ss Seriously, what gives....can a tech retrieve the backup made ont he 12.11.12 with the databases intact? Link to comment Share on other sites More sharing options...
Krydos Posted November 13, 2012 Share Posted November 13, 2012 Heliohost does not create or save any backups of any kind for users, so the only backups of your database or site would be located in your home directory or downloaded to your personal computer -- if you created any -- which you have as much access as an admin to search. There is no recycle bin or anything like that where old versions of databases are saved. Once something is deleted or overwritten the old version is gone forever. Link to comment Share on other sites More sharing options...
K_Rivers Posted November 13, 2012 Author Share Posted November 13, 2012 no that did not solve my problem in the slightest....can you explain why the cpanel didnt backup my mysql databases!! this problem has been caused by this server, not me.I took the precautionary measure to backup it up and the backup feature failed...eexplain that Link to comment Share on other sites More sharing options...
Krydos Posted November 13, 2012 Share Posted November 13, 2012 I guess I misunderstood. I thought you were asking for your old data back, but apparently you are simply asking why the backup didn't work. I have tested the backup database feature on several MySQL databases on Stevie server and after verifying the data in the backup everything seems to be working fine for me. Link to comment Share on other sites More sharing options...
K_Rivers Posted November 13, 2012 Author Share Posted November 13, 2012 all my backups have been fine previously but this one, its not very reassuring when you rely on this feature a lot.im lucky i had a backup from 5 days previous, otherwise i would have been screwed Link to comment Share on other sites More sharing options...
Krydos Posted November 13, 2012 Share Posted November 13, 2012 You're the first one that I can remember to report an issue like this happening in the last 3-4 years that i have been active on the forums of the 20,000 or so accounts so it must not be very common. Link to comment Share on other sites More sharing options...
K_Rivers Posted November 13, 2012 Author Share Posted November 13, 2012 obviously not, well ive taken even further precaution so this doesnt happen again, and ive managed to recover everything fromt he 7th backup thank godthanks anyway Link to comment Share on other sites More sharing options...
Krydos Posted November 14, 2012 Share Posted November 14, 2012 Thank you for reporting this issue. You can be assured that we will be watching for anything like this to happen again, and any cause that might lead to database backups failing. If it happens again or if you find a way to reproduce the error please don't hesitate to let us know. I'm glad you were able to restore your databases with a minimum of data loss. It really does sound like you did everything right except verifying that the database backups were complete. Link to comment Share on other sites More sharing options...
Recommended Posts