Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 General Discussions
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Display Modes
  #1  
Old 10-01-2006, 10:52 PM
raiderlax's Avatar
raiderlax raiderlax is offline
 
Join Date: Sep 2006
Location: Ontario, Canada
Posts: 499
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Whole BACKUP of forum? PLEASE HELP.

How do I make a whole backup of my forum so that if it went down and I uploaded something then all the posts, users, settings, etc.. would be the same?

Thanks in advance
Reply With Quote
  #2  
Old 10-02-2006, 12:04 AM
peterska2 peterska2 is offline
 
Join Date: Oct 2003
Location: Manchester, UK
Posts: 6,504
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Admincp > Maintanance > Database Backup

Select All YES at the top then scroll down to the end of the list and click save. This will save a copy of your database to your computer. Good practice is to do this every few days.

You may also want to take a backup of the files on your server. I recommend doing this on every modification installation or vB upgrade then you always have an upto date copy of them.
Reply With Quote
  #3  
Old 10-02-2006, 12:50 AM
bada_bing's Avatar
bada_bing bada_bing is offline
 
Join Date: Feb 2004
Location: Michigan
Posts: 1,698
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I use SQLyog enterprise.. Using the build in backup from admincp is good if your a new site with a smaller database but when you get to large you will notice that you will need something external to do yourbackups which is more stable.
Reply With Quote
  #4  
Old 10-02-2006, 02:34 AM
raiderlax's Avatar
raiderlax raiderlax is offline
 
Join Date: Sep 2006
Location: Ontario, Canada
Posts: 499
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by bada_bing
I use SQLyog enterprise.. Using the build in backup from admincp is good if your a new site with a smaller database but when you get to large you will notice that you will need something external to do yourbackups which is more stable.
What is SQLyog enterprise?

bump, anyone please.
Reply With Quote
  #5  
Old 12-12-2006, 11:48 AM
FreshPrince FreshPrince is offline
 
Join Date: Oct 2006
Posts: 108
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I'm also a noob here. I tried to back up my files to my harddrive (into a folder I created on my desktop) but the reply came back "Backup filename must end with the .sql extension." So let's say that I want to save it to:

C:\Documents and Settings\Chuck\Desktop\Backup

Then I changed it to

C:\Documents and Settings\Chuck\Desktop\Backup.sql

But I don't see any such file on my desktop.

Do I need to download some sql program to my computer or something? I really am clueless here.
Reply With Quote
  #6  
Old 12-12-2006, 01:06 PM
chanthuyen chanthuyen is offline
 
Join Date: Sep 2005
Location: 9template.com
Posts: 87
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Backup, restore db :

http://vietlyso.com/vbbskin/showthread.php?t=3
Reply With Quote
  #7  
Old 12-12-2006, 01:43 PM
bada_bing's Avatar
bada_bing bada_bing is offline
 
Join Date: Feb 2004
Location: Michigan
Posts: 1,698
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by raiderlax View Post
What is SQLyog enterprise?

bump, anyone please.
Here is the web address for this application. Very nice backup utility, I have been using it for 2 years now and has no issues backing up small or large database. I have used a couple other tools available and by far this is the nicest...
www.webyog.com
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:04 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.03981 seconds
  • Memory Usage 2,217KB
  • 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
  • (7)post_thanks_box
  • (7)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (7)post_thanks_postbit_info
  • (7)postbit
  • (7)postbit_onlinestatus
  • (7)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