Go Back   vb.org Archive > vBulletin Modifications > Archive > Modification Graveyard
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools
vB Database Backup Pro (Lite) for vb 3.6 Details »»
vB Database Backup Pro (Lite) for vb 3.6
Version: 2.12, by Paul M Paul M is offline
Developer Last Online: Nov 2023 Show Printable Version Email this Page

Category: Administrative and Maintenance Tools - Version: 3.6.x Rating:
Released: 09-17-2006 Last Update: 10-09-2006 Installs: 582
Auto-Templates
Re-useable Code Additional Files Translations  
No support by the author.

This modification is no longer available or supported.

When vb 3.5 first came out I was using this backup system on my vb 3.0 - and having nothing better to use - I converted it to work on vb 3.5 (here) and since then I have cut it down and adapted it for vb 3.6.

The original version was by Trigunflame and the rights to the code were bought by Zoints (D.Chapman) in January. A while ago David gave me permission to release my adaption, but until now I haven't got round to it. Trigunflame did mention a few months ago he was working on a new version, but nothing ever appeared.

I have stripped out much of the extra stuff that I do not use (or indeed, could not get to work). This is a simple (lite) version that does a php based dump of your database either as one file, or one file per table. It's been in use on our forum since the day 3.6 was installed.

Notes:
* I will not add anything new to this, or spend vast amounts of time supporting it.
* This is a Lite version to allow people to use the basic 3.0 backup functionality on 3.6.


History:

v2.10 : First internal version.
v2.11 : Bug fixes, some code changes.
v2.12 : Initial Public Release.

Show Your Support

  • This modification may not be copied, reproduced or published elsewhere without author's permission.

Comments
  #42  
Old 09-20-2006, 05:11 PM
bashy bashy is offline
 
Join Date: Nov 2005
Posts: 2,544
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Just checked a backup and my custom avatars part is like this

Code:
/*!40000 ALTER TABLE `customavatar` DISABLE KEYS */;
INSERT INTO `customavatar` VALUES ('1','GIF89a\\\0^\0??\0 \0\Z--\r/0,\r-)&%&4?#\r6#3:/20Lc0N\r2n-8L(;i\ZEK7ll6\"E.O46f;PMNniN\Zhf+PQ.Op2iS3mlK\rQ\"J&N0-ld!`%l4/N<Ht>BOJ5Il7{ApF7rlzs.PPPKXmMqSMpmoQNf[cpkTmrn\r5‹:?\'9ŒG?G?i„,NŽ7R?0sŽ4b?6e?D[ŽDY?Nl?Ki?hy?gx?Na?3€\\;ˆhn‹7P…ZQŒoQ?|e‡[l?qr?x9„‘N?ŽU‘?X?ˆm‘Žo?+p?’t??xŸ?|??|??|??„%“3\0‡.7?>!…9E”K”T7“q4?R ?N0?g?l.?RN?oSŒwn?ZQ?^h?mS+rl?R?P+?k?p0?W+?o\Z?s3?XC?mK?vh?[E?uGŒ{??x€š‹.??8??=—‹P?Œsœ?J„?|?’Q??o??O??p?‡
?‹0ϰ7?’?‰8????,ՏS?”qΰOάs?ŠK?–f??S??p????4??:??O??p??|??N??i??U??pˆ‡†ˆŒ‘†—ˆ‰˜–”‰‡’?”–•‰——–Œš?Œ??‘???“‹ ›??+“???ˆšō??™?⪸ѱ??’?™‘Ϫœ㹡?œ?ѱ?距?Դ?δ????Ż???šŒ?—?ίŽȹ??˜???Š긨þ??????Œ?̴??œ????͍?ѳ??Ž??????????????????????????????????????????????????????????????????????????????????????????????????????\0\0\0\0\0\0\0\0\0!?
NETSCAPE2.0\0\0\0!?\0?\0,\0\0\0\0\\\0^\0\0?\0?	?\'? ?ƒ?$ȏ??{??	?\'??=~????&p߼|??q?ǯž?z???T?1?K„0*X?aL˜?l?÷3\"?x?\n?ƒx‘›Œp8
?/?z?f?T(U??›?P^?:?aA????›g??z2\0H?#…?™??^?J??>‰uc2”6?)Iƒ??I??*—0V? @\0?+‰x?Y?{??L‚6?:??c…!i Sj?%?‡?d?€Pc\n:+4ˆW/F?”?Y?]P?(xb6m\Z?:t|??? 5b H#?\0??[Ȼ;n??n??`?`AŒ;y??`t?t?tj???fEd?™?;?š??›3‡?…B\Zi??B\r<??H.???C\r.??s?p]vUĝ ?3Y^???TS?́
,œ?‚
5??
All the custom avatar bit is like that, what does this mean?
I dont get that if i use phpmyadmin to backup!
Reply With Quote
  #43  
Old 09-20-2006, 07:29 PM
Paul M's Avatar
Paul M Paul M is offline
 
Join Date: Sep 2004
Location: Nottingham, UK
Posts: 23,748
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

It doesn't mean anything.

Open a GIF file in notepad and then ask again .
Reply With Quote
  #44  
Old 09-20-2006, 07:53 PM
bashy bashy is offline
 
Join Date: Nov 2005
Posts: 2,544
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

lol, I know but this aint a gif file, and if i download from phpmyadmin the database dont show any of that....

Just wanting to make sure is all before i rely on it if ya know what i mean.
I just didnt want to find out when i really need it and it was corrupt or sommat
Reply With Quote
  #45  
Old 09-21-2006, 08:22 AM
TheoMessinis's Avatar
TheoMessinis TheoMessinis is offline
 
Join Date: Jun 2005
Location: Athens Greece
Posts: 14
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Excellent!!!

/me clicks install
Reply With Quote
  #46  
Old 09-22-2006, 07:53 AM
dimeola dimeola is offline
 
Join Date: Sep 2006
Posts: 13
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

i have some problem. it works very good but when it tries to take post table`s backup, it stops. i changed timeout period but nothing changed. it doesn`t continue. so it doesn't take backups of tables after post table.

last taken table is Live-2006-09-21-post.sql
Reply With Quote
  #47  
Old 09-22-2006, 05:17 PM
steadicamop's Avatar
steadicamop steadicamop is offline
 
Join Date: Jul 2004
Location: Lancashire, UK
Posts: 379
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by dimeola
i have some problem. it works very good but when it tries to take post table`s backup, it stops. i changed timeout period but nothing changed. it doesn`t continue. so it doesn't take backups of tables after post table.

last taken table is Live-2006-09-21-post.sql
I have the same issue.....
Reply With Quote
  #48  
Old 09-23-2006, 03:47 AM
Paul M's Avatar
Paul M Paul M is offline
 
Join Date: Sep 2004
Location: Nottingham, UK
Posts: 23,748
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

There is nothing I can really tell you. Our post table is fractionally under 500MB and it backs up in just over 4 minutes. I can't see any reason you could not backup much larger tables. I can think your problem is server related, maybe your host can help you.

Edit: Are you running in safe mode, or on windows (IIS), they both can affect the timeout.

Also, manually run the backup from the cron manager and see if you get a timeout error.
Reply With Quote
  #49  
Old 09-23-2006, 07:06 AM
dimeola dimeola is offline
 
Join Date: Sep 2006
Posts: 13
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

safe_mode Off Off

and my hosting plan is linux. i started backup from cron manager, but i don`t get any message
Reply With Quote
  #50  
Old 09-23-2006, 07:21 AM
steadicamop's Avatar
steadicamop steadicamop is offline
 
Join Date: Jul 2004
Location: Lancashire, UK
Posts: 379
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Ditto same, no safe and linux - the only one thing I could suspect is the hosting - they may have set a short execution time for PHP (?)

The manual backup also causes the same issue - it's something other than the software, but damn frustrating.

Cheers,

Jason
Reply With Quote
  #51  
Old 09-23-2006, 07:30 AM
realgoldtalk realgoldtalk is offline
 
Join Date: Sep 2006
Posts: 14
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Hi Paul M,
Thanks for the modification How can i run it manually to test it?
Thanks and Regards,
Saad
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 08:41 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.11362 seconds
  • Memory Usage 2,312KB
  • 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_code
  • (1)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)modsystem_post
  • (1)navbar
  • (4)navbar_link
  • (120)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (2)pagenav_pagelinkrel
  • (11)post_thanks_box
  • (11)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (11)post_thanks_postbit_info
  • (10)postbit
  • (11)postbit_onlinestatus
  • (11)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_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
  • pagenav_page
  • pagenav_complete
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete