LiveWire Network Peer Answers Peer Support Teen Forums Tech Forums College Forums 515 users online 225298 members 1390 active today Advertise Here Sign In
TeenCollegeTechPhotos | Quizzes | LiveSecret | Memberlist | Dictionary | News | FAQ
Member Spotlight
xoxomesmerizedxoxo
Peeves: when ppl ask to many ?s
Mood: Lifeless
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
5 online / 23 MPM
Christmas!
Fresh Topics
  LiveWire / Teen Forums / Member-2-Moderator / Viewing Topic

LiveWire Database Backup
Replies: 6Last 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
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: 899
Join to learn more about ManicD England, United Kingdom | Lesbian Male | Posts: 7,006 | Points: 26,625
LiveWire Humor
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,033 | Points: 3,952
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.

-------
http://www.last.fm/user/fireflyyy

5:10 pm on July 18, 2008 | Joined: Mar. 2007 | Days Active: 700
Join to learn more about circa Ontario, Canada | Straight Male | Posts: 7,065 | Points: 16,581
bighead1991


DOESTHISRANKANNOYYOUUUUUUUUUUU

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,295
Join to learn more about bighead1991 England, United Kingdom | Lesbian Male | Posts: 7,689 | Points: 38,108
Macropiper

Like a Ninja!

Patron
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,397
Join to learn more about Macropiper New Zealand | Straight Male | Posts: 8,998 | Points: 36,900
marshmellowman


wewerepromisedjetpacks

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: 779
Join to learn more about marshmellowman England, United Kingdom | Straight Male | Posts: 24,982 | Points: 44,387
( ManicD )


Swami

Patron
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: 899
Join to learn more about ManicD England, United Kingdom | Lesbian Male | Posts: 7,006 | Points: 26,625
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