vb.org Archive
Page 2 of 3 1 2 3
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 - Automatic Database Back-up (https://vborg.vbsupport.ru/showthread.php?t=114097)

bashy 04-27-2006 03:10 PM
Of cousre i didnt, else it would have worked...pmsl... :o

Cheers boofo, its usually the most obvious :o

Quote:
Originally Posted by Boofo
Did you chmod the directory to 777 like it says to?

bashy 04-27-2006 03:15 PM
One small query if i may?
My normal database backup is about 30mb
Using this hack its 25mb (not using compression) why would this be please?

Boofo 04-27-2006 03:17 PM
Quote:
Originally Posted by Zidane007nl
Installed it without problems. Great job. That will hopefully protect me more from my forum being hacked...
It won't protect you or off any more sevurity than you have now. It will just make it faster and easier for you to get your site up and going again. ;)

Boofo 04-27-2006 03:43 PM
Quote:
Originally Posted by bashy
One small query if i may?
My normal database backup is about 30mb
Using this hack its 25mb (not using compression) why would this be please?
That's normal, you're ok. The database takes up space, too. ;)

bashy 04-27-2006 04:47 PM
Ok boofo only if ya sure, cant quite get my head around that actually..

Normal backup is 32.54mb on my pc
This hack backup 24.56mb pn my pc

So what actually cause this, just so i can get my head around it please :)

Boofo 04-27-2006 05:32 PM
Quote:
Originally Posted by bashy
Ok boofo only if ya sure, cant quite get my head around that actually..

Normal backup is 32.54mb on my pc
This hack backup 24.56mb pn my pc

So what actually cause this, just so i can get my head around it please :)
Haven't you been deleteing some hacks off of your site lately? ;)

Beller 04-27-2006 07:23 PM
It seems to be working fine.
Is it supposed to create an empyt error txt file with each back up?

topsoftware 04-27-2006 09:24 PM
helo
i instal this hack but i have error
Automatic Database Back-up

Warning: exec() has been disabled for security reasons in /includes/cron/databack.php on line 21

Warning: exec() has been disabled for security reasons in /includes/cron/databack.php on line 26
i musy change any to databack.php fike
tha,ks

Logikos 04-27-2006 09:32 PM
Your host has that feature disabled. You have to contact them to enable it.

Logikos 04-27-2006 09:34 PM
Quote:
Originally Posted by bashy
Ok boofo only if ya sure, cant quite get my head around that actually..

Normal backup is 32.54mb on my pc
This hack backup 24.56mb pn my pc

So what actually cause this, just so i can get my head around it please
Bashy, thats normal. Its all in how the file is created, line brakes, whitespace, etc... I assure you there isn't any missing data. ;)

BeaLzeBuB 04-27-2006 10:29 PM
thats is thank you man.
installed

now waiting

theArchitect 04-27-2006 10:34 PM
Quote:
Originally Posted by theArchitect
Forgive the nOObie question, but does this work using the same system as a SSH autobackup?

I have set-up a script, with a friends help on my server which takes care of my back-ups, but this hack could be useful for other site I work on where I don't have SSH access and can't set-up something similar to my system.

But I am very nervous of the AdminCP back-up system.
Just bumping my own question.

Logikos 04-27-2006 11:27 PM
Yes this is the same concept, instead php is running the command and pointing to which directory to save to. Sorry, must have missed your comment theArchitect. :)

topsoftware 04-28-2006 04:53 AM
Quote:
Originally Posted by LiveWire
Your host has that feature disabled. You have to contact them to enable it.
i dont anderstand can you help me or unistal hack

Logikos 04-28-2006 05:54 AM
Your hosting provider has disable that feature on there sever. You have to ask them to enable it, or you won't beable to use this hack.

briansol 04-28-2006 01:55 PM
I would LOVE to see this made into a full/bitwise backup system.

Sunday night, Full back up.
Monday-sat, just each day's back up.

repeats, overwriting sunday's and so on...

On big boards, it can sometimes take 4 hours to back up a database, and doing this on a daily basis is simply not feasable.

Mattikana 04-28-2006 08:00 PM
Typo: Database Backup Settings

Boofo 04-28-2006 09:22 PM
Quote:
Originally Posted by Mattikana
Typo: Database Backup Settings
You don't have any Settigs? You must be using one of them high-falootin' message boards. ;)

Feckie (Roger) 04-28-2006 09:53 PM
LiveWire

Anychance of adding the FTP back-up to this also

:cool:

Logikos 04-29-2006 01:22 AM
@briansol I could look into this over the weekend.
@Feckie (Roger) Example? Whats an FTP Backup?

rinkrat 04-29-2006 04:00 AM
Works great, and even gets compressed. Sweet!

Logikos 04-29-2006 04:56 AM
Glad you like rinkrat! :)

hadog 04-29-2006 09:12 AM
Hi
I installed
I get an error file created when run

'mysqldump' is not recognized as an internal or external command,
operable program or batch file.

I am running mysql5 if that is a help

Feckie (Roger) 04-29-2006 11:01 AM
Quote:
Originally Posted by LiveWire
@briansol I could look into this over the weekend.
@Feckie (Roger) Example? Whats an FTP Backup?

Backing up to an external ftp site

(Offsite To Where The Main Server Is)

gedsta 04-29-2006 06:10 PM
Warning: exec(): Unable to fork [mysqldump --add-drop-table -hlocalhost -uxxxx -pxxxx xxxx_ 2>c:/Inetpub/vhosts/xxxx/httpdocs/forum/xxxx/databack//04-29-2006-error.txt >c:/Inetpub/vhosts/xxxx/httpdocs/forum/xxxx/databack//04-29-2006.sql] in \includes\cron\databack.php on line 21

help please :-)

Logikos 04-29-2006 08:27 PM
@hadog, I'll have to see what to use for mysql5. For the time being, I would disable this product.

@gedsta, it looks like the script was trying to fork too many times. Ask your host to increased the process limit for exec() and give it a shot. Should work after that.

yinyang 04-30-2006 06:14 AM
installed and working flawlessly. thanks!

BeaLzeBuB 04-30-2006 10:08 AM
Quote:
Originally Posted by BeaLzeBuB
thats is thank you man.
installed

now waiting
it is working great :D

creedmaniac 04-30-2006 05:47 PM
is this supposed to create a date.sql and a date-error.sql everytime it runs? (i'm hoping it's supposed to be making the error.sql...cuz if it's not something's wrong with mine...it's going to the correct folder though so i don't know what else would be wrong)

Sleazy 04-30-2006 06:07 PM
Hi,

For some reason this hack creates the tar files in my backup folder each day but they are always empty. Any idea of what maybe causing this?

Thanks

jamshed 05-01-2006 08:17 AM
Hay

when i hit Scheduled Task Manager on Run Now i got problem :S

Code:
Invalid SQL:

                        INSERT INTO upload_cronlog
                                (cronid, dateline, description)
                        VALUES
                                (25, 1146474570, 'Saved backup of databse to /public_html/forum/XXXX on 05-1-2006 at 5:09am (file name 05-1-2006.tar.gz');

MySQL Error  : Table 'slipenc_vb.upload_cronlog' doesn't exist
Error Number : 1146
Date        : Monday, May 1st 2006 @ 05:09:31 AM
Script      : http://www.XXXXX.com/forum/admincp/cronadmin.php?do=runcron&cronid=25
Referrer    : http://www.XXXXXX.com/forum/admincp/cronadmin.php?do=modify
IP Address  : XXXXXXXXXXX
Username    : XXXXXX
Classname    : vb_database
help plz

Logikos 05-01-2006 10:16 AM
Jamshed, It looks like your log_cron_action() function was changed. The default vBulletin table is called cronlog. In your error, it is showing up as upload_cronlog.

What is your table_prefix named? You can find the name by opening the /includes/config.php file and looking for:
PHP Code:
$config['Database']['tableprefix'] 
I also need you to post your log_cron_action() function. Open /includes/functions_cron.php and search for:
PHP Code:
function log_cron_action($description, $nextitem) 
Post the code in between the brackets ({}). The default vB function is:

PHP Code:
function log_cron_action($description, $nextitem)
{
    global $vbulletin;

    if (defined('ECHO_CRON_LOG'))
    {
        echo "<p>$description</p>";
    }

    if ($nextitem['loglevel'])
    {
        /*insert query*/
        $vbulletin->db->query_write("
            INSERT INTO " . TABLE_PREFIX . "cronlog
                (cronid, dateline, description)
            VALUES
                ($nextitem[cronid], " . TIMENOW . ", '" . $vbulletin->db->escape_string($description) . "')
        ");
    }
} 
Also, does this happen on all your task managers? Try running another one and let me know if the same thing happens. :)

tqvn2004 05-01-2006 10:38 AM
I cann't get this hack to work on my site! I did as instructed, and chmod the folder as 777, but there is no output sql file when I try to run the cron task!

My host does not specify _SERVER[PATH_TRANSLATED], _SERVER["DOCUMENT_ROOT"] is "/customers/x-cafe.com/x-cafe.com/httpd.www/", therefore I set the File Dump Path as "/customers/x-cafe.com/x-cafe.com/httpd.www/forum/backups". And the backups folder is 777. I received no error message when running cron task, it said DONE. But no file is outputed! Please help!

jamshed 05-01-2006 12:59 PM
LiveWire Big Thanks problem solve..:banana: :banana:

creedmaniac 05-01-2006 02:47 PM
Quote:
Originally Posted by creedmaniac
is this supposed to create a date.sql and a date-error.sql everytime it runs? (i'm hoping it's supposed to be making the error.sql...cuz if it's not something's wrong with mine...it's going to the correct folder though so i don't know what else would be wrong)
you skipped me livewire :)

Logikos 05-01-2006 09:00 PM
@creedmaniac and tqvn2004: Upload the attached file anywhere on your site and send me a PM of the link so I can check your server settings.

Didn't mean to skip :p

Logikos 05-02-2006 02:50 AM
@creedmaniac: Thanks for the quick PM! Okay make sure that your File Dump Path setting is set to the following.

I would suggest place this in a folder outsite of the public_html folder for security reason. To do this, log into your website via FTP. This will place you in the /home/inara/ directory. Create a folder and name it whatever you want. I named mine databack.

Once you have finished that. Log into your admincp panel and make your way to the Database Backup Settigs. This is under the vBulletin Options. Make your your File Dump Path settings is set to /home/inara/databack (no ending slash). Then run the cron and give it a good 15 mins to transfer the database to that folder. The time all depends on the size of your database. Let me know if that fixed it. :)

ConqSoft 05-02-2006 02:57 AM
How about an option to have it keep the last X number of backups, and rotate out the old ones as needed? (Sorry if this has already been suggested; I didn't read the whole thread.)

Thanks!

hadog 05-02-2006 08:15 AM
LiveWire
get any time to check on my problem? Mysql5 and autobackup?

rmxs 05-02-2006 08:25 AM
Thanks very Usefull


All times are GMT. The time now is 11:38 PM.
Page 2 of 3 1 2 3
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.01434 seconds
  • Memory Usage 1,828KB
  • 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_code_printable
  • (3)bbcode_php_printable
  • (11)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (2)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