stevemaury wrote: ↑
Fri Sep 27, 2019 12:47 am
Unlocked at OP's request, but if this continues to be about data recovery, it will be locked again.
Thanks for unlocking my topic steve maury.
Actually I have good news! My tech support at Bluehost were able to retrieve a backup of the forum from 5 days before the crash! See their email below. I don't know how they did it. Maybe with special data recovery tools? Also see my questions below the email about the best way of restoring my database.
Bluehost case manager:
Thank you so much for reaching back out to us. We are so grateful for your patience while we worked to recover a backup of your database, happier2_HappierAbroad.
Though typically not possible nor feasible for us to recover backup images for our virtual private servers, our system operations team has gone above and beyond and spent the past 3 days looking for any remnants of a backup of your server's image from before September 18th.
We are pleased to report that they were able to find a backup from September 13th and extract your happier2_HappierAbroad database from it. This backup is currently imported into a database called happier2_phpbbbackup on your virtual private server. There is also a backup found at /root/happier2_HappierAbroad.tgz
We temporarily modified your /home/happier2/public_html/forum/config.php file to connect to the happier2_phpbbbackup database and your posts appeared as they should. Feel free to connect your PHPBB installation to the new database to restore your posts.
We do strongly advise either downloading manual backups of your sites and databases on a frequent bases. Alternatively you could also remove any content from your drive that is not needed or purchase additional storage and mount it to /backup to take advantage of the automatic backups afforded to our VPS and Dedicated customers.
You can purchase a drive by using the addons tab of your control panel:
Once purchased please take advantage of our support to assist you in getting the drive mounted and your server's backup system configured to help you avoid being put in this situation in the future.
In the meantime, do not hesitate to reach back out to us if there are any other question or concerns you have. Please also feel free to take the survey mentioned at the bottom of the email.
So I guess that now that we have a backup from 5 days before the crash, we will only lose 5 days of posts. Not bad. Anyway, now I have a few questions about restoring my forum database.
1. Should I create a test forum first, and install the restored database backup, to make sure it works and contains all the posts before Sept 13? Or would simply pointing my config.php file to the backup database on my server suffice in testing to see that it works and contains all the posts?
2. Is it better to point my config.php to the restored database backup? Or download the backup and rename it as the same as the current database, and then upload it to my server and replace it? Or use the Restore Database function in my webhost panel, which I assume will simply overwrite the existing database? Which way is better? Does it matter? What would you folks do?
3. I also need to figure out how to export all the posts made after the crash (after September 18) so that I can insert them into the restored database so that the new posts after the crash will be merged into the forum and not get lost. How do I do that exactly? Would I just export the "phpbb_posts" and "phpbb_topics" tables in the new database and then insert them into the backup? Which tables do I export and how do I insert them into the restored backup? Can you give me step by step instructions?
4. Finally, a friend of mine wants all his posts in the forum backed up and exported into a file so he can keep a copy for safekeeping, in case the database gets corrupted again. How would I do that for him? (and others who may request it too?) Do I just export certain tables connected to a specific user number? If so, how do I find his user ID number? And which tables would I export? Can I put all his posts into a single file only? Can I do this from phpmyamin? If so can someone here give me step by step instructions?
Thanks in advance. Sorry for so many questions. I just want to make sure to do this right.
Oh wait. One more question:
5. If I set my server to automate backups, weekly or daily, it will backup my WHOLE site, not just the databases. That will take up too much room in my server, since my site is too big, even if compressed. The static pages of my website are backed up and stored offline, so I don't need to automate a backup for that. Only for the databases. So is there a way to automate my forum database backups only? Would I need a third party app or tool, such as the one by David63 mentioned earlier in this thread? Would that program automate the backups in full?
Actually I already downloaded the program by David63 but it contained no instructions on how to use it, so I'm not sure how to use it. Where are the instructions in it? If he doesn't reply here, I'll just PM him. Did he code that backup tool? If anyone else here knows, feel free to chime in.
Thanks again to all of you for all your help and support and kindness and generosity.