LiveWire Network Peer Answers Peer Support Teen Forums Tech Forums College Forums 292 users online 192108 members 266 active today Advertise Here Sign In
TeenCollegeTechPhotos | Quizzes | LiveSecret | Dictionary | News | FAQ
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
4 online / 17 MPM
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 )


Omnipotent One

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 | 818 Days Active
Join to learn more about ManicD England, United Kingdom | Lesbian Male | 6903 Posts | 19177 Points
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 | 81 Days Active
Join to learn more about Permious Montana, United States | Straight Female | 4038 Posts | 3957 Points
circa


Soothsayer

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 | 543 Days Active
Join to learn more about circa Palestinian Territory | Male | 5699 Posts | 11340 Points
bighead1991


Swami

Patron
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.

-------
time out.

5:10 pm on July 18, 2008 | Joined Feb. 2005 | 1020 Days Active
Join to learn more about bighead1991 England, United Kingdom | Lesbian Male | 6382 Posts | 25884 Points
Tangaroa


INSTAAAAAAGIB!

Patron
Support Leader
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 | 2100 Days Active
Join to learn more about Tangaroa New Zealand | Straight Male | 8622 Posts | 34706 Points
marshmellowman


que será, será

Sustainer
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

-------
To find yourself, think for yourself.


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


Omnipotent One

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 | 818 Days Active
Join to learn more about ManicD England, United Kingdom | Lesbian Male | 6903 Posts | 19177 Points
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