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

Reply
 
Thread Tools Display Modes
  #11  
Old 01-18-2006, 11:27 PM
Guest210212002
Guest
 
Posts: n/a
Default

Quote:
Originally Posted by filburt1
mysqldump is a built-in MySQL program. I have it make daily automatic backups of my site's database via a cron job, completely transparently.
[high]* Guest210212002 notes that anyone wondering how filburt does that should look at his how-to. [/high]
Reply With Quote
  #12  
Old 01-19-2006, 10:52 AM
FleaBag's Avatar
FleaBag FleaBag is offline
 
Join Date: Dec 2001
Posts: 1,674
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

OK so I did the dump overnight. The database according to phpMyAdmin is 210mb... Thegzip of it is 51mb, the gunzipped file is 364mb. Does this sound right? As I've had some trouble with dumps creating databases 600mb in size/being corrupt.
Reply With Quote
  #13  
Old 01-19-2006, 11:11 AM
redspider's Avatar
redspider redspider is offline
 
Join Date: Jul 2005
Posts: 225
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

did you try mysqldumper ?
Reply With Quote
  #14  
Old 01-19-2006, 11:25 AM
FleaBag's Avatar
FleaBag FleaBag is offline
 
Join Date: Dec 2001
Posts: 1,674
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

That's what I did the dump with last night.

EDIT:

redspider you have saved my site! I'm eternally greatful. Reimported via SSH on the new server like a dream. I'll be donating to their project, only script that's managed to back up my database and I have tried many!

On a side note, phpMyAdmin says my 'collation' is 'latin1_swedish_ci'. My site certainly isn't Swedish. Is this going to be a problem?
Reply With Quote
  #15  
Old 01-19-2006, 02:21 PM
redspider's Avatar
redspider redspider is offline
 
Join Date: Jul 2005
Posts: 225
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by FleaBag
That's what I did the dump with last night.

EDIT:

redspider you have saved my site! I'm eternally greatful. Reimported via SSH on the new server like a dream. I'll be donating to their project, only script that's managed to back up my database and I have tried many!

On a side note, phpMyAdmin says my 'collation' is 'latin1_swedish_ci'. My site certainly isn't Swedish. Is this going to be a problem?
I really dont know the anwser to that one but my guess is no.

all we need is someone to integrate this to vbulletin admin panel and this will make backup so easy for the non guru like me .
Reply With Quote
  #16  
Old 01-19-2006, 03:06 PM
FleaBag's Avatar
FleaBag FleaBag is offline
 
Join Date: Dec 2001
Posts: 1,674
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I don't think that will be allowed with the license they distribute under. But something of a similar logic would be a huge benefit. The tool included it useless on most servers with a medium to large database. I understand that SSH can solve the issue, but I have just had to move off a server that did not offer SSH - as a result I had a huge struggle getting the DB off the server. I will test the database later tonight when I finish work.
Reply With Quote
  #17  
Old 01-19-2006, 08:03 PM
redspider's Avatar
redspider redspider is offline
 
Join Date: Jul 2005
Posts: 225
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

let me know if work good for you . Good luck !
Reply With Quote
  #18  
Old 01-20-2006, 12:49 AM
FleaBag's Avatar
FleaBag FleaBag is offline
 
Join Date: Dec 2001
Posts: 1,674
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

It bloody worked!
Reply With Quote
  #19  
Old 01-20-2006, 07:02 PM
redspider's Avatar
redspider redspider is offline
 
Join Date: Jul 2005
Posts: 225
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I really happy for you.
all we need now is someone to make a hack that integrate this to vb .
Reply With Quote
  #20  
Old 02-03-2006, 09:29 PM
tendo's Avatar
tendo tendo is offline
 
Join Date: Jan 2006
Posts: 66
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

this thing is awesome thanks for pointing me to it <3
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 05:02 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.04422 seconds
  • Memory Usage 2,254KB
  • 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
  • (1)pagenav
  • (1)pagenav_curpage
  • (2)pagenav_pagelink
  • (10)post_thanks_box
  • (10)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (10)post_thanks_postbit_info
  • (10)postbit
  • (9)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
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • postbit_imicons
  • pagenav_page
  • pagenav_complete
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete