Remove Ad, Sign Up
Register to Remove Ad
Register to Remove Ad
Remove Ad, Sign Up
Register to Remove Ad
Register to Remove Ad
Signup for Free!
-More Features-
-Far Less Ads-
About   Users   Help
Users & Guests Online
On Page: 1
Directory: 199
Entire Site: 4 & 1043
Page Staff: pennylessz, pokemon x, Barathemos, tgags123, alexanyways, supercool22, RavusRat,
04-26-24 06:05 PM

Thread Information

Views
775
Replies
7
Rating
8
Status
CLOSED
Thread
Creator
Davideo7
03-23-20 08:50 AM
Last
Post
legacyme3
04-20-20 06:22 PM
Additional Thread Details
Views: 532
Today: 0
Users: 29 unique
Last User View
05-27-20
cafeman55

Thread Actions

Thread Closed
Order
 

Database Recovery Finished = Most Content Restored

 

03-23-20 08:50 AM
Davideo7 is Online
| ID: 1380626 | 397 Words

Davideo7
Level: 351


POSTS: 44065/45323
POST EXP: 3473262
LVL EXP: 811933083
CP: 191352.4
VIZ: 121509139

Likes: 5  Dislikes: 0
I'm now finished recovering data that was lost from the accidental database drop that took place at the beginning of this month. Not all of the data was recoverable but a lot of it was. All site features should be functioning properly again. If you had content that wasn't recovered or if you're missing Viz, let me know in this thread.

Here's a list of everything that was recovered:
-Threads
-Posts (some posts got submitted twice)
-Post Edits (only for posts made before 11/7/2019)
-Thread Edits
-Announcements
-Private Messages (only some)
-New Users (most)
-Game Pages
-Game Page Edits (only for games added before 11/7/2019)
-Donations (most; if yours is missing, let me know)
-Page Edits (most)
-User Edits (most)
-Screenshots
-Screenshot Edits (only for screenshots added before 11/7/2019)
-Screenshot Ratings (most)
-Page Comments
-Marketplace Purchases (most)

Content submitted after 11/7/2019 that wasn't recovered:
-Vizzed GO Captures
-Music Ratings
-Music Playlists
-Game Characters
-Marketplace Listings

For those wondering, here's the specifics of what happened. On March 2nd, I was executing an SQL query on the database and somehow there was a typo in the query which resulted into the entire database being dropped (I was also working on the site with only 3 hours of sleep, which is a very very bad idea). I had a backup from November 7th, 2019, but that still meant months worth of data gone. Fortunately I made my new log system (which happened to go live in mid November) very detailed and advanced, so I was able to use it to recover a lot of the data (and I thankfully have it storing data in a different database so it was unaffected by the db drop). It still took me many many hours to write scripts and manually restore the missing data but I prioritized doing so and invested far more hours than what is considered healthy (there were many days which I spent 14-17 hours straight with basically no distractions).

So why didn't I have a more up to date backup? Well the site's database is massive, like 10 GB (30 GB including logs) so it means the site has to be down briefly in order to pull that off. I will be making it a habit of backing up the database from now on though, even if that means the site being down for an hour once a week.
I'm now finished recovering data that was lost from the accidental database drop that took place at the beginning of this month. Not all of the data was recoverable but a lot of it was. All site features should be functioning properly again. If you had content that wasn't recovered or if you're missing Viz, let me know in this thread.

Here's a list of everything that was recovered:
-Threads
-Posts (some posts got submitted twice)
-Post Edits (only for posts made before 11/7/2019)
-Thread Edits
-Announcements
-Private Messages (only some)
-New Users (most)
-Game Pages
-Game Page Edits (only for games added before 11/7/2019)
-Donations (most; if yours is missing, let me know)
-Page Edits (most)
-User Edits (most)
-Screenshots
-Screenshot Edits (only for screenshots added before 11/7/2019)
-Screenshot Ratings (most)
-Page Comments
-Marketplace Purchases (most)

Content submitted after 11/7/2019 that wasn't recovered:
-Vizzed GO Captures
-Music Ratings
-Music Playlists
-Game Characters
-Marketplace Listings

For those wondering, here's the specifics of what happened. On March 2nd, I was executing an SQL query on the database and somehow there was a typo in the query which resulted into the entire database being dropped (I was also working on the site with only 3 hours of sleep, which is a very very bad idea). I had a backup from November 7th, 2019, but that still meant months worth of data gone. Fortunately I made my new log system (which happened to go live in mid November) very detailed and advanced, so I was able to use it to recover a lot of the data (and I thankfully have it storing data in a different database so it was unaffected by the db drop). It still took me many many hours to write scripts and manually restore the missing data but I prioritized doing so and invested far more hours than what is considered healthy (there were many days which I spent 14-17 hours straight with basically no distractions).

So why didn't I have a more up to date backup? Well the site's database is massive, like 10 GB (30 GB including logs) so it means the site has to be down briefly in order to pull that off. I will be making it a habit of backing up the database from now on though, even if that means the site being down for an hour once a week.
The Owner
Owner, Developer, Advertiser, etc
Founder, Mod, Investor


Affected by 'Laziness Syndrome'

Registered: 12-06-04
Location: Wisconsin
Last Post: 4 days
Last Active: 3 min.

Post Rating: 5   Liked By: cid789, Congo!, DrRM, geeogree, thing1,

03-24-20 12:59 PM
LieselSolo is Offline
| ID: 1380670 | 15 Words

LieselSolo
Level: 21

POSTS: 68/84
POST EXP: 5844
LVL EXP: 45728
CP: 4055.6
VIZ: 50324

Likes: 1  Dislikes: 0
Davideo7 : I applaud all your work. It appears that I lost about 9,000 Viz, though.
Davideo7 : I applaud all your work. It appears that I lost about 9,000 Viz, though.
Member

Affected by 'Laziness Syndrome'

Registered: 08-29-14
Last Post: 286 days
Last Active: 1 hour

Post Rating: 1   Liked By: jnisol,

03-25-20 09:31 AM
EX Palen is Offline
| ID: 1380684 | 120 Words

EX Palen
Spanish Davideo7
Level: 137


POSTS: 5158/6183
POST EXP: 1095891
LVL EXP: 30556097
CP: 188035.7
VIZ: 10669052

Likes: 1  Dislikes: 0
Took an immense amount of time and effort, but Vizzed is finally back in the shape it should be. We can't thank you enough to dedicate so much time to the site in the hard times we're facing in real life everywhere in the world.

A bit of a shame that some things couldn't be recovered at all, like the CP we earned for months, but it's a derisory loss compared to what we've been able to recover. We'll be able to recover on our own, so time to be twice as active to make up for the lost ground.

I hope you can now take a break and enjoy your time with your family, you've more than deserved it.
Took an immense amount of time and effort, but Vizzed is finally back in the shape it should be. We can't thank you enough to dedicate so much time to the site in the hard times we're facing in real life everywhere in the world.

A bit of a shame that some things couldn't be recovered at all, like the CP we earned for months, but it's a derisory loss compared to what we've been able to recover. We'll be able to recover on our own, so time to be twice as active to make up for the lost ground.

I hope you can now take a break and enjoy your time with your family, you've more than deserved it.
Administrator
Site Staff Manager, Content Writer, Console Manager
Vizzed #1 Hardstyle fan


Affected by 'Laziness Syndrome'

Registered: 07-03-13
Location: Barcelona, Spain
Last Post: 2 days
Last Active: 1 day

Post Rating: 1   Liked By: Davideo7,

03-25-20 12:59 PM
zanderlex is Offline
| ID: 1380715 | 38 Words

zanderlex
dark mode
Level: 263


POSTS: 25955/28313
POST EXP: 1930156
LVL EXP: 296214722
CP: 156522.2
VIZ: 12362679

Likes: 1  Dislikes: 0
Good to see that everything is working again. I was a bit sad when most of my bio seemed to be deleted but then it reappeared yesterday. Thanks for the effort that you put into bringing everything back.
Good to see that everything is working again. I was a bit sad when most of my bio seemed to be deleted but then it reappeared yesterday. Thanks for the effort that you put into bringing everything back.
Vizzed Elite
Sergei's Mustache


Affected by 'Laziness Syndrome'

Registered: 09-25-13
Location: Inaba
Last Post: 4 days
Last Active: 2 days

Post Rating: 1   Liked By: Davideo7,

04-17-20 12:37 AM
cafeman55 is Offline
| ID: 1382089 | 30 Words

cafeman55
hellno163
Level: 75


POSTS: 947/1486
POST EXP: 30795
LVL EXP: 3676328
CP: 6584.4
VIZ: 293400

Likes: 0  Dislikes: 0
Davideo7 : i think the image thing isn't working every time i tried to put an image on the edit profile and settings no other image appears on the user picture.
Davideo7 : i think the image thing isn't working every time i tried to put an image on the edit profile and settings no other image appears on the user picture.
Trusted Member

Affected by 'Laziness Syndrome'

Registered: 01-15-13
Last Post: 5 days
Last Active: 17 hours

04-20-20 06:45 AM
Davideo7 is Online
| ID: 1382417 | 33 Words

Davideo7
Level: 351


POSTS: 44132/45323
POST EXP: 3473262
LVL EXP: 811933083
CP: 191352.4
VIZ: 121509139

Likes: 0  Dislikes: 0
LieselSolo : Sorry for late response. I sent you the 9000 Viz and then some extra to compensate delay.

EX Palen : Thank you, I appreciate the support

hellno163 : Are you still having issues?
LieselSolo : Sorry for late response. I sent you the 9000 Viz and then some extra to compensate delay.

EX Palen : Thank you, I appreciate the support

hellno163 : Are you still having issues?
The Owner
Owner, Developer, Advertiser, etc
Founder, Mod, Investor


Affected by 'Laziness Syndrome'

Registered: 12-06-04
Location: Wisconsin
Last Post: 4 days
Last Active: 3 min.

04-20-20 04:01 PM
cafeman55 is Offline
| ID: 1382430 | 24 Words

cafeman55
hellno163
Level: 75


POSTS: 948/1486
POST EXP: 30795
LVL EXP: 3676328
CP: 6584.4
VIZ: 293400

Likes: 0  Dislikes: 0
Davideo7 : yes i am i don't know what i'm doing wrong the picture won't show up but the words do next to choose file.
Davideo7 : yes i am i don't know what i'm doing wrong the picture won't show up but the words do next to choose file.
Trusted Member

Affected by 'Laziness Syndrome'

Registered: 01-15-13
Last Post: 5 days
Last Active: 17 hours

04-20-20 06:22 PM
legacyme3 is Offline
| ID: 1382432 | 9 Words

legacyme3
Lord Leggy - King of IT
Level: 268


POSTS: 27114/27250
POST EXP: 2003421
LVL EXP: 317224638
CP: 42531.1
VIZ: 2982476

Likes: 0  Dislikes: 0
RIP my Vizzed GO catches. I hardly knew you...
RIP my Vizzed GO catches. I hardly knew you...
Vizzed Elite
6-Time VCS Winner

One Leggy.
One Love.
One Dream.


Affected by 'Laziness Syndrome'

Registered: 09-14-10
Location: https://discord.gg/YCuUJz9
Last Post: 1319 days
Last Active: 1319 days

Links

Page Comments


This page has no comments

Adblocker detected!

Vizzed.com is very expensive to keep alive! The Ads pay for the servers.

Vizzed has 3 TB worth of games and 1 TB worth of music.  This site is free to use but the ads barely pay for the monthly server fees.  If too many more people use ad block, the site cannot survive.

We prioritize the community over the site profits.  This is why we avoid using annoying (but high paying) ads like most other sites which include popups, obnoxious sounds and animations, malware, and other forms of intrusiveness.  We'll do our part to never resort to these types of ads, please do your part by helping support this site by adding Vizzed.com to your ad blocking whitelist.

×