Home » Tuck Talk » Announcements » Database repaired
Database repaired [message #4219] Wed, 19 October 2005 21:08 Go to next message
Erin Halfelven  is currently offline Erin Halfelven
Messages: 712
Registered: September 2002
Location: Surf City, USA
Senior Member
Administrator
Tuckerspawn is back up, minus the records of about a day of access. It doesn't look like any posts were lost. Good news, sort of, except mostly it's because no one is posting anything. Smile

- Erin
Re: Database repaired [message #4220] Wed, 19 October 2005 23:40 Go to previous messageGo to next message
OtherEric  is currently offline OtherEric
Messages: 589
Registered: September 2003
Senior Member
Thank you for fixing things. I haven't had much to say the past few days, I'm afraid. Given that the trick the past year was to shut me up, I figure I'm entitiled... Razz
Re: Database repaired [message #4221] Thu, 20 October 2005 04:41 Go to previous messageGo to next message
Ellen Hayes  is currently offline Ellen Hayes
Messages: 684
Registered: September 2002
Senior Member
Erin, what are you doing for a backup strategy?

And you'd BETTER not tell me you don't have one, or I'll send Tuck to eat your systems' soul...


Ellen
nosig
Re: Database repaired [message #4222] Thu, 20 October 2005 23:21 Go to previous messageGo to next message
Brooke  is currently offline Brooke
Messages: 695
Registered: August 2004
Location: Portland, OR
Senior Member
Ellen Hayes wrote on Thu, 20 October 2005 01:41

Erin, what are you doing for a backup strategy?

And you'd BETTER not tell me you don't have one, or I'll send Tuck to eat your systems' soul...



How much will it cost to have you send Tuck to eat the systems at Microsoft? Smile
Re: Database repaired [message #4223] Sun, 23 October 2005 02:37 Go to previous messageGo to next message
Erin Halfelven  is currently offline Erin Halfelven
Messages: 712
Registered: September 2002
Location: Surf City, USA
Senior Member
Administrator
I've exported the database to a big .sql file. I try to do that once a month or so. It can take hours for some reason, I guess because I do it over the internet to one of my home machines. If I logon to the server, I can back up the db to a file there in just a few minutes, I probably should do both things. Smile

Also, the server farm does a backup of my server once a week but the one time I needed that, it wouldn't load. Fortunately, I had them hookup a new HD and I was able to salvage the old disk before discarding it. Cost me $60, not my favorite way to recover from a crash.

- Erin
Re: Database repaired [message #4224] Tue, 25 October 2005 04:06 Go to previous messageGo to next message
Brooke  is currently offline Brooke
Messages: 695
Registered: August 2004
Location: Portland, OR
Senior Member
I suspect that the reason it takes hours is because the SQL server has to do individual accesses for each record. Which likely involves lots of "invisible" data going bac k and forth over the net.

Me, I'd create the db file on the server then FTP that to the home machine.
Re: Database repaired [message #4225] Tue, 25 October 2005 11:45 Go to previous messageGo to next message
rachel.greenham  is currently offline rachel.greenham
Messages: 290
Registered: November 2002
Location: Bristol, UK
Senior Member
Brooke wrote on Tue, 25 October 2005 09:06

I suspect that the reason it takes hours is because the SQL server has to do individual accesses for each record. Which likely involves lots of "invisible" data going bac k and forth over the net.

Me, I'd create the db file on the server then FTP that to the home machine.



The ftp port is open???

ftp is open!

/me falls over.

Or to sum up:

Close it! Use ssh, and with that, scp and/or sftp to transfer files.

(Oh, and you can give that a -C flag to tell the connection to be compressed too, which may help the huge data size issues.)


Rachel
Re: Database repaired [message #4226] Tue, 25 October 2005 21:12 Go to previous message
Erin Halfelven  is currently offline Erin Halfelven
Messages: 712
Registered: September 2002
Location: Surf City, USA
Senior Member
Administrator
Yes, the FTP port is open and I can't close it because there are 30 people using it and not all of them have access and savvy for things like SFTP. Smile But no attacks have come in via FTP so that hasn't really been an issue, all of the most recent attacks have used weaknesses in PHP and MySQL to make the attacks.

I've disabled any bulletin board software running on the server that uses a certain popular PHP forum software as that seems to have been the source, even after recommended patches had been applied. Tukerspawn uses a different forum software, less vulnerable because it isn't so popular.

When I do backups, I do use the compression switch. Smile

- Erin
Previous Topic:The site is back up.
Next Topic:Forum mail not working?
Goto Forum:
  


Current Time: Tue Feb 20 17:12:16 EST 2018

Total time taken to generate the page: 0.01935 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 2.7.7.
Copyright ©2001-2007 FUD Forum Bulletin Board Software