vb.org Archive - Administrative and Maintenance Tools

Page 5 of 9

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 (https://vborg.vbsupport.ru/showthread.php?t=167276)

Paul M

06-23-2008 06:52 AM

Nope, both will have the date.

Artes_Marciales

06-23-2008 07:03 AM

OK, thanks Paul.
then if I have to restore the data base I have to rename all of the files? : (

Best Regards!!

Paul M

06-23-2008 11:31 AM

Why do you have to rename the files, there is no reason to have to do that.

abdelghani68

06-24-2008 08:00 AM

Thanks for this hack.

Can you help me please, i have some probleme with some emphasis.

how to resolve the problem

thanks

Artes_Marciales

06-24-2008 08:29 AM

Quote:

Originally Posted by Paul M (Post 1556738)

Why do you have to rename the files, there is no reason to have to do that.

Ok thanks.
then like I must restore a data base?

I thought that files should have had the same names than originals :rolleyes:

Best Regards!! : )

fedorama

06-28-2008 12:45 PM

I'm pretty green and would love if someone can hold my hand here -

OK, I downloaded it, and read the instructions, here -

Installation.

1. Copy all files in the 'includes' folder to the server.

2. Set your choice of options in the mysqlbackupconfig.php file.

3. Upload the product XML via the Product Manager.

4. Alter the timing of the cron job to suit.

OK, so I understand 1, 3, and 4, but how do I set choices in the mysqlbackupconfig.php file , can this be done AFTER from the acp, or the actual file needs to be edited ( I'm no programmer or coder, and have no clue what to edit)

The most important thing - WHERE should the back-up go - I read here it's unsafe to put it in the public_html, and should be in the root.

Would someone kindly assist me (pm or here, or in the forums) to go thru it step by step - my database is not large now, about 30 MB, but I need to back-up now and weekly.

Paul M

06-28-2008 04:39 PM

For option 2 you edit the actual file.

captainron19

06-30-2008 02:07 PM

Excellent Mod - just installed - couple of quick questions...

Is it recommended I turn off boards to do a backup? I just did a "Run Now" in the scheduled Task Manager and it backed up my entire forum in about 30 seconds at 40MB (so it is not that large)

Will it overwrite the previous backup or will I have to routinely ftp in and delete the old files?

Currently I am saving backups in public_html/backups with path being ../backups/

I understand it is not wise to have in acceptible location where accessible by public so where should I save to and what would the path to that section be?

I was going to protect the directory with ausername and password but I am assuming that if I do that it will not only prevent unwanted people from accessing but it will also prevent the mod from saving the backup file to that location.... true?

any help would be appreciated

Paul M

06-30-2008 03:50 PM

Where you save it will be server dependant, but outside your public folder would be best.

If you mean an htaccess user/password, then that should not affect this mods ability to write to the folder.

Previous backups will not be overwritten unless they are named the same.

captainron19

06-30-2008 04:03 PM

Quote:

Originally Posted by Paul M (Post 1563151)

If you mean an htaccess user/password, then that should not affect this mods ability to write to the folder.

not sure about htaccess user/password - whenever I want to protect a directory I just go into cpanel and click on "protect files and folders" and then choose a folder to protect and designate a username and password

Jase2

07-01-2008 08:48 PM

Hi Paul,

A few questions. Currently, I have one .sql per table. How would I change this? Also, what would you recommend: One file named the same each time so that it is overwritten, or one .sql per table. Personally, I think if you should ever need to restore a backup, then one .sql per table is possibly better, since you may only need to restore a certain table, ect.

Oh, as mine currently is, one .sql per table, I usually delete one or two backups after a few days and save usually three, but when I delete them, I ALWAYS optimize the tables afterwards. Is this needed or not?

Paul M

07-02-2008 10:37 AM

You change it in the config file.

I have one file per table, you can always join them together later if needed.

You rarely need to optimize tables.

Jase2

07-02-2008 10:48 AM

Ok, thanks for your reply Paul, much appreciated. :)

malomairy

07-02-2008 09:02 PM

just installed it and it worked fine by pressing run now, i have the following questions:

1- Cron didn't start as scheduled, i put day of week to * and day of month to * and hour to 4AM, so this should backup the DB everyday at 4AM, one day passed with no backup. is there anything else i have to do?

2- which is better backup up DB on one file, or have it Table by Table?

3- I've never done restore so far, so how and what is the fastest way to restore DB?

Thanks Paul for this great Mod.

tazzarkin

07-04-2008 03:17 PM

Thanks for posting this thread. It's always good to have more than one option.

----------------

Quote:

Originally Posted by Jase2 (Post 1435505)

Might as well just set up a cron job.

https://vborg.vbsupport.ru/showthread.php?t=169550

Regards Jason :)

tazzarkin

07-04-2008 03:20 PM

Quote:

Originally Posted by seangworld (Post 1435764)

so is this in lieu of using the backup in the acp?

if i use this, will be easier to use the file from this script to upload to lets say a new db and new installation of my site? cuz i know the one in the acp that comes with the forum sucks and i could never get it to actually work, always having to start from scratch.

--------------------------

No one ever answered seangworld, and I pretty much have the same question.

How is this better than the backup in the acp?

XFSImperial

07-06-2008 05:35 PM

I've installed this mod on a forum of mine, it has worked well so I decided to install it on another. I'm getting this error though:

Quote:

Parse error: syntax error, unexpected T_STRING in D:\Websites\xboxnation\forums\includes\mysqlbackup config.php on line 24

Running IIS on Windows 2003, any suggestions?

Paul M

07-07-2008 06:21 PM

Correct the error you have made editing the file.

War_force

07-07-2008 07:02 PM

Automatic Database Backup for vBulletin 3.7
An error occured during the Backup : Could not open Destination SQL file for writing.

what can I do?

Pavlus

07-08-2008 06:08 AM

I have a little problem here.

Sometimes when i use option - close board due to backup, board will not automaticaly open after process.

Today i just disabled it because morning backup failed. My database is very small about 23mb, when i making backup - manualy using this product - process stops at one of the tables polls f.e and its stucked....

Any ideas? From today everything was ok.

Paul M

07-08-2008 10:29 AM

That is known to happen from time to time - the only answer is dont use that option. Its not necessary to close the board.

Pavlus

07-09-2008 01:10 PM

Ok but there is also another complication, now backup stops at some table and dont go forward. From 23mb of database only 6mb have been backuped :/

I didnt changed anything, forum stands on shared gosting, do you thing that admins could provide me with new restrictions? Maybe script gets timeouted?

Angels1928

07-10-2008 08:25 AM

Can someone reupload the file that was posted in the beginning of this thread, the one that finds the file's location in means of "home/root/public_html" or something like that? I need to change my "backup location".

edit--

Nevermind, found it elsewhere on the 'net. Here it is, reuploaded on here

rockinaway

07-12-2008 12:31 PM

I get this error:

An error occured during the Backup : Could not open Destination SQL file for writing.

What is wrong?

pspmaster93

07-17-2008 01:36 AM

heres what error it gives me when i go to scheduled tasks and try and run it

Code:

Automatic Database Backup for vBulletin 3.7

An error occured during the Backup : Could not open Destination SQL file for writing.

heres what i put for config

Code:

<?php

/*

<!-- $Header: d:\cvs/3.7/Auto-backup/includes/mysqlbackupconfig.php,v 3.2 2008/01/06 15:32:44 pem Exp $ -->



Auto-Backup (Lite) for vBulletin 3.7 - Paul M - v 3.7.001

This lite version is adapted from the original 3.0 version by Trigunflame.

*/



  // Combine all tables into one file

  $backup['COMBINE'] = 1;  // 0 = No, 1 = Yes



  // Close Forum during Backup

  $backup['SHUTDOWN'] = 1;  // 0 = No, 1 = Yes

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



  // File Saving Information

  $backup['DATE'] = 'Y-M-d';  // Backup file date format (See http://uk.php.net/date)

  $backup['PREFIX']        = 'Forum-';  // Backup file prefix, applied to all files

  $backup['DUMP_PATH']        = 'warez-4u.com/backup/';  // Path to backups folder, must have a trailing slash



// -----------------------------------------------------------------------------------------------//



  // Backup Options 

  $backup['LOCK'] = 0; // Lock Tables during dump 

  $backup['REPAIR']        = 1; // Repair & Optimize Tables before dump



  // Backup Type To Use

  $backup['TYPE'] = 2; // 1 = Only Specified Tables, 2 = All except Specified Tables

  $backup['TABLES']        = array(); // Table List - e.g. array('table1', 'table2')



  // Backup Optimizations 

  $backup['INNODB'] = 0; // Set to 1 if you have Innodb Tables 



  // Execution Function 

  $backup['COMMAND'] = 'exec'; // exec, system or passthru



?>

Super Jinni

07-17-2008 03:55 AM

Installed and works perfectly..

thanks Paul

Paul M

07-17-2008 09:52 AM

Quote:

Originally Posted by pspmaster93 (Post 1577341)

heres what error it gives me when i go to scheduled tasks and try and run it

Code:

Automatic Database Backup for vBulletin 3.7

An error occured during the Backup : Could not open Destination SQL file for writing.

heres what i put for config

Either the backup path is wrong, or your webserver does not have permission to write to it. If I were guessing, I would say the former.

rockinaway

07-17-2008 04:29 PM

I have checked the destination folder and chmodded the directory, yet I get the same error.. why?

Paul M

07-17-2008 07:27 PM

I cannot possibly answer that, security/permissions are server specific, speak to your host.

Vinyljunky

07-18-2008 12:51 PM

Paul,

Have you released a Pro version?

I'd like something that only keeps x backups etc....

Thanks

VinylJunky

Paul M

07-18-2008 02:52 PM

Sorry, this is the only version.

Super Jinni

07-18-2008 03:33 PM

Hi Paul

I've installed this just yesterday and it works well.
but,
when I checked the backup folder, I found that there is two folders inside, with the names:
2008-Jul-16
2008-Jul-17

and as I see these folders contain the backups of yesterday and today, and in this way I think it will create a new folder every time it makes backup..

is this ok? or there is some thing wrong with it?
should I do anything else?

I thought the old backup will be replaced with the newest one.. and only have one folder..

any suggestions?

thanks

:)

Paul M

07-18-2008 04:04 PM

Its working exactly as expected.

Super Jinni

07-18-2008 04:12 PM

should I delete the older ones or keep them?

I mean I think the newest one is all what I need, right?

thanks

:)

Paul M

07-18-2008 11:51 PM

Thats your decision, not mine.

Super Jinni

07-19-2008 01:15 PM

What I mean is that,
is there any differences between the newest one and the ones older than it?

if I delete the older ones and only keep the newest one, it will be enough if I want to restore my forum if I needed to?

I'm sorry for my foolishness but I'm new for database backup matters

thanks

:)

Rideharder

07-19-2008 06:43 PM

Ok this is alittle nuts I know I have two hosting plans on one I have my DB and on one I have all my files .. I tryed this and this is what I got

Automatic Database Backup for vBulletin 3.7
An error occured during the Backup : Could not open Destination SQL file for writing.

what do I need to do to point it to my DB?

Paul M

07-19-2008 06:46 PM

Thats a server permission error (as mentioned numerous times in previous pages).

Rideharder

07-19-2008 06:58 PM

Thanks Paul, but what I need to know will this mod still work for my Database that is hosted on www.xxxx.com and all my files for my board it loaded on www.xxxx.net with no Database?

Paul M

07-19-2008 07:09 PM

I dont understand your question.

This backs up whatever database your forum is using.

All times are GMT. The time now is 08:00 PM.

Page 5 of 9

« First

Last »

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

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01699 seconds Memory Usage 1,826KB 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 (3)bbcode_code_printable (6)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (40)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: