PDA

View Full Version : Backing up data, causes server crash.

Ntfu2
05-18-2006, 06:16 PM
I'm trying to backup my attachments, and for some reason everytime i attempt this it causes my server to hang, and then crash :-\ which results in a reboot.

My attachments are pushing 7GB, here are my system specs.
Intel Pentium D 930 [3GHz]
• Generic 1GB DDR2 [1GB]
• Generic 1GB DDR2 [1GB]
• Mainboard Onboard SATAII IDE Controller
• Hitachi DeskStar SATAII HDT722525DLA380 [250GB]

Also, i'm not sure if anyone can help me here with this or not, but on the rare occasion that the backup is perferomed i attempt to move it to my NAS, that is always gaurenteed to cause a crash.

Thanks for any suggestions
dbembibre
05-19-2006, 06:18 AM
With what user make the backup ???
For example i have the atach folder setted with chmod 777 and chown to user apache (the user that start the webserver) fro security.

What soft or script you use for the backup ???
Ntfu2
05-19-2006, 02:18 PM
i simply login to shell, and tar -cvvf the files. I didnt know i could chown the attachment folder to apache and everything still works good?
Erwin
05-19-2006, 02:24 PM
Probably because the hard disk is getting hung - is the database on the same harddisk?
Ntfu2
05-19-2006, 07:54 PM
yes,

I've ordered a new hard disk today, hopefully its installed soon, How hard would it be to move MySQL over to the new disk without loosing any data? I'm on a cPanel server if that matters
Xorlev
05-19-2006, 10:34 PM
A backup drive is the way to go. And it wouldn't be too difficult really. Depending on how you want to go, you could just copy over the datadir to it's own partition and remount it in it's place (I love Linux filesystems :)) or the entire /var directory (if you haven't changed from default). But, be sure to keep backups, and shut off MySQL before starting the move.
Erwin
05-20-2006, 02:22 AM
Very easy. I'll write a How-To on how to do this now.

Here you go:
http://www.vbulletin.com/forum/showthread.php?t=185701
Ntfu2
05-22-2006, 01:21 AM
Thanks
kmike
05-22-2006, 04:24 AM
Isn't it a hardware issue? I'd file a ticket with your host, a server shouldn't hang on the simple disk operations. And on the complex disk operations too, as a matter of fact.
dbembibre
05-22-2006, 01:30 PM
yes,

I've ordered a new hard disk today, hopefully its installed soon, How hard would it be to move MySQL over to the new disk without loosing any data? I'm on a cPanel server if that matters

Sorry for the delay, i follow the following directions many times without issues.

http://www.eth0.us/drive2