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

Page 14 of 64

Show 40 post(s) from this thread on one page

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)

Paul M

11-18-2006 08:46 PM

Yes, you can use that for MySQL5 as well.

All it does is add the DISABLE KEYS command while the data is being loaded (and then ENABLE them afterwards).

Mudvayne

11-23-2006 06:26 PM

Ok.. Paul.. I just installed it.. I'm using MuSQL v5.0.24-standard-log.. I didn't change any value for this "$backup['MYSQL4'] = 1; // Set to 1 if you are using MySQL4".. I mean keep it as it is.. Then run it from Schedule Task Manager without having any error.. Does that mean its working fine?

Paul M

11-24-2006 07:28 AM

You won't know that until you restore a database using the output file.

kotlt99

11-29-2006 03:08 AM

how does it work ??
I installed but i dont know how to backup database ?

Mudvayne

11-29-2006 05:39 AM

It 'll take the backup automatically using cron.

JimmyN

11-29-2006 11:28 PM

I have a few questions, first of

My database is 30mb, is there a way to keep get it smaller?
Also i would like to archive a few days of database backups and then have a cron script that will remove the old ones so i dont build up a few gig just in backups.

Also if i needed to restore one of these files, how would i do it?
Is there a way i can restore it from script /home/myname/forum_db_backup/
It would take a hour to download it from the server and iv never been able to restore it via php myadmin, (any file over 10mb) as it stops responding and looks up, probally due to timeouts etc.

Thats why id like the server side to restore to save me having to download and upload etc.

Anyone know how this can be done?/or make a script/cron for this hack

Thanks heaps :D

verbosity

12-07-2006 05:35 PM

Thank you so much! Installed and just did a test run, works!

Bounce

12-07-2006 11:50 PM

BRILLIANT !!!!

Works superbly on 3.6.4

Thanks Paul :)

Its taking around 7 mins to run so i've changed the forum off message to suit :)

Quote:

The Forum is closed because a database backup is in progress.
Approx Time for this is 7 mins......

It will be getting run at 3am so shouldnae be many on so letting my forums stay closed whilst it completes it :)

*clicks install*

TonyGau

12-08-2006 04:07 AM

When i test this mod on localhost(windows), it work successful, But when i publish this mod on my server(linux), it not work
I config like

Code:

$backup['DUMP_PATH'] = '/var/www/vhosts/mydomain/httpdocs/diendan/backups/';

and I chmod 777 to backups folder
I click run now Dbbackup in Scheduled Task Manager, display this error

Code:

Database Backup

An error occured during the MySQL backup. Details (Could not open Destination SQL file for writing.)

But I browse backups folder , it create a folder like 2006-12-08 (?)
What this problem ? Can u support me ?

JimmyN

12-09-2006 02:56 AM

Tonygau, check the config backup path is correct, and also chmod 777 the folder.

All times are GMT. The time now is 12:55 PM.

Page 14 of 64

« First

Last »

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01652 seconds Memory Usage 1,736KB 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 (2)bbcode_code_printable (1)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: