The Arcive of Official vBulletin Modifications Site.

vB Database Backup Pro (Lite) for vb 3.6 · **Released**: 09-17-2006

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.

bashy · #42 09-20-2006, 05:11 PM

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???fEd?™?;?š??›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!

Paul M · #43 09-20-2006, 07:29 PM

It doesn't mean anything.

Open a GIF file in notepad and then ask again

.

bashy · #44 09-20-2006, 07:53 PM

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

TheoMessinis · #45 09-21-2006, 08:22 AM

Excellent!!!

/me clicks install

dimeola · #46 09-22-2006, 07:53 AM

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

steadicamop · #47 09-22-2006, 05:17 PM

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.....

Paul M · #48 09-23-2006, 03:47 AM

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.

dimeola · #49 09-23-2006, 07:06 AM

safe_mode Off Off

and my hosting plan is linux. i started backup from cron manager, but i don`t get any message

steadicamop · #50 09-23-2006, 07:21 AM

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

realgoldtalk · #51 09-23-2006, 07:30 AM

Hi Paul M,
Thanks for the modification How can i run it manually to test it?
Thanks and Regards,
Saad

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.06483 seconds Memory Usage 2,293KB 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
Messages:

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!