vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.0 Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=33)
-   -   [vbcron] Automatic database backup [v1.3] (https://vborg.vbsupport.ru/showthread.php?t=62149)

Symbian.info 03-17-2004 01:11 PM

Quote:

Originally Posted by Brad.loo
This is a vbcron script that will backup your database to a .sql file on your server.

You need MySQLdump for this to work, also a folder chmoded to 775 (or 777).

You will need to change the information here for it to work correctly on your server:

PHP Code:

// Set these vars up to to suit your server
define('DB_HOST''localhost'); // database host
define('DB_USER''user'); // database username
define('DB_PASSWORD''db_pass'); // database password
define('DB_NAME''vbulletin'); // vbulletins database name
define('DUMP_PATH''/path/to/dump/folder'); // 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 changes 

Remember to upload this script to /vbroot/includes/cron!!

Does not work for me:-( Get:

MySQL backup

All Done

vBulletin v3.0.0 Release Candidate 3, Copyright ?2000-2004, Jelsoft Enterprises Ltd.


Fatal error: Call to undefined function: query() in /home/mywebiste/www/forum/includes/functions.php on line 501


But no backup is made:-(

alkahf 03-17-2004 04:14 PM

That is the best hack in 2004.

Thank you

alkahf 03-18-2004 11:22 AM

Hello
Yesterday I installed this hack like that :

https://vborg.vbsupport.ru/

Today I login to Ftp and I see that :

https://vborg.vbsupport.ru/

Tell me please what the problem?

Thank you

heynurse 03-19-2004 06:55 AM

Quote:

Originally Posted by Symbian.info
Does not work for me:-( Get:

MySQL backup

All Done

vBulletin v3.0.0 Release Candidate 3, Copyright ?2000-2004, Jelsoft Enterprises Ltd.


Fatal error: Call to undefined function: query() in /home/mywebiste/www/forum/includes/functions.php on line 501


But no backup is made:-(

I had this problem too at first, I had a space in my folder name, I removed the space and it worked fine. Not sure that will help you or not, but thought I'd try.

Natch 03-19-2004 10:39 PM

Quote:

Originally Posted by alkahf
Hello
Yesterday I installed this hack like that :

http://www.vbulletinclub.com/images/scheduled.png

Today I login to Ftp and I see that :

http://www.vbulletinclub.com/images/backup.png

Tell me please what the problem?

Thank you

No problem - except it seems you have the hack setup to run every minute ...

alkahf 04-03-2004 04:07 AM

Quote:

Originally Posted by Natch
No problem - except it seems you have the hack setup to run every minute ...

Thank you Natch
But did you notice ( in my images ) that hack does not deleted last backup files?
untill now I deleted laste backup files manualy every day.
Tell me please what's the problem ?

Best regards :)
alkahf

Onkel_Tom 04-03-2004 09:36 PM

This Hack only makes a backup of the database !
There ist no code for deleting old backups.

If you want to do that you have to add a line like
exec('rm ' .DUMP_PATH. '/yourolddatabasename.tar.gz');

in your cron_dbbackup.php file before backing up the actual db

Natch 04-05-2004 03:21 AM

Or you can cause the hack to overwrite with the latest backup (weekly) by using the day of the week modification, instaed of the unix timestamp filename...

Onkel_Tom 04-06-2004 06:13 PM

arggh !
I configured in the options to log the activity of this backup script, but I no activities are logged !
Script is running fine every day and backing up the db.

anybody an answer or solution ?

paulomt1 04-06-2004 08:39 PM

Don'r work for me. no backups recorded.

:
Database Backup

Done

vBulletin v3.0.0, Copyright ©2000-2004, Jelsoft Enterprises Ltd.

My defs:
// Set these vars up to to suit your server
define('DB_HOST', 'localhost'); // database host
define('DB_USER', 'dbusername'); // database username
define('DB_PASSWORD', 'dbpass'); // database password
define('DB_NAME', 'dbname'); // vbulletins database name
define('DUMP_PATH', '/public_html/foruns/dbBackup'); // 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 changes

What I made wrong?


All times are GMT. The time now is 09:32 AM.

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.01257 seconds
  • Memory Usage 1,749KB
  • 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_php_printable
  • (4)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)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