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

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 01-23-2004, 12:29 PM
DJ RRebel DJ RRebel is offline
 
Join Date: Jul 2002
Location: CANADA
Posts: 39
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default *.sql vs *.gz

ok ... first let me state the obvious in that although I understand some concepts of SQL, I'm far from being an expert.

My problem lies in that my vB database is way too big to back-up through vB, and everytime i want to do a back-up, I have to call my host's tech and get them to do a manual 'MySQL dump on the command line'.

Usually this is fine ... but sometimes they do it in *.gz format (even if I specifically ask for it in *.sql).

I've noticed that when I uncompress the *.gz file (which results in a *.sql file), the *.sql is about 2% to 4% smaller than than the corresponding *.sql file that was originally a *.sql file (never compressed).

Considering my *.sql files are about 300 megs for a complete back-up, having a difference of over 5 megs is both perplexing and worrysome.

It seems saving to *.gz seems to be much simpler for them to do, but I can't have the peace of mind I get from a *.sql (never compressed) back-up when it is done via *.gz ...


Could someone please give me a quick explanation of *.gz files, and any potential reasons why the *.sql file uncompressed from a *.gz file is not the same size as the *.sql file that was never compressed ???

Also ... considering what I've mentioned above, what would you recommend I do from now on ??? Get them to do it in *.sql format? Or get it done as a *.gz (which I think I can actually do myself through cPanel5's backup ['download a SQL DB Backup'])


Finally ... is the cpanel backup *.gz file a non-live back-up done automatically once every X hours or X days), or is it created when I attempt the download ... is this feature reliable?

So ... to summorise:

1- Why is a *.sql from a *.gz smaller than a *.sql that was never compressed?

2- How should I back things up in the future (*.gz or *.sql)?

3- How reliable is cPanel5's back-up feature, and is it a 'live' back-up, or simply a file that is saved every X amount of time ???


I really want to start getting more involved in tweeks and hacks ... but I really think the best first step in getting there is actually being able to successfully back-up my data ... lol ... or at the very least ... know when I have a reliable back-up (rather than just hoping my host's tech sent me a complete back-up or not).


Anyhow ... Thanks tons for your feedback and help !!!
Reply With Quote
 


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 01:32 PM.


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.04942 seconds
  • Memory Usage 2,250KB
  • Queries Executed 12 (?)
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)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (2)post_thanks_box
  • (2)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (2)post_thanks_postbit_info
  • (2)postbit
  • (2)postbit_onlinestatus
  • (2)postbit_wrapper
  • (1)showthread_list
  • (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_threadedmode.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_threaded
  • showthread_threaded_construct_link
  • 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