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)

Walter Ronny 04-18-2009 12:18 PM

i works! ok so now, im looking for to get another hosting and move all info of my forum to the new hosting ill looking for to get.. what exactly i have to do ? do ill lose any info ?

Kolbi 04-20-2009 05:13 PM

Do I really have to set the folders to 777? Isn“t it unsecure?

Paul M 04-20-2009 08:52 PM

Apache needs write access to create the files, how you do that is upto you - 777 is the easiest way.

madotds 04-21-2009 01:33 PM

Cheers paul for this mod :)

Just for information:

For those of you who would like your sql dumps to be a little more secure, It is posible to have them save outside of your "public folder"
all you need to do is find out the full path to your sever for example mine looks something like this.
Code:

$backup['DUMP_PATH']        = '/home/fhlinux123/x/yoururl.com/user/mysqlbackups/';  //
Then just make sure the folder you defined in red is chmod 777. (you can do this through your FTP client and right clicking selecting properties if you are on a lynux sever. I dont know about any other severs.

I am far from an expert but hope this helps someone.

Regards

Madotds

mokujin 04-26-2009 09:16 PM

When I run this cron, after a few seconds there show these lines:
Code:

Automatic Database Backup for vBulletin 3.8

Processing access : Total Rows = 0
Processing adminhelp : Total Rows = 1748
Processing administrator : Total Rows = 4
Processing adminlog : Total Rows = 5937
Processing adminmessage : Total Rows = 3
Processing adminutil : Total Rows = 3
Processing album : Total Rows = 130
Processing albumpicture : Total Rows = 933
Processing albumupdate : Total Rows = 0
Processing announcement : Total Rows = 12
Processing announcementread : Total Rows = 1061
Processing attachment : Total Rows = 753
Processing attachmentpermission : Total Rows = 0
Processing attachmenttype : Total Rows = 10
Processing attachmentviews : Total Rows = 0
Processing automediaembed : Total Rows = 0
Processing avatar : Total Rows = 0
Processing bbcode : Total Rows = 5
Processing bookmarksite : Total Rows = 4
Processing calendar : Total Rows = 1
Processing calendarcustomfield : Total Rows = 0
Processing calendarmoderator : Total Rows = 0
Processing calendarpermission : Total Rows = 0
Processing cpsession : Total Rows = 1
Processing credits_bank : Total Rows = 2
Processing credits_lottery : Total Rows = 0
Processing credits_transactions : Total Rows = 52
Processing cron : Total Rows = 19
Processing cronlog : Total Rows = 588
Processing customavatar : Total Rows = 825
Processing customprofilepic : Total Rows = 362
Processing datastore : Total Rows = 38
Processing deletionlog : Total Rows = 1362
Processing discussion : Total Rows = 5
Processing discussionread : Total Rows = 0
Processing editlog : Total Rows = 11242
Processing event : Total Rows = 1
Processing externalcache : Total Rows = 3
Processing faq : Total Rows = 42
Processing forum : Total Rows = 206
Processing forumpermission : Total Rows = 40
Processing forumprefixset : Total Rows = 17
Processing forumread : Total Rows = 0
Processing gb_cache : Total Rows = 1099
Processing gb_media : Total Rows = 1099
Processing groupmessage : Total Rows = 20
Processing groupmessage_hash : Total Rows = 20
Processing groupread : Total Rows = 0
Processing holiday : Total Rows = 0
Processing humanverify : Total Rows = 4
Processing hvanswer : Total Rows = 2
Processing hvquestion : Total Rows = 1
Processing icon : Total Rows = 16
Processing imagecategory : Total Rows = 4
Processing imagecategorypermission : Total Rows = 0
Processing infraction : Total Rows = 825
Processing infractionban : Total Rows = 2
Processing infractiongroup : Total Rows = 0
Processing infractionlevel : Total Rows = 8
Processing language : Total Rows = 2
Processing mailqueue : Total Rows = 0
Processing moderation : Total Rows = 95
Processing moderator : Total Rows = 67
Processing moderatorlog : Total Rows = 9199
Processing nhac_song : Total Rows = 19
Processing notice : Total Rows = 1
Processing noticecriteria : Total Rows = 1
Processing noticedismissed : Total Rows = 0
Processing passwordhistory : Total Rows = 22395
Processing paymentapi : Total Rows = 7
Processing paymentinfo : Total Rows = 38
Processing paymenttransaction : Total Rows = 16
Processing phrase : Total Rows = 13155
Processing phrasetype : Total Rows = 68
Processing picture : Total Rows = 933
Processing picturecomment : Total Rows = 139
Processing picturecomment_hash : Total Rows = 193
Processing plugin : Total Rows = 144
Processing pm : Total Rows = 32552
Processing pmreceipt : Total Rows = 9
Processing pmtext : Total Rows = 26650
Processing pmthrottle : Total Rows = 0
Processing podcast : Total Rows = 0
Processing podcastitem : Total Rows = 0
Processing poll : Total Rows = 61
Processing pollvote : Total Rows = 3716
Processing post : Total Rows = 146373
Processing post_thanks : Total Rows = 306367
Processing postedithistory : Total Rows = 0
Processing posthash : Total Rows = 0
Processing postindex : Total Rows = 1204613

So I think I havent backuped all tables?
Need your help, Paul!

Kolbi 04-27-2009 02:19 PM

I hade the same problem. But then the cron job automatically makes an backup all vb_ prefixes are backed up.

mokujin 04-28-2009 09:01 PM

Quote:

Originally Posted by Kolbi (Post 1799915)
I hade the same problem. But then the cron job automatically makes an backup all vb_ prefixes are backed up.

I still cant backup.:confused:

Kolbi 04-29-2009 11:30 AM

How big is your database? (sorry for my english :) i?m german...)

mokujin 04-29-2009 08:52 PM

Quote:

Originally Posted by Kolbi (Post 1801105)
How big is your database? (sorry for my english :) i?m german...)

about 600mb, i'm czech :)

tijmen_4real 05-18-2009 08:20 AM

How can i change the time/frequency the backups are made?


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.01388 seconds
  • Memory Usage 1,746KB
  • 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
  • (2)bbcode_code_printable
  • (2)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