LiveWire Network Peer Answers Peer Support Teen Forums Tech Forums College Forums 598 users online 211468 members 1515 active today Advertise Here Sign In
TeenCollegeTechPhotos | Quizzes | LiveSecret | Memberlist | Dictionary | News | FAQ
Member Spotlight
derailedjet
Cool Things: The smell of coffee is rather coo...
Mood: Relaxed
You have 1 new message.
Emergency Help
Until you sign up you can't do much. Yes, it's free.

Sign Up Now
Membername:
Password:
Already have an account?
► Invite Friends
► Active Members
► Groups
► Contests
Moderators
3 online / 63 MPM
Fresh Topics
  LiveWire / Teen Forums / Member-2-Moderator / Viewing Topic

LiveWire Database Backup
Replies: 6 — Last Post July 19, 2008 9:44am by ManicD
Welcome to LiveWire!
We're Stronger Together. 		Join the Community
Single page for this topic Email Print Favorite
( ManicD )


Swami
Patron
Support Leader 		Reply
Seems strange to me that livewires database tables corrupted a lil while ago and there were no backups to restore from, I'm aware that several topics would have been lost by doing this, but i would rather have lost a single days topics, than several months worth of past topics.

Are liveWire databases backed up? why was a restore not made?

and yes, i know restoring at this stage would be very time consuming but when it first happened, it would have been a case of taking LW down and deleting the old tables and restoring the new tables, and bringing it back up.

-------
---Suggestions wanted to fill this gap, PM me---

5:08 pm on July 18, 2008 | Joined: Jan. 2006 | Days Active: 883
Join to learn more about ManicD England, United Kingdom | Lesbian Male | Posts: 6,998 | Points: 26,284
Permious

Executive 		Reply
Wouldn't LW lose some ad money when it's down? David likes ad money.

-------
jesus christ was a cunt and a rapist
5:10 pm on July 18, 2008 | Joined: July 2008 | Days Active: 81
Join to learn more about Permious Montana, United States | Straight Female | Posts: 4,038 | Points: 3,957
circa


Enlightened One
Patron 		Reply
Quote: from ManicD at 8:08 pm on July 18, 2008
Are liveWire databases backed up? why was a restore not made?
because davjs is the administrator. that's why nothing is ever done.
5:10 pm on July 18, 2008 | Joined: Mar. 2007 | Days Active: 622
Join to learn more about circa Ontario, Canada | Male | Posts: 6,113 | Points: 14,245
bighead1991


RRRRRAAAAAWWWWRRRRRRRRRRRRRRRR
Sustainer
Tech Support Leader 		Reply
Through the way LiveWire stores topics it splits it into different tables, around 16 different ones for topics, its too hard to put any back in correctly.

-------
bam.
5:10 pm on July 18, 2008 | Joined: Feb. 2005 | Days Active: 1,179
Join to learn more about bighead1991 England, United Kingdom | Lesbian Male | Posts: 7,336 | Points: 35,247
Macropiper


Hastur, Hastur, Hastur
Patron
Tech Support Leader 		Reply
It would be a pain to back up the database tables up, it would also not be too helpful if they had been corrupted for a while.
5:11 pm on July 18, 2008 | Joined: Oct. 2002 | Days Active: 2,271
Join to learn more about Macropiper New Zealand | Straight Male | Posts: 8,904 | Points: 40,583
marshmellowman


non compos mentis
Patron
Support Leader
Tech Support Leader 		Reply
Restoring from a backup that is weeks old would have deleted a lot of new topics and replies. Clearly he didn't want to do that (assuming that backups were made - which would be unfeasibly large). It's better just to lose the old replies. He could have matched the incorrectly assigned replies, but the problem is that the tables are spread across multiple databases (like a RAID) for faster access. This would have made it extremely tedious and hard to manually change the replies and usernames by hand. Then there's also the problem that David wouldn't know who made what reply.

He instead deleted corrupted replies from the database together, albeit removing many topics that were fine.

If there was a backup, I guess David didn't restore it immediately when it happened because he was trying to find out what caused the problem and see if he could fix it an easier way than restoring a motherload of a database. If there wasn't well then he couldn't.

Post edited at 5:14 pm on July 18, 2008 by marshmellowman

-------
and victorious in war shall be made glorious in peace.

5:13 pm on July 18, 2008 | Joined: Feb. 2007 | Days Active: 712
Join to learn more about marshmellowman England, United Kingdom | Straight Male | Posts: 21,304 | Points: 38,545
( ManicD )


Swami
Patron
Support Leader 		Reply
Quote: from Tangaroa at 1:11 am on July 19, 2008
It would be a pain to back up the database tables up, it would also not be too helpful if they had been corrupted for a while.

Its can be automated process that can runs each day, its not hard. And normally corruption is seen pretty rapidly on LW.

Quote: from marshmellowman at 1:13 am on July 19, 2008

Restoring from a backup that is weeks old would have deleted a lot of new topics and replies

Then use regular backups, every 24 hours, it wouldn't be the end of the world to lose a days worth of data on a service that nobody pays for anyway.

And i understand why the database corrupted and could not be repaired, but a restore would have taken a few hours at most, and recovered all but about 24Hours of data. Currently we have lost MONTHS of data. (and its annoying the shit outta me every time i look through my topics, lol)

-------
---Suggestions wanted to fill this gap, PM me---

9:44 am on July 19, 2008 | Joined: Jan. 2006 | Days Active: 883
Join to learn more about ManicD England, United Kingdom | Lesbian Male | Posts: 6,998 | Points: 26,284
Single page for this topic Email Print Favorite

Quick Reply

You are signed in as our guest.

Looking for something else?
 

  LiveWire / Teen Forums / Member-2-Moderator / Viewing Topic

© 2000-2009 LiveWire Peer Support Network
Custom Web Hosting | Teen Advice | Peer Support