vb.org Archive

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

slowphantom 05-23-2009 04:16 PM

thx for the mod
and
i got some problem after i installed the 3.8 and use this

it give database error

Code:

Database error in vBulletin 3.8.2:

Invalid SQL:
SHOW CREATE TABLE `template`;

MySQL Error  : MySQL server has gone away
Error Number  : 2006

it happen so much
befor i was useing the 3.7 on 3.7 forum
but i upgread to 3.8.2 and install that mod and i cant take any back up any more :(
any idea ?
thx

sargatanas 05-24-2009 06:25 AM

how this thing work?, i just installed it but i cant see any menu in my vb admincp [sorry for noob question]

doctorsyrup 05-24-2009 09:04 AM

Quote:

Originally Posted by sargatanas (Post 1816135)
how this thing work?, i just installed it but i cant see any menu in my vb admincp [sorry for noob question]

There is no menu for it. Go to the Scheduled Task Manager > Automatic Database Backup and you can run it manually. It is also set to run once daily by default.

Jheyman 05-25-2009 06:50 PM

Quick question I am getting this error when I hit run now on the backup job, I am sure I missed somehting but I cant seem to figure it out any help is appericated

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

Outbackmark 05-26-2009 02:05 AM

Installed and working fine, I created a folder called backup in the same folder as my forum, this differs from one site to the next, it needs to be in the same place as you see the folders for admincp, archive, attachements and so on (The place where you upload all your VB files).

The permissions are set to 755.

Make sure the folder is named the same in the mysqlconfig.php file so mine was called backup and my config looked like this
Quote:

// 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'] = './backup/'; // Path to backups folder, must have a trailing slash, folder must be writable.
Once set up, upload the config file into the includes folder and it will work, remember the ./ before the file name and the / after, that should be all you need on a linux server, so long as the folder is in the same place as your VB forum files.

All the above error means is the mod can not find or write into the folder because is is not named or placed correctly.

PayJ 05-26-2009 04:37 AM

What is the advantage of using this? Isn't this already in 3.8?

Yonatan 05-26-2009 04:56 AM

Quote:

Originally Posted by Jheyman (Post 1817061)
Quick question I am getting this error when I hit run now on the backup job, I am sure I missed somehting but I cant seem to figure it out any help is appericated

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

Safe Mode is turn on in your server and block this function, so you you need to turn off the Safe Mode if it's your own server, or contact to your hosting support.

Quote:

Originally Posted by PayJ (Post 1817282)
What is the advantage of using this? Isn't this already in 3.8?

It's is a automatically backup based on Cron Jobs.
It's NOT a manual backup.

Paul M 05-26-2009 09:52 AM

Quote:

Originally Posted by PayJ (Post 1817282)
What is the advantage of using this? Isn't this already in 3.8?

No, there is no automatic backup facility in vbulletin.

Tboy_forum 05-29-2009 05:08 PM

Guys, I also battled my arse off trying to get this thing to work!

It does - and eventually found it was my folder path for the backup - IT MUST BE CORRECT or it aint gonna work:D

Thanks

bleros 06-06-2009 11:01 AM

$backup['DUMP_PATH'] = './backups/'; // Path to backups folder, must have a trailing slash, folder must be writable.

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


so must create folder in ftp with name backups or its established realy i need help i must have this becouse i dont have time to backup everyday with maus :)

Paul M 06-06-2009 02:57 PM

Yes, you must create the folder.

bleros 06-07-2009 12:32 AM

Quote:

Originally Posted by Paul M (Post 1824511)
Yes, you must create the folder.


im get this error

Warning: is_file() [function.is-file]: open_basedir restriction in effect. File(../backups/2009-Jun-07) is not within the allowed path(s): ([path]/:/home/www/web1/phptmp/:/home/www/web1/files/:/home/www/web1/atd/) in [path]/includes/mysqlbackup.php on line 211

Warning: is_dir() [function.is-dir]: open_basedir restriction in effect. File(../backups/2009-Jun-07) is not within the allowed path(s): ([path]/:/home/www/web1/phptmp/:/home/www/web1/files/:/home/www/web1/atd/) in [path]/includes/mysqlbackup.php on line 246

Warning: is_dir() [function.is-dir]: open_basedir restriction in effect. File(../backups/2009-Jun-07) is not within the allowed path(s): ([path]/:/home/www/web1/phptmp/:/home/www/web1/files/:/home/www/web1/atd/) in [path]/includes/mysqlbackup.php on line 257

Warning: file_exists() [function.file-exists]: open_basedir restriction in effect. File(../backups/2009-Jun-07/Forum-2009-Jun-07-aaggregate_temp_1227319800.sql) is not within the allowed path(s): ([path]/:/home/www/web1/phptmp/:/home/www/web1/files/:/home/www/web1/atd/) in [path]/includes/mysqlbackup.php on line 153

Warning: file_exists() [function.file-exists]: open_basedir restriction in effect. File(../backups/2009-Jun-07/Forum-2009-Jun-07-aaggregate_temp_1227319800.sql) is not within the allowed path(s): ([path]/:/home/www/web1/phptmp/:/home/www/web1/files/:/home/www/web1/atd/) in [path]/includes/mysqlbackup.php on line 163

or this

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

are sometimes created a folder with the date. has nothing but the error :mad:

Paul M 06-07-2009 11:01 AM

open_basedir is a php security feature on your server, you need to talk to your host.

bleros 06-08-2009 10:46 AM

Quote:

Originally Posted by Paul M (Post 1825006)
open_basedir is a php security feature on your server, you need to talk to your host.

ah yes SAFE MOD in server is ON .. i.e not work with SAFE MODE ON

centurius 06-09-2009 06:02 PM

Installed and works 90% perfectly. Only issue I have is that it does not re-enable my forum once it's done- and that was easily worked around using the config file.

smartkidbk5 06-25-2009 03:10 AM

i keep getting this error:

PHP Code:

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

what is wrong?

Outbackmark 06-25-2009 06:06 AM

You have not created the folder for it to write to or set the permissions correctly.

Yonatan 06-25-2009 06:31 AM

Quote:

Originally Posted by smartkidbk5 (Post 1836849)
i keep getting this error:

PHP Code:

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

what is wrong?


Quote:

Originally Posted by Outbackmark (Post 1836908)
You have not created the folder for it to write to or set the permissions correctly.

This is unattached.

That error showing because Safe Mod turn on on his server.
turn off it and the problem will be solved ;)

Outbackmark 06-25-2009 07:17 AM

I have this installed on a number of sites, all on the same server, not in safe mode. On one site I forgot to set the folder up properly and that is exactly the same error I got. If something on the server was running in safe mode he would be having all sorts of other issues.
If you look back in this thread the error has been encountered a few times, each time is because the folder that the script writes to is not properly set up. The folder must be in the same folder that has your main vb files in it and be named the same as it is called in the config file and must have the permissions correct.
If the above is not done you will get exactly that error.

If PHP is in safe mode you will get this error -
Code:

Warning: is_file() [function.is-file]: open_basedir restriction in effect. File(../backups/2009-Jun-07) is not within the allowed path(s): ([path]/:/home/www/web1/phptmp/:/home/www/web1/files/:/home/www/web1/atd/) in [path]/includes/mysqlbackup.php on line 211

Warning: is_dir() [function.is-dir]: open_basedir restriction in effect. File(../backups/2009-Jun-07) is not within the allowed path(s): ([path]/:/home/www/web1/phptmp/:/home/www/web1/files/:/home/www/web1/atd/) in [path]/includes/mysqlbackup.php on line 246

Warning: is_dir() [function.is-dir]: open_basedir restriction in effect. File(../backups/2009-Jun-07) is not within the allowed path(s): ([path]/:/home/www/web1/phptmp/:/home/www/web1/files/:/home/www/web1/atd/) in [path]/includes/mysqlbackup.php on line 257

Warning: file_exists() [function.file-exists]: open_basedir restriction in effect. File(../backups/2009-Jun-07/Forum-2009-Jun-07-aaggregate_temp_1227319800.sql) is not within the allowed path(s): ([path]/:/home/www/web1/phptmp/:/home/www/web1/files/:/home/www/web1/atd/) in [path]/includes/mysqlbackup.php on line 153

Warning: file_exists() [function.file-exists]: open_basedir restriction in effect. File(../backups/2009-Jun-07/Forum-2009-Jun-07-aaggregate_temp_1227319800.sql) is not within the allowed path(s): ([path]/:/home/www/web1/phptmp/:/home/www/web1/files/:/home/www/web1/atd/) in [path]/includes/mysqlbackup.php on line 163


ITDarasgah 07-03-2009 09:05 PM

after run show me this message tell me this is okay or not...no other message show.
HTML Code:

Automatic Database Backup for vBulletin 3.8
Processing access : Total Rows = 10
Processing adminhelp : Total Rows = 1690
Processing administrator : Total Rows = 4
Processing adminlog : Total Rows = 4405
Processing adminmessage : Total Rows = 0
Processing adminutil : Total Rows = 1
Processing album : Total Rows = 1
Processing albumpicture : Total Rows = 2
Processing albumupdate : Total Rows = 1
Processing announcement : Total Rows = 1
Processing announcementread : Total Rows = 17
Processing attachment : Total Rows = 703


Paul M 07-03-2009 09:14 PM

You should only see that if you run it manually.

Bob_R 07-09-2009 05:06 PM

Will this mod backup everything? Database, sigs, avatars, posts, etc...

Thanks.

Looking for a good backup for vB and trying to make a proper choice for my needs.

Paul M 07-09-2009 08:19 PM

It backs up the vb database, so obviously posts etc.

It wont backup avatars or attachments etc unless you store them in the database.

Sn1peR 07-15-2009 02:39 AM

hi, thx 4 this mod

can i merg backup in single SQL file ?

coz it given to me as a table just like this!
:confused:

Attachment 101969

Paul M 07-15-2009 08:53 AM

Just change the option in the config file.

dfdems 07-25-2009 07:19 AM

I have this installed and it works great so far. I do have a question regarding it though.

Code:

If I install this outside of the public html folder and it is set at 7-5-5 it should be fairly secure?

Paul M 07-25-2009 04:13 PM

As long as apache can write to it yes. Outside the public html folder is the recommended way.

Bob_R 07-26-2009 03:46 PM

When will this run? I checked the mysqlbackupconfig.php file and saw no indication. I guess I missed it? :confused:

Also, I must create a backup folder and the backups folder must be 777? Yes or No?

Thanks!! :)

Paul M 07-26-2009 04:13 PM

It runs whenever the cron (scheduled task) is set to run - 5am I think is the default.

Bob_R 07-26-2009 11:46 PM

My PHP settings are safe mode on (I believe by default)

Is this a problem?

Thanks.

Bob_R 07-27-2009 10:49 AM

My backup directory is empty this AM. So, obviously nothing was backed up.

What could be wrong?

Thanks.

Paul M 07-27-2009 11:02 AM

First of all, turn safe mode off.

Then run it manually to see what happens.

Bob_R 07-27-2009 11:17 AM

Isn't safe mode off a security issue?

Secondly, how can I put safe mode off for my forums but leave it on for my other sites. Which I believe need safe mode on if I'm not mistaken.

Thanks.

Paul M 07-27-2009 04:51 PM

Its not really a security risk, Safe Mode is just a nuisance that stops things working, it doesnt even exist in PHP 6.

I cannot help you with your own server set-up, contact your host.

Bob_R 07-27-2009 06:57 PM

I got this when I tried to run manually:

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

Is this the result of safe mode?

Thanks!

Paul M 07-28-2009 09:28 AM

Quite possibly - or your backup path could be wrong, or the folder permissions wrong, or some other reason. All the message means is apache does not have permission to write the file, you need to investigate why.

Bob_R 07-28-2009 11:25 AM

Just tried to run manually.

I have Safe Mode Off
The backup folder is named backups and is set to 777
And, I'm quite sure the path is correct

and I still get the error. :confused:

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

Here's my path:

$backup['DUMP_PATH'] = 'home/xxxxx/public_html/dumontnjforum.com/forums/backups/'; // Path to backups folder, must have a trailing slash, folder must be writable.

Markos 07-28-2009 12:21 PM

first of all thanks Paul i just upgraded to the new one worked first time :)

why not put your "backups" folder in home/xxxxx/ and change the path to that and see if that works and change the path to

$backup['DUMP_PATH'] = 'home/xxxxx/backups/';

Quote:

Originally Posted by Bob_R (Post 1857076)
Just tried to run manually.

I have Safe Mode Off
The backup folder is named backups and is set to 777
And, I'm quite sure the path is correct

and I still get the error. :confused:

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

Here's my path:

$backup['DUMP_PATH'] = 'home/xxxxx/public_html/dumontnjforum.com/forums/backups/'; // Path to backups folder, must have a trailing slash, folder must be writable.


Bob_R 07-28-2009 03:54 PM

Quote:

Originally Posted by Markos (Post 1857104)
why not put your "backups" folder in home/xxxxx/ and change the path to that and see if that works and change the path to

$backup['DUMP_PATH'] = 'home/xxxxx/backups/';

Same story didn't work. :(:mad:

Bob_R 07-28-2009 04:08 PM

I just noticed that I have 2 php.ini files.

Could this be causing the problem?

One is in public_html and the other is in forum root.


All times are GMT. The time now is 10:20 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01875 seconds
  • Memory Usage 1,838KB
  • 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
  • (1)bbcode_html_printable
  • (2)bbcode_php_printable
  • (11)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