Go Back   vb.org Archive > Community Central > Community Lounge
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Display Modes
  #1  
Old 01-16-2006, 08:57 AM
notsonormal notsonormal is offline
 
Join Date: Nov 2005
Posts: 44
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Best way to completly back up your forum/website?

Now that I've got a lot done, I want to be SURE that if theres a huge crash and it all goes kaboom that I have a full backup.

Can someone please fully explain how to back up everything?

Thanks!
Reply With Quote
  #2  
Old 01-16-2006, 09:13 AM
nexialys
Guest
 
Posts: n/a
Default

1 - mirror or ftp everything on your site
2 - export your entire dB with phpMyAdmin

create a ZIP with the content...

BAM, you're done...

what makes the backups so complicated these days ?!

and next time, post in here: https://vborg.vbsupport.ru/forumdisplay.php?f=15
Reply With Quote
  #3  
Old 01-16-2006, 01:32 PM
EricaJoy EricaJoy is offline
 
Join Date: Sep 2002
Location: New York, NY
Posts: 236
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by nexialys
1 - mirror or ftp everything on your site
2 - export your entire dB with phpMyAdmin

create a ZIP with the content...

BAM, you're done...

what makes the backups so complicated these days ?!

and next time, post in here: https://vborg.vbsupport.ru/forumdisplay.php?f=15
Personally what makes it so complicated for me is that phpMyAdmin times out when I do a db backup. I have to do it via shell access.
Reply With Quote
  #4  
Old 01-16-2006, 01:41 PM
nexialys
Guest
 
Posts: n/a
Default

Quote:
Originally Posted by princessfrozen
Personally what makes it so complicated for me is that phpMyAdmin times out when I do a db backup. I have to do it via shell access.
the best thing here is to backup parts of the dB on files that are about 2megs each so there is no timeout...

PHP downloads limits are usually 2megs in size, so it is completely useless to make files bigger... the only way to deal with these big files is by shell...

you can tr to backup with a .zip or a .tgz/tar file, but usually, the transfert is done but not the backup, because the server timeout too... PHP is not good for big transferts...

the biggest tables are usually phrases/templates/posts ... so making these seperate from the others is good when dealing with big forums...
Reply With Quote
  #5  
Old 01-16-2006, 01:49 PM
EricaJoy EricaJoy is offline
 
Join Date: Sep 2002
Location: New York, NY
Posts: 236
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

^^doesnt work when backing up a single one of the biggest tables times out. very annoying but luckily ASO lets me have shell access.
Reply With Quote
  #6  
Old 01-16-2006, 06:52 PM
notsonormal notsonormal is offline
 
Join Date: Nov 2005
Posts: 44
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

thank you
Reply With Quote
  #7  
Old 01-16-2006, 09:38 PM
BENSTER BENSTER is offline
 
Join Date: Jul 2005
Posts: 39
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

C-panel has a Backup feature that download database. I've used it for up to 800 megs before, both to a data center, and to my home box.
Reply With Quote
  #8  
Old 01-16-2006, 11:21 PM
Josh Combs's Avatar
Josh Combs Josh Combs is offline
 
Join Date: Oct 2002
Location: Cincinnati Ohio
Posts: 36
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

ssh access to the mysql server to do your database back up, it is the best way to get the backup.
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 06:01 AM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.04540 seconds
  • Memory Usage 2,226KB
  • Queries Executed 13 (?)
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)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (2)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (8)post_thanks_box
  • (8)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (8)post_thanks_postbit_info
  • (8)postbit
  • (6)postbit_onlinestatus
  • (8)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