+- The VG Resource (https://www.vg-resource.com)
+-- Forum: Archive (https://www.vg-resource.com/forum-65.html)
+--- Forum: July 2014 Archive (https://www.vg-resource.com/forum-139.html)
+---- Forum: Main Stuff (https://www.vg-resource.com/forum-1.html)
+----- Forum: News (https://www.vg-resource.com/forum-2.html)
+----- Thread: Rebuilding Process Information Thread (/thread-24401.html)
RE: Rebuilding Process Information Thread - Dazz - 01-08-2014
This... May actually be of some particular use. There are several pages that aren't in the cache that we can't use our method of grabbing against. I'm not sure when these pages that aren't cached were made though; there aren't many, and we wouldn't need the image files. Only the HTML pages; and only a select few. Once we get to that stage, we'll give you a buzz!
Is there an email or IM client we can contact you on?
You the man, Palculator!
also, anyone not following me on Twitter; this is my day.
https://vine.co/v/h3ZHlYAujg2
RE: Rebuilding Process Information Thread - Palculator - 01-08-2014
(01-08-2014, 04:25 AM)Dazz Wrote: This... May actually be of some particular use. There are several pages that aren't in the cache that we can't use our method of grabbing against. I'm not sure when these pages that aren't cached were made though; there aren't many, and we wouldn't need the image files. Only the HTML pages; and only a select few. Once we get to that stage, we'll give you a buzz!
Is there an email or IM client we can contact you on?
You the man, Palculator!
also, anyone not following me on Twitter; this is my day.
https://vine.co/v/h3ZHlYAujg2
I've sent a PM including the backup. If there's anything more, you can hit me up on the email I registered with.
RE: Rebuilding Process Information Thread - Petie - 01-08-2014
Awesome, thanks!
RE: Rebuilding Process Information Thread - Dazz - 01-08-2014
2712 games reinserted into the database. 1,600~ to go!
RE: Rebuilding Process Information Thread - Ton - 01-08-2014
Wow, that's really awesome. I love seeing the members excited to help out. Great job Dazz and Petie!
RE: Rebuilding Process Information Thread - tigerlily - 01-08-2014
(01-08-2014, 10:29 AM)Ton Wrote: Wow, that's really awesome. I love seeing the members excited to help out. Great job Dazz and Petie!
And me!
RE: Rebuilding Process Information Thread - Dunkelschwamm - 01-08-2014
I do wish there was something I could do to help, this site is very dear to me. I am pretty awful at web coding and don't have much backed up myself, so I'm not sure what I'd be able to assist with personally. Regardless, it's wonderful to see that in case of such catastrophe there's backup plans to ensure nothing but time is lost. Glad to see that you're all progressing so quickly! Can't wait for the site to be rebuilt, keep up the amazing work guys!
RE: Rebuilding Process Information Thread - Quirby64 - 01-08-2014
Dazz, did you already fix RC-pro Am and the Game Boy one?
I found copies of the icons & sheets. could it help?
RE: Rebuilding Process Information Thread - Raz - 01-08-2014
We're back up to 55,385 sheets. We're now just trying to ensure that that is all of the sheets that should be on the site are on the site.
Sit tight, won't be long now.
RE: Rebuilding Process Information Thread - Ton - 01-08-2014
(01-08-2014, 04:05 PM)tigerlily Wrote:I thought that was implied?(01-08-2014, 10:29 AM)Ton Wrote: Wow, that's really awesome. I love seeing the members excited to help out. Great job Dazz and Petie!
And me!
RE: Rebuilding Process Information Thread - Dazz - 01-08-2014
MY BRAIN HAS THOROUGHLY TURNED INTO MUSH. EXPECT US. FUASD{AVVVVVVVVVVVERIOHNVAEPRV
RE: Rebuilding Process Information Thread - Petie - 01-08-2014
We're done! The entire site has been successfully rebuilt and we're now live once again. We did our best to make sure that everything got put back where it was supposed to be but dealing with nearly 56,000 sheets means we're bound to have made some mistakes so please let us know if you spot any.
I'm told that the actual story behind what happened and how we fixed it would be of interest to many of you, especially those with a technical mindset, so I'll post that at some point tomorrow.
Thank you again for your patience and support throughout this ordeal. It truly means the world to all of us.
RE: Rebuilding Process Information Thread - Garamonde - 01-09-2014
Wow I certainly missed a lot in 2 days.
GREAT JOB GUYS.
RE: Rebuilding Process Information Thread - Phaze - 01-09-2014
(01-08-2014, 11:59 PM)Petie Wrote: I'm told that the actual story behind what happened and how we fixed it would be of interest to many of you, especially those with a technical mindset, so I'll post that at some point tomorrow.
Please do. I wanna see how the DB was mangled, if only so I know what not to do with my own
RE: Rebuilding Process Information Thread - Raz - 01-09-2014
(01-09-2014, 04:50 PM)Phaze Wrote:(01-08-2014, 11:59 PM)Petie Wrote: I'm told that the actual story behind what happened and how we fixed it would be of interest to many of you, especially those with a technical mindset, so I'll post that at some point tomorrow.
Please do. I wanna see how the DB was mangled, if only so I know what not to do with my own
Oh SNAP.
This situation came from a mix of problems. tSR has operated on several architectures. We recently moved from FreeBSD back to CentOS after a few years. When we moved over you may remember the new site went live immediately; that wasn't planned and the first time we knew there was an issue with the new site was when it went live. As a result some of the scripts I wrote which needed changed after server move got missed.