vb.org Archive
Page 12 of 45 « First 21011 12 131422 Last »
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.0 Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=33)
-   -   Vbulletin Database Backup Pro (Cron Support) (https://vborg.vbsupport.ru/showthread.php?t=78486)

neocorteqz 04-04-2005 06:14 AM
Any particular reason it's showing up in the logs 4 times?

Code:
10296          DB Backup          03:10, 4th Apr 2005          MySQL Backup was completed successfully with no errors.
10295        DB Backup        03:07, 4th Apr 2005        MySQL Backup was completed successfully with no errors.
10294        DB Backup        03:06, 4th Apr 2005        MySQL Backup was completed successfully with no errors.
10293        DB Backup        03:05, 4th Apr 2005        MySQL Backup was completed successfully with no errors.
Also I have it set to run at 2am sunday, and it's running at 3am Monday morning. :confused:

Actually I think this was my fault, It was running more than once, I had set only the 2AM, and not the Minutes.

So it was * 2 * * Sun for the cron instead of 00 2 * * Sun

EDIT:

It's showing the file ownership as not being me. and I can't do a 'chown' on it, because of course I'm not root, but I do own the folder it's in. How do I make the script use me as the file owner?

I'm having a small problem extracting it. I'm using tgz, so I'm extracting like this
Code:
tar xvz MM_DD_YY.tar.gz
and it just sits there doing nothing.

That is the right command yes?

almqdad 04-04-2005 08:37 AM
does this thing work with 3.06

Greebo 04-04-2005 01:10 PM
Quote:
Originally Posted by almqdad
does this thing work with 3.06
Should, I've got it on 3.0.7 and it works fine. :)

cybermomcafe 04-04-2005 05:30 PM
//Fixed Problem// the vb3_threadviews table was showing as in use and had crashed... just ran the repair/optomize twice and it took care of it. :)

Working great on two of my forums, not sure what the problem is on the third though...

I'm getting this error when I try to run the script from the Scheduled Task Manager:

at the very bottom: 'vb3_threadviews.MYI' where's it getting that from?

Quote:
Database error in vBulletin 3.0.3:

Invalid SQL: LOCK TABLES `vb3_access` READ, `vb3_adminhelp` READ, `vb3_administrator` READ, `vb3_adminlog` READ, `vb3_adminutil` READ, `vb3_announcement` READ, `vb3_attachment` READ, `vb3_attachmenttype` READ, `vb3_attachmentviews` READ, `vb3_avatar` READ, `vb3_bans` READ, `vb3_bbcode` READ, `vb3_calendar` READ, `vb3_calendarcustomfield` READ, `vb3_calendarmoderator` READ, `vb3_calendarpermission` READ, `vb3_connections` READ, `vb3_cpsession` READ, `vb3_cron` READ, `vb3_cronlog` READ, `vb3_customavatar` READ, `vb3_customprofilepic` READ, `vb3_datastore` READ, `vb3_deletionlog` READ, `vb3_editlog` READ, `vb3_event` READ, `vb3_faq` READ, `vb3_forum` READ, `vb3_forumpermission` READ, `vb3_gamechallenges` READ, `vb3_gamenews` READ, `vb3_games` READ, `vb3_gamesessions` READ, `vb3_holiday` READ, `vb3_icon` READ, `vb3_ignors` READ, `vb3_imagecategory` READ, `vb3_imagecategorypermission` READ, `vb3_language` READ, `vb3_mailqueue` READ, `vb3_messages` READ, `vb3_moderation` READ, `vb3_moderator` READ, `vb3_moderatorlog` READ, `vb3_passwordhistory` READ, `vb3_phrase` READ, `vb3_phrasetype` READ, `vb3_pm` READ, `vb3_pmreceipt` READ, `vb3_pmtext` READ, `vb3_poll` READ, `vb3_pollvote` READ, `vb3_post` READ, `vb3_post_parsed` READ, `vb3_posthash` READ, `vb3_postindex` READ, `vb3_profilefield` READ, `vb3_ranks` READ, `vb3_regimage` READ, `vb3_reminder` READ, `vb3_reputation` READ, `vb3_reputationlevel` READ, `vb3_rooms` READ, `vb3_rss_settings` READ, `vb3_rss_user` READ, `vb3_search` READ, `vb3_session` READ, `vb3_setting` READ, `vb3_settinggroup` READ, `vb3_smilie` READ, `vb3_stats` READ, `vb3_strikes` READ, `vb3_style` READ, `vb3_subscribeevent` READ, `vb3_subscribeforum` READ, `vb3_subscribethread` READ, `vb3_subscription` READ, `vb3_subscriptionlog` READ, `vb3_template` READ, `vb3_thread` READ, `vb3_threadrate` READ, `vb3_threadviews` READ, `vb3_upgradelog` READ, `vb3_user` READ, `vb3_useractivation` READ, `vb3_userban` READ, `vb3_userfield` READ, `vb3_usergroup` READ, `vb3_usergroupleader` READ, `vb3_usergrouprequest` READ, `vb3_usernote` READ, `vb3_userpromotion` READ, `vb3_usertextfield` READ, `vb3_usertitle` READ, `vb3_utt_store_action` READ, `vb3_utt_store_asvs` READ, `vb3_utt_store_bank` READ, `vb3_utt_store_history` READ, `vb3_vbookie_bets_placed` READ, `vb3_vbookie_groups` READ, `vb3_vbookie_item_options` READ, `vb3_vbookie_items` READ, `vb3_vbookie_news` READ, `vb3_word` READ;
mysql error: Can't open file: 'vb3_threadviews.MYI'. (errno: 145)

mysql error number: 1016

Date: Monday 04th of April 2005 02:26:54 PM
Script: http://www.***********.com/vb/admin/...cron&cronid=14
Referer: http://www.**********.com/vb/admin/
Username: *******
IP Address: ************

RichieBoy67 04-04-2005 08:29 PM
If this has been covered, sorry... I just don't have time right now to read through all the posts... It is working for me but I am getting the following error...

Failover was initiated for MySQLDump Binary, but dump completed successfully.

Any way I can fix this??

Trigunflame 04-04-2005 10:40 PM
Quote:
Originally Posted by neocorteqz
Any particular reason it's showing up in the logs 4 times?

Code:
10296          DB Backup          03:10, 4th Apr 2005          MySQL Backup was completed successfully with no errors.
10295        DB Backup        03:07, 4th Apr 2005        MySQL Backup was completed successfully with no errors.
10294        DB Backup        03:06, 4th Apr 2005        MySQL Backup was completed successfully with no errors.
10293        DB Backup        03:05, 4th Apr 2005        MySQL Backup was completed successfully with no errors.
Also I have it set to run at 2am sunday, and it's running at 3am Monday morning. :confused:

Actually I think this was my fault, It was running more than once, I had set only the 2AM, and not the Minutes.

So it was * 2 * * Sun for the cron instead of 00 2 * * Sun

EDIT:

It's showing the file ownership as not being me. and I can't do a 'chown' on it, because of course I'm not root, but I do own the folder it's in. How do I make the script use me as the file owner?

I'm having a small problem extracting it. I'm using tgz, so I'm extracting like this
Code:
tar xvz MM_DD_YY.tar.gz
and it just sits there doing nothing.

That is the right command yes?
Try using

tar xzvf MM_DD_YY.tar.gz it worked fine me in test, if not just change it to use straight .gz encoding.

then just use

gunzip MM_DD_YY.gz



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

As for it showing up in your log at multiple times, I can not yet explain that... it has not occured for me on any of the forums I have tried this on, make sure you dont have multiple cron entries for the backup either.

As for the CHMOD problem, I will add into the script to CHMOD the file after it is saved, that should fix the problem hopefully...

Trigunflame 04-04-2005 10:45 PM
Quote:
Originally Posted by cybermomcafe
//Fixed Problem// the vb3_threadviews table was showing as in use and had crashed... just ran the repair/optomize twice and it took care of it. :)

Working great on two of my forums, not sure what the problem is on the third though...

I'm getting this error when I try to run the script from the Scheduled Task Manager:

at the very bottom: 'vb3_threadviews.MYI' where's it getting that from?
Yes that would be a problem with that table.

Note: I do have the option in the configuration to enable repair/optimize before the dump is initiated.

Trigunflame 04-04-2005 10:46 PM
Quote:
Originally Posted by RichieBoy67
If this has been covered, sorry... I just don't have time right now to read through all the posts... It is working for me but I am getting the following error...


Failover was initiated for MySQLDump Binary, but dump completed successfully.


Any way I can fix this??
It just means that you dont have access to the mysqldump binary via shell commands, probably because of safemode.

In this case, it is failing over into a manual PHP dump mode. As long as it is saving your dumps correctly, all is ok. But you might want to get safemode turned off if possible.

rinkrat 04-05-2005 02:26 AM
Installed in a heartbeat and spit out a perfectly compressed backup very quickly. Great stuff! Thanks for the great hack :)

Trigunflame 04-05-2005 03:40 AM
Quote:
Originally Posted by rinkrat
Installed in a heartbeat and spit out a perfectly compressed backup very quickly. Great stuff! Thanks for the great hack :)
You're very welcome :), when I finish I hope for this to be integrated into Vbulletin permanently.


All times are GMT. The time now is 04:37 PM.
Page 12 of 45 « First 21011 12 131422 Last »
Show 40 post(s) from this thread on one page

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.01414 seconds
  • Memory Usage 1,758KB
  • 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
  • (4)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
  • (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