Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 General Discussions
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Display Modes
  #1  
Old 06-18-2005, 09:21 AM
Johannes de Le?n Johannes de Le?n is offline
 
Join Date: Dec 2004
Location: Gallaecia, Las Espa?as
Posts: 36
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default help with small code, please?

I'm trying to backup my database using this script, but it isn't working as expected, could you please have a look and tell me how can I fix it to work with vB 3.5.0?

PHP Code:
<?php

/* ####################################
            Automated backup
            by: Brad.loo
            Version: 1.3.1
###################################### */


error_reporting(E_ALL & ~E_NOTICE);

// ######################## Begin edits ######################
define('DB_HOST''localhost'); // database host

define('DB_USER''user'); // database username

define('DB_PASSWORD''password'); // database password

define('DB_NAME''database'); // vbulletins database name

define('DUMP_PATH''path/to/backup'); // path to where db backup will be stored

define('DUMP_MAKE_TAR'1); // set this to 1 for the backup to be compressed in a .tar.gz file
// ####################### End Edits ##########################

// for some reason beyound me query was un-defined for some users, so this is here as an attempt to fix it...
require_once('./global.php');

if (
$DB_site == NULL)
{
    exit;
}

// Get date for file name and log
$file_date date('m-d-y');
$file_name filename;

// Get .sql file
exec('mysqldump --add-drop-table -h' .DB_HOST' -u' .DB_USER' -p' .DB_PASSWORD' ' .DB_NAME' 2>' .DUMP_PATH'/' .$file_date'-error.txt >' .DUMP_PATH'/' .$file_name'.sql');

$log_db 'Saved backup of databse to ' DUMP_PATH ' at ' $file_date ' (file name ' $file_name '.sql';

// Do we make a tar?
if (DUMP_MAKE_TAR == '1')
{

    
// now archive and compress the backup, also delete .sql file
    
exec('gtar -cSz --remove-files -C' .DUMP_PATH' -f' .DUMP_PATH'/' .$file_name'.tar.gz ' .$file_name'.sql ' .$file_date'-error.txt');

    
$log_db 'Saved backup of databse to ' DUMP_PATH ' at ' $file_date ' (file name ' $file_name '.tar.gz';

}

// logs
log_cron_action($log_db$nextitem);
echo(
'Database backup script was invoked without error, to check that it was done correctly see if the file was written to the folder you specified in the configuration variables.    It may take some time before your server finishes backing up depending on the size of your database');

?>
PS: where it says: gtar -cSz --remove-files [...]
It must be gtar instead of tar, as I'm using FreeBSD.

Thanks in advance.
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 07:54 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.03715 seconds
  • Memory Usage 2,222KB
  • Queries Executed 11 (?)
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_php
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (1)post_thanks_box
  • (1)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit_info
  • (1)postbit
  • (1)postbit_onlinestatus
  • (1)postbit_wrapper
  • (1)showthread_list
  • (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_threadedmode.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_threaded
  • showthread_threaded_construct_link
  • 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
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete