The Arcive of Official vBulletin Modifications Site.

Backing up data, causes server crash. · **Released**: 05-18-2006

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 · #2 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 · #3 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 · #4 05-19-2006, 02:24 PM

Probably because the hard disk is getting hung - is the database on the same harddisk?

Ntfu2 · #5 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 · #6 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 · #7 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 · #8 05-22-2006, 01:21 AM

Thanks

kmike · #9 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 · #10 05-22-2006, 01:30 PM

Quote:

Originally Posted by Ntfu2

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

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.10084 seconds Memory Usage 2,281KB Queries Executed 25 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (1)bbcode_quote (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)modsystem_post (1)navbar (6)navbar_link (120)option (10)post_thanks_box (10)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (10)post_thanks_postbit_info (9)postbit (10)postbit_onlinestatus (10)postbit_wrapper (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_postinfo_query fetch_postinfo fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create postbit_factory postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end fetch_musername postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!