vb.org Archive
Page 10 of 12 « First 89 10 1112
Show 40 post(s) from this thread on one page

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)

snowlion 09-23-2010 11:44 AM
Hi Paul,
How do I make folder for combine SQL file? Cause I want to seperate everyday's backup file.
It worked with 3.8.002 but it didn't work with 3.8.004

Paul M 09-23-2010 04:57 PM
You cannot, that was always a bug, and got fixed as part of 3.8.004.

snowlion 09-24-2010 05:09 AM
Quote:
Originally Posted by Paul M (Post 2102341)
You cannot, that was always a bug, and got fixed as part of 3.8.004.
Ok, Thanks :D

slowphantom 09-24-2010 08:01 AM
hey Paul

Thanks for keeping it up realy great work
and i have question pls

Quote:
You cannot, that was always a bug, and got fixed as part of 3.8.004
that mean the new update will replace the backup every day ?

what about if some one hack it or somthing go s wrong and it will be be4 back up
so the backup will take the bad one and replace it with the one from the day be4 ?

Paul M 09-24-2010 04:50 PM
Quote:
Originally Posted by slowphantom (Post 2102616)
that mean the new update will replace the backup every day ?
No.

slowphantom 09-24-2010 10:09 PM
ok Paul
Thank you

u still my best developer :)
keep it up

Phaedrus 09-26-2010 06:41 AM
Wow... GZip. Thanks dude! That is quite an improvement.

SorentoUltimate 09-26-2010 08:11 PM
Hi all,

i install it but i have a problem, the backup never finish...

The procedure stop when backup a file with 60.000 records.

Any idea how i can solve that problem?

Waiting your help...

Simon Lloyd 09-27-2010 04:53 AM
That must be the limitations of your server configuration i.e PHP memory limit, MySql memory.....etc

I have forums with160,000+ threads and the backup has always completed for me.

Paul M 09-27-2010 11:25 AM
Most likely your host is imposing a timeout on php, which the mod is unable to override.

Simon Lloyd 09-27-2010 03:21 PM
Hi Paul, i have to say with the old version prior to the one with no gzip i had no problem backing up once a week (i had to check my backups after responding to the post above) but with the new version using gzip i find that doing a daily backup only backed up a small portion of my database, with the final file in the folder NOT being compressed.

Is there anyway i can have the previous xml to go back to please?

Paul M 09-27-2010 06:20 PM
There is no difference between them as far as actual backups are concerned.

Simon Lloyd 09-27-2010 06:46 PM
Hmm. it's odd then, i set the backup to be daily and every day it only backed up the first say 25 tables, i've deleted them now but how ever many it was it was exactly the same in each days folder and always the last file (which just happened to be attachments) wasn't compressed, i've set cron to just onday now and see how we go :)

Paul M 09-27-2010 10:07 PM
I just checked, and the only changes are for Gzip. What happens if you run it manually ?

Simon Lloyd 09-28-2010 06:43 AM
Just ran it manually, when using gzip i get this after it cas compressed 31 tables:
Fatal error: Allowed memory size of 67108864 bytes exhausted (tried to allocate 21605379 bytes) in /home/thecodec/public_html/forumz/includes/mysqlbackup.php on line 498

So using GZIP is causing me to run out of memory?

EDIT: in fact i just turned off GZIP and get the same thing, it always ends on
Quote:
.............
Processing vb_announcementread (9) : Processed 9 Rows in 0.001 seconds
Processing vb_attachment (591)
Fatal error: Allowed memory size of 67108864 bytes exhausted (tried to allocate 21605379 bytes) in /home/thecodec/public_html/forumz/includes/mysqlbackup.php on line 498
EDIT2: here's my forum stats:
Quote:
Server Type Linux
Web Server Apache v2.0.63
PHP 5.2.9
MySQL Version 5.0.91-community-log
Data Usage 1.16 GB
PHP Max Post Size 50.00 MB
PHP Maximum Upload Size 50.00 MB
PHP Memory Limit 64.00 MB
MySQL Packet Size 64.00 MB
Index Usage 496.61 MB
Attachment Usage 76.69 MB
Avatar Usage 180.9 KB
Profile Picture Usage 74.0 KB

Simon Lloyd 09-28-2010 09:19 AM
UPDATE
I moved the attachments to the file system and can confirm that this mod works fine both with and without gzip.

I don't know if there was a work around to it but the post table was like 1.4Gb and it didn't stall at that and compressed it nicely to 331mb!

larry suttles 09-30-2010 07:23 AM
To set the date formate to a lower case "L" would is look like this??

Y-m-l

Or do I just put the lower case "l" by it's self?

l

Simon Lloyd 09-30-2010 05:40 PM
just the "l"

slowphantom 10-02-2010 04:25 AM
hi Pual

my host change my php.ini file

and since thay change it the hack dosnt work
i try it to run it but it give
Quote:
An error occured during the Backup :
that is all it dosnt give any des about the error

so i looked at the old one and the new one
and saw

disable_functions it have code will pm u with it

Thanks

Paul M 10-02-2010 11:54 AM
Quote:
Originally Posted by slowphantom (Post 2105792)
hi Pual

my host change my php.ini file
Change it back.

Ive looked at what you sent me and tbh, its a wonder anything works, ive never seen a disable functions list so large, it would take me ages to check through all the entries in it.

slowphantom 10-03-2010 01:39 PM
ok Paul Thanks
i change it back and its working again now :)


Thank You

d0zer 10-09-2010 11:06 AM
Thanks Paul M :)

Fynnon 10-15-2010 11:29 AM
Is there a PRO version which sends the database to a mail address after beeing gzip-ed?

faisalk 10-16-2010 02:25 PM
Thank you Paul.

Paul M 10-16-2010 05:30 PM
Quote:
Originally Posted by Fynnon (Post 2110348)
Is there a PRO version which sends the database to a mail address after beeing gzip-ed?
Nope.

ITDarasgah 11-21-2010 11:17 AM
Install and run manual show this
PHP Code:
Automatic Database Backup for vBulletin
Processing access (264) : Processed 264 Rows in 0.005 seconds
Processing action (No Row Data)
Processing adminhelp (1694) : Processed 1694 Rows in 0.045 seconds
Processing administrator (7) : Processed 7 Rows in 0 seconds
Processing adminlog (59083) : Processed 59083 Rows in 1.346 seconds
Processing adminmessage (No Row Data)
Processing adminutil (2) : Processed 2 Rows in 0 seconds
Processing album (4) : Processed 4 Rows in 0.001 seconds
Processing albumpicture (17) : Processed 17 Rows in 0 seconds
Processing albumupdate (No Row Data)
Processing announcement (2) : Processed 2 Rows in 0 seconds
Processing announcementread (154) : Processed 154 Rows in 0.002 seconds
Processing attachment (53112) : Processed 53112 Rows in 2.173 seconds
Processing attachmentcategory (No Row Data)
Processing attachmentcategoryuser (15217) : Processed 15217 Rows in 0.278 seconds
Processing attachmentpermission (25) : Processed 25 Rows in 0.001 seconds
Processing attachmenttype (18) : Processed 18 Rows in 0.001 seconds
Processing attachmentviews (No Row Data)
Processing avatar (No Row Data)
Processing bbcode (1) : Processed 1 Rows in 0 seconds
Processing bbcode_video (7) : Processed 7 Rows in 0 seconds
Processing bookmarksite (4) : Processed 4 Rows in 0 seconds
Processing cache (1) : Processed 1 Rows in 0 seconds
Processing cacheevent (3) : Processed 3 Rows in 0 seconds
Processing calendar (1) : Processed 1 Rows in 0 seconds
Processing calendarcustomfield (No Row Data)
Processing calendarmoderator (No Row Data)
Processing calendarpermission (No Row Data)
Processing contentpriority (No Row Data)
Processing contenttype (14) : Processed 14 Rows in 0.001 seconds
Processing cpsession (1) : Processed 1 Rows in 0.001 seconds
Processing cron (19) : Processed 19 Rows in 0.001 seconds
Processing cronlog (15362) : Processed 15362 Rows in 0.284 seconds
Processing customavatar (737) : Processed 737 Rows in 0.022 seconds
Processing customprofilepic (447) : Processed 447 Rows in 0.011 seconds
Processing cyb_logintouser (1) : Processed 1 Rows in 0 seconds
Processing datastore (32) : Processed 32 Rows in 0.081 seconds
Processing deletionlog (3683) : Processed 3683 Rows in 0.098 seconds
Processing discussion (No Row Data)
Processing discussionread (No Row Data)
Processing editlog (4348) : Processed 4348 Rows in 0.102 seconds
Processing event (5) : Processed 5 Rows in 0.001 seconds
Processing externalcache (No Row Data)
Processing faq (43) : Processed 43 Rows in 0.001 seconds
Processing filedata (14183) : Processed 14183 Rows in 0.607 seconds
Processing forum (193) : Processed 193 Rows in 0.02 seconds
Processing forumpermission (386) : Processed 386 Rows in 0.007 seconds
Processing forumprefixset (192) : Processed 192 Rows in 0.003 seconds
Processing forumread (No Row Data)
Processing groupmessage (No Row Data)
Processing groupmessage_hash (6) : Processed 6 Rows in 0.001 seconds
Processing groupread (No Row Data)
Processing holiday (No Row Data)
Processing humanverify (4) : Processed 4 Rows in 0 seconds
Processing hvanswer (No Row Data)
Processing hvquestion (1) : Processed 1 Rows in 0 seconds
Processing icon (36) : Processed 36 Rows in 0.001 seconds
Processing imagecategory (3) : Processed 3 Rows in 0 seconds
Processing imagecategorypermission (No Row Data) 

PHP Code:
Database error
******************************** database has encountered a problem.
Please try the following:

    * Load the page again by clicking the Refresh button in your web browser.
    * Open the www.itdarasgah.com home page, then try to open another page.
    * Click the Back button to try another link.

The www.itdarasgah.com forum technical staff have been notified of the error, though you may contact them if the problem persists.
 
We apologise for any inconvenience.
Database error in vBulletin 3.8.7 Beta 1: Invalid SQL: SHOW CREATE TABLE `indexqueue`; MySQL Error : Incorrect file format 'indexqueue' Error Number : 130 Request Date : Sunday, November 21st 2010 @ 07:08:16 AM Error Date : Sunday, November 21st 2010 @ 07:08:21 AM Script : http://www.*******.com/******/cronadmin.php?do=runcron&cronid=50 Referrer : http://www.********.com/******/cronadmin.php?do=modify IP Address : ********** Username : ****** Classname : vB_Database MySQL Version : 5.0.91-community 

Paul M 11-21-2010 11:31 AM
You have an issue with a table called indexqueue - try repairing it.

Btw - that is not a standard table in vb 3.8.x

ITDarasgah 11-21-2010 05:55 PM
Can you help me how can repair it .
and in my board its not run auto

Paul M 11-21-2010 10:54 PM
Quote:
Originally Posted by SHER (Post 2124305)
Can you help me how can repair it .
and in my board its not run auto
Use phpmyadmin to repair it - or even the repair option in the vbulletin ACP.

I dont really understand the last part of your post.

ITDarasgah 11-21-2010 11:20 PM
Quote:
Originally Posted by Paul M (Post 2124447)
Use phpmyadmin to repair it - or even the repair option in the vbulletin ACP.

I dont really understand the last part of your post.
Thank you Paul for reply , I mean this mod is not working for Automatic Backup just work manual but with the above errer . While I set time in Scheduled Task Manager

ITDarasgah 11-22-2010 12:09 AM
After delete that table and Run manual its work and stop after this is this is complete or not
PHP Code:
Automatic Database Backup for vBulletin
Processing access (265) : Processed 265 Rows in 0.004 seconds
Processing action (No Row Data)
Processing adminhelp (1694) : Processed 1694 Rows in 0.037 seconds
Processing administrator (7) : Processed 7 Rows in 0.001 seconds
Processing adminlog (59227) : Processed 59227 Rows in 1.355 seconds
Processing adminmessage (No Row Data)
Processing adminutil (2) : Processed 2 Rows in 0 seconds
Processing album (4) : Processed 4 Rows in 0 seconds
Processing albumpicture (17) : Processed 17 Rows in 0.001 seconds
Processing albumupdate (No Row Data)
Processing announcement (2) : Processed 2 Rows in 0 seconds
Processing announcementread (154) : Processed 154 Rows in 0.002 seconds
Processing attachment (53150) : Processed 53150 Rows in 2.231 seconds
Processing attachmentcategory (No Row Data)
Processing attachmentcategoryuser (15217) : Processed 15217 Rows in 0.274 seconds
Processing attachmentpermission (25) : Processed 25 Rows in 0.001 seconds
Processing attachmenttype (18) : Processed 18 Rows in 0.001 seconds
Processing attachmentviews (No Row Data)
Processing avatar (No Row Data)
Processing bbcode (1) : Processed 1 Rows in 0 seconds
Processing bbcode_video (7) : Processed 7 Rows in 0 seconds
Processing bookmarksite (4) : Processed 4 Rows in 0 seconds
Processing cache (1) : Processed 1 Rows in 0 seconds
Processing cacheevent (3) : Processed 3 Rows in 0 seconds
Processing calendar (1) : Processed 1 Rows in 0 seconds
Processing calendarcustomfield (No Row Data)
Processing calendarmoderator (No Row Data)
Processing calendarpermission (No Row Data)
Processing contentpriority (No Row Data)
Processing contenttype (14) : Processed 14 Rows in 0.001 seconds
Processing cpsession (1) : Processed 1 Rows in 0.003 seconds
Processing cron (19) : Processed 19 Rows in 0.002 seconds
Processing cronlog (15391) : Processed 15391 Rows in 0.295 seconds
Processing customavatar (738) : Processed 738 Rows in 0.023 seconds
Processing customprofilepic (449) : Processed 449 Rows in 0.011 seconds
Processing cyb_logintouser (1) : Processed 1 Rows in 0 seconds
Processing datastore (32) : Processed 32 Rows in 0.018 seconds
Processing deletionlog (3683) : Processed 3683 Rows in 0.089 seconds
Processing discussion (No Row Data)
Processing discussionread (No Row Data)
Processing editlog (4353) : Processed 4353 Rows in 0.094 seconds
Processing event (5) : Processed 5 Rows in 0.001 seconds
Processing externalcache (No Row Data)
Processing faq (43) : Processed 43 Rows in 0.001 seconds
Processing filedata (14183) : Processed 14183 Rows in 0.59 seconds
Processing forum (193) : Processed 193 Rows in 0.019 seconds
Processing forumpermission (386) : Processed 386 Rows in 0.006 seconds
Processing forumprefixset (192) : Processed 192 Rows in 0.002 seconds
Processing forumread (No Row Data)
Processing groupmessage (No Row Data)
Processing groupmessage_hash (6) : Processed 6 Rows in 0 seconds
Processing groupread (No Row Data)
Processing holiday (No Row Data)
Processing humanverify (4) : Processed 4 Rows in 0.001 seconds
Processing hvanswer (No Row Data)
Processing hvquestion (1) : Processed 1 Rows in 0 seconds
Processing icon (36) : Processed 36 Rows in 0.001 seconds
Processing imagecategory (3) : Processed 3 Rows in 0 seconds
Processing imagecategorypermission (No Row Data)
Processing infraction (168) : Processed 168 Rows in 0.007 seconds
Processing infractionban (1) : Processed 1 Rows in 0 seconds
Processing infractiongroup (No Row Data)
Processing infractionlevel (4) : Processed 4 Rows in 0 seconds
Processing language (1) : Processed 1 Rows in 0.008 seconds
Processing mailqueue (No Row Data)
Processing memberviews (No Row Data)
Processing membervisits (No Row Data)
Processing moderation (74) : Processed 74 Rows in 0.001 seconds
Processing moderator (171) : Processed 171 Rows in 0.004 seconds
Processing moderatorlog (82662) : Processed 82662 Rows in 4.363 seconds
Processing notice (9) : Processed 9 Rows in 0.001 seconds
Processing noticecriteria (14) : Processed 14 Rows in 0.001 seconds
Processing noticedismissed (776) : Processed 776 Rows in 0.009 seconds
Processing package (1) : Processed 1 Rows in 0 seconds
Processing passwordhistory (25487) : Processed 25487 Rows in 0.367 seconds
Processing paymentapi (7) : Processed 7 Rows in 0.001 seconds
Processing paymentinfo (No Row Data)
Processing paymenttransaction (No Row Data)
Processing phrase (11999) : Processed 11999 Rows in 0.37 seconds
Processing phrasetype (67) : Processed 67 Rows in 0.002 seconds
Processing picture (17) : Processed 17 Rows in 0.005 seconds
Processing picturecomment (No Row Data)
Processing picturecomment_hash (No Row Data)
Processing picturelegacy (17) : Processed 17 Rows in 0.001 seconds
Processing plugin (251) : Processed 251 Rows in 0.01 seconds
Processing pm (300027) : Processed 300027 Rows in 6.285 seconds
Processing pmreceipt (14) : Processed 14 Rows in 0.001 seconds
Processing pmtext (15087) : Processed 15087 Rows in 0.695 seconds
Processing pmthrottle (No Row Data)
Processing podcast (No Row Data)
Processing podcastitem (No Row Data)
Processing poll (129) : Processed 129 Rows in 0.005 seconds
Processing pollvote (3190) : Processed 3190 Rows in 0.065 seconds
Processing post (726386) : Processed 726386 Rows in 38.915 seconds
Processing post_thanks (123861) : Processed 123861 Rows in 2.35 seconds
Processing postedithistory (9949) : Processed 9949 Rows in 0.421 seconds
Processing posthash (8) : Processed 8 Rows in 0.001 seconds
Processing postindex (9087571) 

and please guide me how can set for daily backup on 2:00 AM

Paul M 11-22-2010 08:36 PM
No thats not complete. Processing 9 million records will take a long while, your browser may well time out.

Installing the mod creates the necessary [vb] scheduled task. You just need to alter the time of it.

ITDarasgah 11-24-2010 10:32 PM
Quote:
Originally Posted by Paul M (Post 2124774)
No thats not complete. Processing 9 million records will take a long while, your browser may well time out.

Installing the mod creates the necessary [vb] scheduled task. You just need to alter the time of it.
Thanks for reply:)
I did not find that mod You can identify or give me the link

Paul M 11-25-2010 11:14 AM
What mod ?

ITDarasgah 11-25-2010 11:28 AM
Quote:
Originally Posted by Paul M (Post 2124774)
No thats not complete. Processing 9 million records will take a long while, your browser may well time out.

Installing the mod creates the necessary [vb]
I am saying about that..:)

snowlion 11-25-2010 12:48 PM
Quote:
Originally Posted by SHER (Post 2125598)
I am saying about that..:)
He is talking about this mod :D

Paul M 11-25-2010 01:33 PM
Quote:
Originally Posted by SHER (Post 2125598)
I am saying about that..:)
Quote:
Originally Posted by snowlion (Post 2125613)
He is talking about this mod :D
Yep. :)

ITDarasgah 11-25-2010 02:52 PM
Quote:
Originally Posted by snowlion (Post 2125613)
He is talking about this mod :D
Quote:
Originally Posted by Paul M (Post 2125625)
Yep. :)
:eek::p
Then give me an Advice about the time out, What should I do?

Paul M 11-25-2010 04:04 PM
TBH, I suggest you switch to using the mysql full text search, and empty out the old search tables (of which postindex is one).

ITDarasgah 11-25-2010 07:30 PM
Quote:
Originally Posted by Paul M (Post 2125666)
TBH, I suggest you switch to using the mysql full text search, and empty out the old search tables (of which postindex is one).
Thank you :)

but how , Unfortunately I am not programmer can tell you in detail I am thankful to you.

I'm sorry to waste your time


All times are GMT. The time now is 10:07 AM.
Page 10 of 12 « First 89 10 1112
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.01899 seconds
  • Memory Usage 1,922KB
  • 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_php_printable
  • (18)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