vb.org Archive - Administrative and Maintenance Tools - vB Database Backup Pro (Lite) for vb 3.6

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- Modification Graveyard (https://vborg.vbsupport.ru/forumdisplay.php?f=224)

- - Administrative and Maintenance Tools - vB Database Backup Pro (Lite) for vb 3.6 (https://vborg.vbsupport.ru/showthread.php?t=126925)

Yep, that's an error with mysql - try running a repair on the table, sometimes that can help even though it seems ok.

Quote:

Are you trying to execute this backup from phpMyAdmin or from within vBulletin?

If it's the former, I have justed tested the export function and it worked successfully - you just need to remember to compress the database in a zipped archive at export. If it's the latter, then vBulletin need to explain what it is that needs to be changed, as we cannot be expected to support the workings of their application.

However, judging by the error message you kindly supplied, I would guess that vBulletin requires a bigger PHP memory limit in order to run the backup function. It could be that vBulletin's backup function doesn't compress the database sufficiently or requires a large memory limit - you can increase PHP memory limit using php.ini.

In any event, executing the backup from phpMyAdmin works. If there are functions within vBulletin that are being limited by your current server configuration, please obtain details from vBulletin as to the necessary server requirements so that we can assist you in making the necessary changes. If you have any further questions, please don't hesitate to contact us.

With kind regards from Berlin

Above is the reply I got from my hosts.
I managed to download a backup via vbulletin where I can save to the pc, however if I try to use this mod, or use vbulletins feature and try to save to my webspace it comes back with the memory error.

Would increasing the PHP memory limit using php.ini help? If it would i'll get back in touch with them as I have no idea what it is!

Failing that, anything else I need to ask the hosts?

Thanks

Quote:

Originally Posted by zetetic (Post 1382987)

I upgraded to PHP 5.2.5 yesterday, and the forum didn't re-open after the backup last night. Any idea why that might happen?

Same here. My host installed php 5.2.4.
The common denominator must be php v5.
I disabled the mod.

Quote:

Originally Posted by djbaxter (Post 1383397)

Open /includes/mysqlbackupconfig.php.

Find at lines 8-10:

Code:

  //  Forum Shutdown System

  $backup['SHUTDOWN'] = 0;

  $backup['MESSAGE'] = "The Forum is closed because a database backup is in progress.";

Make sure that $backup['SHUTDOWN'] = 0.

What does this do?
Disables the shut function but still does the backup?

Quote:

Originally Posted by 1996 328ti (Post 1385418)

What does this do?
Disables the shut function but still does the backup?

Yes.

Quote:

Originally Posted by powerful_rogue (Post 1385387)

Would increasing the PHP memory limit using php.ini help? If it would i'll get back in touch with them as I have no idea what it is!

Quite possibly yes, it would. What is your current limit (check in your ACP, at the top of the index page).

Quote:

Originally Posted by Paul M (Post 1385426)

Quite possibly yes, it would. What is your current limit (check in your ACP, at the top of the index page).

Quote:

Server Type SunOS
Web Server Apache v1.3.37 (cgi)
PHP 4.4.7 P
PHP Max Post Size 8.00 MB
PHP Maximum Upload Size 2.00 MB
PHP Memory Limit 20.00 MB
MySQL Version 4.0.27-log
MySQL Packet Size 1.00 MB

I tried using MySqlDumper as well and that timed out as well. That showed I had a Max Execution Time of 30 seconds.

You php memory is currently 20M, I would set it to a minimum of 32M.

JFYI, I use 64M

Quote:

Originally Posted by Paul M (Post 1385517)

You php memory is currently 20M, I would set it to a minimum of 32M.

JFYI, I use 64M

Thanks Paul.

Ive created a php.ini file with the instructions inside:

Quote:

memory_limit=65M
safe_mode=off
max_ execution_time=0

However the chap I spoke to wasnt sure where you would need to place this in the vbulletin directory. Any ideas where I would need to place it? The male was also quite shocked at the size of my DB - currentyl 65MB - Is this large in terms of forums?

Thanks for your help.

You need to ask your host about where to put your ini file.

65M is a fairly small database.

BTW, I would suggest you change the php memory limit to 64M, it's normally set in multiples of 2 (i.e. 4,8,16,32,64,128 etc) - and is not related to the database size.

Quote:

Originally Posted by Paul M (Post 1385597)

Thanks, I'll alter to 64.
He said as he's never used vbulletin before he had no idea what directory it had to go in. I'll check over on vb.com

Thank for all your help, hopefully i'll get this to work!

X vBulletin 3.8.12 by vBS Debug Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)bbcode_code_printable (10)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (2)pagenav_pagelinkrel (1)post_thanks_navbar_search (1)printthread (10)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.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/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.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 printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages:

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.02885 seconds Memory Usage 1,750KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)bbcode_code_printable (10)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (2)pagenav_pagelinkrel (1)post_thanks_navbar_search (1)printthread (10)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.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/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.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 printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: