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: 113
Entire Site: 5 & 1301
Page Staff: tgags123, pokemon x, tgags123, supercool22, SonicOlmstead, Barathemos,
12-22-25 07:03 AM

Thread Information

Views
1,067
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: 697
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: 356


POSTS: 44065/45600
POST EXP: 3520098
LVL EXP: 853652271
CP: 197361.6
VIZ: 127697029

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: 8 days
Last Active: 2 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: 22

POSTS: 68/86
POST EXP: 5891
LVL EXP: 51269
CP: 4441.9
VIZ: 88376

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: 234 days
Last Active: 15 hours

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: 142


POSTS: 5158/6433
POST EXP: 1174779
LVL EXP: 34821300
CP: 195004.3
VIZ: 11354687

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: 2 days

Post Rating: 1   Liked By: Davideo7,

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

zanderlex
dark mode
Level: 270


POSTS: 25955/28821
POST EXP: 1961015
LVL EXP: 327146962
CP: 161890.4
VIZ: 11947895

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: 2 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: 78


POSTS: 947/1561
POST EXP: 32496
LVL EXP: 4238688
CP: 7190.9
VIZ: 356419

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: 27 days
Last Active: 4 hours

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

Davideo7
Level: 356


POSTS: 44132/45600
POST EXP: 3520098
LVL EXP: 853652271
CP: 197361.6
VIZ: 127697029

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: 8 days
Last Active: 2 min.

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

cafeman55
hellno163
Level: 78


POSTS: 948/1561
POST EXP: 32496
LVL EXP: 4238688
CP: 7190.9
VIZ: 356419

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: 27 days
Last Active: 4 hours

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

legacyme3
Lord Leggy - King of IT
Level: 272


POSTS: 27114/27250
POST EXP: 2003421
LVL EXP: 335953983
CP: 42607.9
VIZ: 2987972

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: 1924 days
Last Active: 1924 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.

×