Vbulletin Database Backup Pro (Cron Support)

[Paul M]

I still need help: After restoring my vBulletin Board, it's stuck at the Backup in Progress screen...what do I need to do??Turn it back on via the ACP (options).

[Kirk Y]

When the board is disabled you cannot do anything. Login.php displays the same down page...

http://www.socomcity.net/forum/index.php is the website, if you'd like to see...

[Paul M]

When the board is disabled you cannot do anything. Login.php displays the same down page...

http://www.socomcity.net/forum/index.php is the website, if you'd like to see...You have to login direct to your ACP ;

http://www.socomcity.net/forum/admincp/index.php

[xZEUSx]

When you try to log in it takes you right back to the index were the Backup Database message is displayed.

I know this because Im also an admin for the site...who paid the money for it. So if you have any other ideas please post them.

[Kirk Y]

You have to login direct to your ACP ;

http://www.socomcity.net/forum/admincp/index.php

I tried that, after I type in my Username and Password, I'm sent to login.php, where the Backup In Progress message is displayed.

[xZEUSx]

Hello? Can someone please help Acid and I with our problem.

Were still stuck at the Backup in Progress screen and we can't log in with the ACP.

[AnaHost]

Great

Thanx

[AKOYLINI]

hello if i run the script all is ok ,but in Scheduled job nothing happend,i make Scheduled
every 1hour and nothing happend.

[Trigunflame]

I will get around to all the problems ASAP. I've been gone for a while with some business related issues.

I will get Version 2 out ASAP; I am still working on some side projects such as the PHP Torrent tracker "Server", that runs on its own "lite http Server".

Benefits of this being all active data can be processes and handled in memory instead of relying on database queries.

As for DB Backup Pro 2, as I mentioned its a work in process.. I am having to rewrite the entire documentation and re-code it from scratch which is taking a while.. as I am trying to make it work like it should.

[Christine]

This is awesome. :D

If anyone wants the listing of all the tables to dump all except the postindex, search, and word tables (search), let me save you some typing: $backup['TABLES'] = array('access', 'adminhelp', 'administrator', 'adminlog', 'adminutil', 'announcement', 'attachment', 'attachmenttype', 'attachmentviews', 'avatar', 'bbcode', 'calendar', 'calendarcustomfield', 'calendarmoderator', 'calendarpermission', 'cron', 'cronlog', 'customavatar', 'customprofilepic', 'datastore', 'deletionlog', 'editlog', 'event', 'faq', 'forum', 'forumpermission', 'holiday', 'icon', 'imagecategory', 'imagecategorypermission', 'language', 'mailqueue', 'moderation', 'moderator', 'moderatorlog', 'passwordhistory', 'phrase', 'phrasetype', 'pm', 'pmreceipt', 'pmtext', 'poll', 'pollvote', 'post', 'posthash', 'profilefield', 'ranks', 'regimage', 'reminder', 'reputation', 'reputationlevel', 'session', 'setting', 'settinggroup', 'smilie', 'stats', 'strikes', 'style', 'subscribeevent', 'subscribeforum', 'subscribethread', 'subscription', 'subscriptionlog', 'template', 'thread', 'threadrate', 'threadviews', 'upgradelog', 'user', 'useractivation', 'userban', 'userfield', 'usergroup', 'usergroupleader', 'usergrouprequest', 'usernote', 'userpromotion', 'usertextfield', 'usertitle');


* Christine installs with thanks!!

[mkdevo]

installed, and running perfectly.

i do have one question though - if you're backing up your db to a directory on your web server, and you CHMOD it to 777, what's stopping someone (assuming they find out what dir it is) from 'stealing' all of your data?

[ImportPassion]

you should NEVER backup to a dir in your webroot. go one level up.

[neocorteqz]

you should NEVER backup to a dir in your webroot. go one level up.
That, and if i recall, you need only chmod your directory to 755, and if you should choose to leave your backups to a directory in webroot, and not one directory above. You should ALWAYS password protect the directory. .htaccess is secure, easy and simple to do.

if you're running a windows server, well then you're outta luck. :p Ok not really. :)

[Lionel]

Trigunflame, do you remember the change that you did for me? It stopped backing up for a while now. In fact it backed up only for one week...

[Greebo]

Sir. Read The Message.

Failover was initiated for MySQLDump Binary
but backup completed successfully.

If the dump exist in its path, then its ok. That is just informing you that the backup could not use MySQLDump, and had to resort to PHPDump.
I'm getting this too - I know its succeeding, but what would be causing it to be unable to use MySQLDump?

In my case, mysqldump is accessible from everywhere - but I get an error in apache sh: line 1: /mysqldump: No such file or directory each time it runs, even when I've explicitl mapped the path.

[Greebo]

Never mind - just read the bit about safemode blocking it.

:(

I guess phpdump is it. I'm not turning off safemode. :)

[waza]

Euh, It doesn't work :(.
I don't receive an error, but the file is not in the folder I wrote in the config file :s

[kylek]

Trying to learn and install this, done everything except when task is run manually get this error;

An error occured during the MySQL backup. Details (Could not open Destination SQL file for writing. (/httpdocs/forum/backups/06_04_05.sql))

Directory is / - has all web files on it - cant add a directory
/forum where forum is right now
/forum/backups where i have backups file

So the path is - $backup['DUMP_PATH' = '/forum/backups';

Is this the right path to use? Confusing to newbie!

[kylek]

Trying to learn and install this, done everything except when task is run manually get this error;

An error occured during the MySQL backup. Details (Could not open Destination SQL file for writing. (/httpdocs/forum/backups/06_04_05.sql))

Directory is / - has all web files on it - cant add a directory
/forum where forum is right now
/forum/backups where i have backups file

So the path is - $backup['DUMP_PATH' = '/forum/backups';

Is this the right path to use? Confusing to newbie!

Added full path and it works great - off to click 'install"

[Bernd]

Trying to backup the database after a faulty mod install, but I receive the following error:

You have an error in your sql syntax; check the manual that corresponds to your MSQL version for the right syntax to use near 'c4dportal < 1.sql' at line one.

I've emptied the c4dportal database and tried using the mysql command to restore the database.

[waza]

Bug:
If my forum is set to off, and I or My forum runs the backup script, it is still set to off, but The offline message isn't there and it is just like it's on.

[clearchannel]

I have installed and it works great clicks install.

One question. If I compress my database during backup, what is the syntax I use to restore the database?

excample: mysql -uusername -p databasename </home/virtual/site1/fst/var/www/html/forums/backups/databasename.sql.gz

[Mosh]

I have installed and it works great clicks install.

One question. If I compress my database during backup, what is the syntax I use to restore the database?

excample: mysql -uusername -p databasename </home/virtual/site1/fst/var/www/html/forums/backups/databasename.sql.gz
Firstly you need to run gzip to uncompress the archive:

gzip -d /home/virtual/site1/fst/var/www/html/forums/backups/databasename.sql.gz

Then run:

mysql -uusername -ppassword databasename < /home/virtual/site1/fst/var/www/html/forums/backups/databasename.sql

ADDITION: When you refresh the forum, you may have to login to the admincp, if you choose to turn them off when the backup was being performed:

goto vBulletin Options -> vBulletin Options -> Turn Your vBulletin On and Off -> Forum Active. Ensure the Yes radio button is selected and click Save (yes even if it was already selected the saving of it will re-enable the forums).

[quachvu]

hi i have this error
Fatal error: Call to undefined function: ini_get_all() in /var/www/web0/html/forum/includes/mysqlbackup.php on line 1794
any idea?

[clearchannel]

Firstly you need to run gzip to uncompress the archive:

gzip -d /home/virtual/site1/fst/var/www/html/forums/backups/databasename.sql.gz



Thank you for the quick response.

I have one other small problem. If I run the script manually, the backup appears as intended in the backup directory.

It will not run automatically?
There are no logs enteries, the task manager states it is scheduled to run at the specficed time, but beyond that, nothing happens?

Great script BTW.

[neocorteqz]

Thank you for the quick response.

I have one other small problem. If I run the script manually, the backup appears as intended in the backup directory.

It will not run automatically?
There are no logs enteries, the task manager states it is scheduled to run at the specficed time, but beyond that, nothing happens?

Great script BTW.
started happening to me after I upgraded the script.

It may be the FTP dump option.

[mkdevo]

one problem - this doesn't seem to be pruning old backups for me. i have the # of backups to keep set to 2, but it just keeps adding to the backups that were already there..

[n_wattam]

<font color="red">I would like to see an option for restoring a database back... this also is a pain unless you have shell access.</font>

[Dream]

great! the exec() worked somehow :)

might I suggest putting the vb version in the filename, and maybe some other date format options

[dsboyce8624]

Okay, this ran fine until a couple days ago, now I get this:

Could not fetch database options. Shutting backup down.

Help please?

[snake-boy]

.

It will not run automatically?
There are no logs enteries, the task manager states it is scheduled to run at the specficed time, but beyond that, nothing happens?

Great script BTW.

I'm getting the exact same thing. Works perfectly if forced to run, but as a vb cron job it does nothing at all. It doesn't even appear in the logs as failed. Just nothing happens at all.

This is SO useful to me, I do hope you can get to the bottom of this problem?

thanks

-snake

[dsboyce8624]

I'm getting the exact same thing. Works perfectly if forced to run, but as a vb cron job it does nothing at all. It doesn't even appear in the logs as failed. Just nothing happens at all.

This is SO useful to me, I do hope you can get to the bottom of this problem?

thanks

-snake

No, mine ran fine for a month in Sched Tasks, the stopped for some reason.

[neocorteqz]

No, mine ran fine for a month in Sched Tasks, the stopped for some reason.
I think this is the same for all.

[snake-boy]

I think this is the same for all.

Ok, so what's the solution?

-snake

[clearchannel]

Ok, so what's the solution?

-snake

I downloaded the package and reinstalled. For whatever reason, it is working as designed.

I won't know if it is pruning older dumps for a few more days.

[bspiller82]

The backup is making the .sql file however it is not compressing it. I ran the test mode and it gave the following error, however it made the .sql file. It also did not upload to the remtoe FTP.

Daily BackUp
An error occured while outputing a New GZ file with the PHP GZ ZLIB Module.

[mkdevo]

one problem - this doesn't seem to be pruning old backups for me. i have the # of backups to keep set to 2, but it just keeps adding to the backups that were already there..

just to expand on this - the local pruning IS working. FTP prune is not working.

[dsboyce8624]

I downloaded the package and reinstalled. For whatever reason, it is working as designed.

I won't know if it is pruning older dumps for a few more days.

No go for me doing this.

It'd be nice if we could figure out why it stopped working.

[DiSH]

Trigunflame,
GREAT SYSTEM! In fact, after reviewing this work, features, notes....it's hard to believe the vBulletin folks didn't work an automated backup system into the base software! A real asset for hard working folks out there who don't have the time to run backups manually!

I gave it a shot tonight, installed as directed, configured variables as required, and ran the script. I got the error message at the bottom. Any ideas? I think it's just a simple database access problem (?) but I checked the config variables over and over, and it all looks right to me. In fact, it's the exact login info I use to access the database directly through PHPMyAdmin, so I don't know....

FYI: I ran the backup with the config script set to use MySQLDump and also the PHP mode, and it spit the same exact error both times...It also created two SQL files in the backup directory, both completely blank & showing 0KB, but named correctly.

Config data requested:
PHP 4.3.1
MySQL 4.0.22-nt
vBulletin 3.0.7

Thanks for reading,
DiSH

P.S. - forgot -- like all scheduled tasks, there must be activity on the boards at the specified cron time for it to run, correct? If not, it runs the next time anyone visits? Thanks.

===== ERROR MESSAGE RECEIVED BY EMAIL ======
Database error in vBulletin 3.0.7:

Invalid SQL: LOCK TABLES `access` READ, `adminhelp` READ, `administrator` READ, `adminlog` READ, `adminutil` READ, `announcement` READ, `attachment` READ, `attachmenttype` READ, `attachmentviews` READ, `avatar` READ, `bbcode` READ, `calendar` READ, `calendarcustomfield` READ, `calendarmoderator` READ, `calendarpermission` READ, `cpsession` READ, `cron` READ, `cronlog` READ, `customavatar` READ, `customprofilepic` READ, `datastore` READ, `deletionlog` READ, `editlog` READ, `event` READ, `faq` READ, `forum` READ, `forumpermission` READ, `holiday` READ, `icon` READ, `imagecategory` READ, `imagecategorypermission` READ, `language` READ, `mailqueue` READ, `moderation` READ, `moderator` READ, `moderatorlog` READ, `passwordhistory` READ, `phrase` READ, `phrasetype` READ, `pm` READ, `pmreceipt` READ, `pmtext` READ, `poll` READ, `pollvote` READ, `post` READ, `post_parsed` READ, `posthash` READ, `postindex` READ, `profilefield` READ, `ranks` READ, `regimage` READ, `reminder` READ, `reputation` READ, `reputationlevel` READ, `search` READ, `session` READ, `setting` READ, `settinggroup` READ, `smilie` READ, `stats` READ, `strikes` READ, `style` READ, `subscribeevent` READ, `subscribeforum` READ, `subscribethread` READ, `subscription` READ, `subscriptionlog` READ, `template` READ, `thread` READ, `threadrate` READ, `threadviews` READ, `upgradelog` READ, `user` READ, `useractivation` READ, `userban` READ, `userfield` READ, `usergroup` READ, `usergroupleader` READ, `usergrouprequest` READ, `usernote` READ, `userpromotion` READ, `usertextfield` READ, `usertitle` READ, `word` READ; mysql error: Access denied for user: 'flaggotsohio@%' to database 'flaggotsforum'

mysql error number: 1044

Date: Wednesday 15th of June 2005 12:03:19 AM

[Paul M]

I have had this installed for about 6 weeks now - the basic backups are working, but some of the features are not.

1. I had it set to zip files - sometimes this worked, sometimes it failed. When it failed there was no entry in the scheduled tasks loh either. I have given up on this and turned off zipping.

2. FTP failed to work so backups are stored locally.

3. Pruning fails to work, nothing seems to make it want to do this.

In short, it does the basic backup, but I have to zip the file and transfer it to another location manually. I have to prune manually.

[Paul M]

Go into your ACP, then into the vBulletin options to turn your forum on/off.

BTW - your error is (I believe) because your mysql user does not have the rights to lock tables.

[DiSH]

Wow, you're fast on the trigger! I'm here in Cincinnati Ohio, and it's 1:00 a.m.....very sleepy.

Yeah, as soon as I posted that last message I figured it out and fixed it, then quickly deleted my post so as to hide my inexperience..... ;-))

I'll check on the user rights situation as far as locking tables, though. Thanks for the tip!

DiSH

[Paul M]

Wow, you're fast on the trigger! I'm here in Cincinnati Ohio, and it's 1:00 a.m.....very sleepy.It's 6am here (uk) - I work nights. :)

Yeah, as soon as I posted that last message I figured it out and fixed it, then quickly deleted my post so as to hide my inexperience..... ;-))Too late - it makes my reply look a bit odd now tho .......... :)

[bspiller82]

The backup is making the .sql file however it is not compressing it. I ran the test mode and it gave the following error, however it made the .sql file. It also did not upload to the remote FTP.

Daily BackUp
An error occured while outputing a New GZ file with the PHP GZ ZLIB Module.

[TopperARG]

Seems to work fine but even after the backup is made correctly and the forums are up again it says:

Failover was initiated for MySQLDump Binary, but dump completed successfully

Is this an error?

//EDIT: I just read this reply made later: "If the dump exist in its path, then its ok. That is just informing you that the backup could not use MySQLDump, and had to resort to PHPDump"

Well...it's weird but It works for me.

Thanks and nice job !

[CHIngs]

There is a weird bug in your backup system that I have just found out.

When you set $backup['FTP'] to 1, the script does not log the entries in the "scheduled task logs." I did not believe it at first, but once I set it to 0, the logging began again. The backups are done fine when it was set to 1, but only the log entries werent happening.

[Aurore]

Worked great but since I past to vB 3.5 it does not work anymore

[Paul M]

Worked great but since I past to vB 3.5 it does not work anymoreNope, it won't work in 3.5.0 without a few minor changes.

[CHIngs]

There is a weird bug in your backup system that I have just found out.

When you set $backup['FTP'] to 1, the script does not log the entries in the "scheduled task logs." I did not believe it at first, but once I set it to 0, the logging began again. The backups are done fine when it was set to 1, but only the log entries werent happening.

CAN ANYONE HELP ME???

[Paul M]

If you backups are working, I wouldn't worry about a minor bug in mere log entries. :)

[lttcoder]

If you move host/reinstall plugin it will not work anymore. (automatic bacukp)
But you still can run it manually by clicking "Run Now".

[sketch42]

any news on version 2?

[Paul M]

any news on version 2?The author has not been seen since June 17th ......

[sketch42]

how do i shut down openbasedir? i turned of safemode but i cant fin openbasedir in the php.ini file

[Paul M]

it should be in your httpd.conf

[CHIngs]

If you backups are working, I wouldn't worry about a minor bug in mere log entries. :)
My point is, the backups are not working thru ftp either. There is no point in backing up on the same server for obvious reasons.

[Paul M]

My point is, the backups are not working thru ftp either. Sorry, but your words suggested you were "fine" - hence my post.
The backups are done fine when it was set to 1, but only the log entries werent happening

More bad news for you as well - if you check the new feature at the top, you will see ;
Trigunflame

Last Online:
Jun 2005 So I don't think you will get an answer anytime soon. :(

[derekivey]

Great mod! Just installed and it works great. :)

[mikehawk]

Noobed out hard. Can someone explain to me what I put here?

examples;

HOST = 'localhost' (default)
USER = 'root' (default)
PASS = ' ' (default)
DB = 'forums' (default)
-----------------------------------------------------------
*/

$backup['HOST'] = 'localhost';
$backup['USER'] = 'root';
$backup['PASS'] = '';
$backup['DB'] = 'forums';




My forums are located at http://www.realopinion.com/realboards/

[sketch42]

Noobed out hard. Can someone explain to me what I put here?

examples;

HOST = 'localhost' (default)
USER = 'root' (default)
PASS = ' ' (default)
DB = 'forums' (default)
-----------------------------------------------------------
*/

$backup['HOST'] = 'localhost';
$backup['USER'] = 'root';
$backup['PASS'] = '';
$backup['DB'] = 'forums';




My forums are located at http://www.realopinion.com/realboards/


$backup['HOST'] = 'localhost';// your ip address that your forums are on, most times 'localhost' is sufficient
$backup['USER'] = 'root';// put the username attached to the database your forums are on
$backup['PASS'] = '';//put the password that belongs to that username attached to your database that your forums are on
$backup['DB'] = 'forums';// name of the database your forums are on

[mikehawk]

$backup['HOST'] = 'localhost';// your ip address that your forums are on, most times 'localhost' is sufficient
$backup['USER'] = 'root';// put the username attached to the database your forums are on
$backup['PASS'] = '';//put the password that belongs to that username attached to your database that your forums are on
$backup['DB'] = 'forums';// name of the database your forums are on


Thankyou SOOOO much. :)

[bspiller82]

Any reason why it runs 15+ backups when it runs? Seems that when it does the backup it does it 15+ times in a row! The entry was put in exactly how your readme said.

3915 Daily BackUp 22:55, 26th Jul 2005 MySQL Backup was completed successfully with no errors.
3914 Daily BackUp 22:50, 26th Jul 2005 MySQL Backup was completed successfully with no errors.
3913 Daily BackUp 22:33, 26th Jul 2005 MySQL Backup was completed successfully with no errors.
3912 Daily BackUp 22:32, 26th Jul 2005 MySQL Backup was completed successfully with no errors.
3911 Daily BackUp 22:31, 26th Jul 2005 MySQL Backup was completed successfully with no errors.
3910 Daily BackUp 22:30, 26th Jul 2005 MySQL Backup was completed successfully with no errors.
3909 Daily BackUp 22:29, 26th Jul 2005 MySQL Backup was completed successfully with no errors.
3908 Daily BackUp 22:28, 26th Jul 2005 MySQL Backup was completed successfully with no errors.
3907 Daily BackUp 22:27, 26th Jul 2005 MySQL Backup was completed successfully with no errors.
3906 Daily BackUp 22:26, 26th Jul 2005 MySQL Backup was completed successfully with no errors.
3905 Daily BackUp 22:25, 26th Jul 2005 MySQL Backup was completed successfully with no errors.
3904 Daily BackUp 22:23, 26th Jul 2005 MySQL Backup was completed successfully with no errors.
3903 Daily BackUp 22:22, 26th Jul 2005 MySQL Backup was completed successfully with no errors.
3902 Daily BackUp 22:21, 26th Jul 2005 MySQL Backup was completed successfully with no errors.
3901 Daily BackUp 22:20, 26th Jul 2005 MySQL Backup was completed successfully with no errors.
3900 Daily BackUp 22:19, 26th Jul 2005 MySQL Backup was completed successfully with no errors.
3899 Daily BackUp 22:18, 26th Jul 2005 MySQL Backup was completed successfully with no errors.
3898 Daily BackUp 22:17, 26th Jul 2005 MySQL Backup was completed successfully with no errors.
3897 Daily BackUp 22:16, 26th Jul 2005 MySQL Backup was completed successfully with no errors.
3896 Daily BackUp 22:15, 26th Jul 2005 MySQL Backup was completed successfully with no errors.
3895 Daily BackUp 22:13, 26th Jul 2005 MySQL Backup was completed successfully with no errors.
3890 Daily BackUp 22:07, 26th Jul 2005 MySQL Backup was completed successfully with no errors.
3863 Daily BackUp 22:47, 25th Jul 2005 MySQL Backup was completed successfully with no errors.
3862 Daily BackUp 22:25, 25th Jul 2005 MySQL Backup was completed successfully with no errors.
3861 Daily BackUp 22:24, 25th Jul 2005 MySQL Backup was completed successfully with no errors.
3860 Daily BackUp 22:22, 25th Jul 2005 MySQL Backup was completed successfully with no errors.
3859 Daily BackUp 22:21, 25th Jul 2005 MySQL Backup was completed successfully with no errors.
3858 Daily BackUp 22:20, 25th Jul 2005 MySQL Backup was completed successfully with no errors.
3857 Daily BackUp 22:16, 25th Jul 2005 MySQL Backup was completed successfully with no errors.
3853 Daily BackUp 22:13, 25th Jul 2005 MySQL Backup was completed successfully with no errors.

[micheal332001]

Hi there

Gread addon to the vbulletin installed it like 2 mins ago
and all works just fine no problems.
Thanks for this great work

[Gutspiller]

The config file says:

" Delete Local Backup
-----------------------------------------------------------
Here decides whether or not you would like to delete the
local version of the backup after you have transfered it.
By default this will be 0, but if you still want to do it,
just select 1 and it will leave your local backup in place."

so does this mean that leaving it the default 0 will delete the local copy of the backup? Isn't 1 usually mean "on"?

[mcyates]

When it does backups it sometimes keeps the forum shut and i have to open it when i get up in the morning. Has this happened to anyone else?

[mcyates]

Is it possible to run this in slow time to stop the server from timing out. When i'm doing a back-up i get the error, "cannot find server" when trying to go onto my site. Is there a way around this?

[derekivey]

Nope works fine for me.

[loftyasianz]

my host just put us on a dedicated server and now i'm having some trouble with the cron backup. i'm using php version 4.4.0, mysql Client API version 4.1.11, and the errori'm getting is

"Backup

Failover was initiated for MySQLDump Binary & An error occured during the MySQL backup. Details (Could not open Destination SQL file for writing. (backups2/08_06_05.sql))"

i've already checked all of the backup host/username/password/dbname settings and my host has confirmed all of these settings also. does anyone know what the issue might be?

thanks advanced,
warren

[SamirDarji]

my host just put us on a dedicated server and now i'm having some trouble with the cron backup. i'm using php version 4.4.0, mysql Client API version 4.1.11, and the errori'm getting is

"Backup

Failover was initiated for MySQLDump Binary & An error occured during the MySQL backup. Details (Could not open Destination SQL file for writing. (backups2/08_06_05.sql))"

i've already checked all of the backup host/username/password/dbname settings and my host has confirmed all of these settings also. does anyone know what the issue might be?

thanks advanced,
warrenBe sure to have the proper permissions for the destination directory. It seems you don't have write permission in "backups2".

[MikeWalczak]

Hello,
I have used this system a few times before and I am getting this error:

Automatic Forum Backup

Failover was initiated for MySQLDump Binary & An error occured during the MySQL backup. Details (Could not open Destination SQL file for writing. (/backups/08_08_05.sql))

I have created a folder "backups" (public_html/backups/) on my remote server and chmodded it to 0777. I also have put a "backups" folder both in my /public_html/ main directory as well as in the forums directory. Both of which are chmodded to 0777.

Any idea why I am still getting this error?

Thanks,
Mike

[nymyth]

Love it, works like a charm

Peace

[SkyShadow]

Will your script be ported over to vB 3.5?

[derekivey]

It probably does work with vB 3.5.

[ricker]

It probably does work with vB 3.5.

Mine doesn't.

[derekivey]

Ok, ok, I wasn't sure because I didn't test it...

[WS|Scorpion]

Can i use it to backup everything from 3.07 to a totaly new database installed on a different server on a version 3.08 without facing any problems and everything is shifted from my 3.07 to my 3.08 ? "2 totally different servers, 2 totally different database"

[Bubble #5]

This is such a great hack and an important hack too. MANY THANKS TO Trigunflame for making it! Unfortunately we can?t use it now because we are using 3.5, but hopefully it will be ported over soon (shouldn?t be that hard to do). This is such an important hack that it makes you wonder why it?s not part of vB software. Thanks again for all of your hard work Trigunflame http://www.emotipad.com/newemoticons/Big-Thumbs-Up.gif


PS-if a restore function is ever included, please make it possible to section off large databases for when we restore. Thank you.

[jaybolt]

Run the cron task manually, or look at the cron logs and tell me.

Mysqldump shouldnt cause any errors remaking the db, as its automated through the binary, and I don't touch its output in the script.

Hi - I am getting hte following error:

Cronbackup


Fatal error: Call to undefined function: ini_get_all() in /home/httpd/vhosts/yorkshire-divers.co.uk/httpdocs/forums/includes/mysqlbackup.php on line 1794

Any help please?

Regards

Jay

[jaybolt]

Hi - I am getting hte following error:

Cronbackup


Fatal error: Call to undefined function: ini_get_all() in /home/httpd/vhosts/yorkshire-divers.co.uk/httpdocs/forums/includes/mysqlbackup.php on line 1794

Any help please?

Regards

Jay

Solved - different version of vB

Cheers anyhow

[Anonymous999]

Its listed as 3.07, will it work on 3.08 ?

[mcyates]

Is this going to be ported to 3.5?

[Yup]

Will this work for 3.0.8?

[derekivey]

Yes, it works in vB 3.0.8...

[Anonymous999]

Don't know if that would be prudent or not.. It is a possibility tho, I will add it to the To-Do List.

Has the email option been added yet ?

Didnt see it in the todo list

[Anonymous999]

Hello,
I have used this system a few times before and I am getting this error:


I have created a folder "backups" (public_html/backups/) on my remote server and chmodded it to 0777. I also have put a "backups" folder both in my /public_html/ main directory as well as in the forums directory. Both of which are chmodded to 0777.

Any idea why I am still getting this error?

Thanks,
Mike

Your path is wrong for mysqldump i would guess as i just had the same problem

Mine is

$backup['MYSQLDUMP'] = '/home/MY_USER_NAME/public_html/mysqldump';

You can get the path from your phpinfo i believe

[Anonymous999]

Seems to be working so far

One thing, my vB locks up (have lock db set to 1) but the

$backup['MESSAGE'] = "<p>Forum has automatically been shutdown
while database backup is in progress.</p>
<p>Forum will be restored momentarily.</p>";

Message doesnt display ?

Users just get a This page cannot be displayed standard IE error message ?

[Paul M]

Don't lock the DB - that will prevent it being used and is not really necessary.

[Anonymous999]

Ok but why dont i get the message text ?

Also i just run the backup

sql db >350mB

.tar.gz about 90 mb

It took over an hour to do the backup ?

Also i got this when i viewed the log

Failover was initiated for MySQLDump Binary, but dump completed successfully

Suggestions ?

[Paul M]

Thats an informational message - it means it tried to use the mysqldump command and failed, so it flipped to the secondary php method and backup successfully.

[Anonymous999]

Thats an informational message - it means it tried to use the mysqldump command and failed, so it flipped to the secondary php method and backup successfully.


Why did it do this ?

What should i be looking for ?

Thanks in advance

Dave

[Johannes de Le?n]

Nope, it won't work in 3.5.0 without a few minor changes.
Could you please name them?

That would be a great help. ;)

[ThorstenA]

I would be glad to see a 3.5 version out there :D

[egyptsons]

great
:)
I will try

[T3MEDIA]

read tru a lot... is there anything stating how this works under 3.0.3?
Thank you

[Paul M]

It should work fine in 3.0.3

[a squared]

I saw a post where it works in v 3.0.8 But, will it work in v 3.0.9 I would think that it would. Thought I would ask to make sure. Thanks.

[TRStealth]

Can we expect a 3.5 version of this hack?

[Rich]

Hello,

I too just came to this thread to see if there was any info on a 3.5 release. lol

[derekivey]

Don't think there is a vB3.5 release :(

[mikexxx]

Please update to 3.5 ;)

[blueuniverse]

This is causing huge problems when it backs up my 40mb (gzipped - 250mb non) database. It causes the whole vps to lock-up and the server needs restarting.

Any ideas about this?

[derekivey]

If you are using vB 3.5.0, just use the included shell script and add it to the cron. I just found out about that yesterday and it works nicely :)

[Feckie (Roger)]

If you are using vB 3.5.0, just use the included shell script and add it to the cron. I just found out about that yesterday and it works nicely :)

Can you explain...........Please

[ricker]

If you are using vB 3.5.0, just use the included shell script and add it to the cron. I just found out about that yesterday and it works nicely :)

Hey, where is the script supposed to be uploaded to? I can't find any info or instructions on it ... does it need to be outside the main site? permissions set a certain way?

[derekivey]

Hey, where is the script supposed to be uploaded to? I can't find any info or instructions on it ... does it need to be outside the main site? permissions set a certain way?

I just uploaded mine to my home directory. You need to open it in like wordpad or something and edit the path to your vBulletin config file.

[rezovor]

I just uploaded mine to my home directory. You need to open it in like wordpad or something and edit the path to your vBulletin config file.

Im also dying to get this working on my forum.

Where is this "included shell script" located? As others were asking.

[derekivey]

It's in vB's do_not_upload folder.

[PtP]

The backup it creates is not of much use if the server go down or breaks, The whole great part of "VBulletin Database Backup Pro" was I have mine being ftp'd off to a remote site nightly as well as storing locally so no matter what happened My database was safe, at the moment I am having to do it manually but we all know slackness takes over and it doenst get done and that of course if when you have a failure. :(

[Drago912]

Thanks for this works great.....I ran the task and get this message, "failover initiated, but backup was done successfully"

I check the directory of the backup and its there........any ideas as to why I get this message?

[silurius]

I'd really like to see some attention on a full port over to 3.5G. This is one of the most important add-ons I can think of.

[Todi]

I also would like to see a full port to 3.5G. Definately one of the best Mods.

[Ncturnal]

I also would like to see a full port to 3.5G. Definately one of the best Mods.

Agree

[Paul M]

Thanks for this works great.....I ran the task and get this message, "failover initiated, but backup was done successfully"

I check the directory of the backup and its there........any ideas as to why I get this message?Because you have specified in the config to use mysqldump if possible, but the system was unable to do this and failed over to using the php method - which worked ok. It's an information message and nothing to worry about.

[jdingman]

I also would like to see a full port to 3.5G. Definately one of the best Mods.

I would like this too. Any date set for this port?

[derekivey]

Judging by the date of the authors last visit, I don't see it happening because he last visited on Sep 2005.

[Drago912]

Because you have specified in the config to use mysqldump if possible, but the system was unable to do this and failed over to using the php method - which worked ok. It's an information message and nothing to worry about.


cool....thanks for the reply.

[FROGGYJ]

If you are using vB 3.5.0, just use the included shell script and add it to the cron. I just found out about that yesterday and it works nicely :)

I'd like to use this for VB 3.5....can you provide some more detailed instructions?

[FROGGYJ]

ok so I followed the install instructions and edited the mysqlbackupconfig.php then I also uploaded vb_backup.sh (from Vbulleting do_not_upload) to the forum root directory and edited it to point to my config.php file. However everytime I try and run the task I get

Fatal error: Call to a member function on a non-object in /home2/edmonton/public_html/forumvb/global.php on line 243

[derekivey]

ok so I followed the install instructions and edited the mysqlbackupconfig.php then I also uploaded vb_backup.sh (from Vbulleting do_not_upload) to the forum root directory and edited it to point to my config.php file. However everytime I try and run the task I get

Fatal error: Call to a member function on a non-object in /home2/edmonton/public_html/forumvb/global.php on line 243

You don't use the mysqlbackupconfig.php file for the vBulletin shell file. You just upload that file and edit that file.

[FROGGYJ]

derek can you just go over my list here and point out the wrong step cause I'm not getting what you mean.

1. upload mysqlbackupconfig.php, mysqlbackup.php, ftp.lib.php, pclzip.lib.php in the forums 'includes' folder.

2. upload cronbackup.php in your 'includes/cron' folder.

3. edit mysqlbackupconfig.php with appropriate settings

4. make sure backup directory is chmod to 777

5. because I am using vb 3.5, use shell script file (vb_backup.sh) which is included with the VBulletin download in the do_not_upload folder. I edited this file to point to my ./includes/config.php file and then I uploaded this file to my forum root directory.

6. create a scheduled task to run daily and point to ./includes/cron/cronbackup.php

Now where exactly am I going wrong? Thanks for your help.

[derekivey]

No, Just upload vb_backup.sh. This hack doesn't work with 3.5. I just setup a cron job in cPanel to run vb_backup.sh once a day...

[FROGGYJ]

oh lol.

[Hornstar]

He also said he was going to make a restore hack, but I dont see that finished, so It will be a while b4 this gets to 3.5 i think...but i would love this to be 3.5 and also a really good restore hack that can be done from the admincp

[derekivey]

I wonder where he went lol. He hasn't been on for a few months :(

[Gunshot]

perhaps one or more of you advanced coders could take this hack over and complete the restore feature

just a thought cuz this work is nice

[Paul M]

I also would like to see a full port to 3.5G. Definately one of the best Mods.Well I got fed up of waiting so I modified it [locally] to work on 3.5, and added an extra feature I wanted as well (backup all tables except those in a given list). Unfortunately, since it's still over 95% Trigunflames code, it's not possible for me to make it available.

However, I have attempted to contact the Author to see what plans he has for this, and if that's none, to see if he will give permission for me to make my 3.5 version available. If he plans to convert it himself then all well and good, but, if he does not reply, or does not give permission, then I guess there's not much I can do.

[Bubble #5]

I have attempted to contact the Author to see what plans he has for this, and if that's none, to see if he will give permission for me to make my 3.5 version available. If he plans to convert it himself then all well and good, but, if he does not reply, or does not give permission, then I guess there's not much I can do.
Let's hope that he understands and everything works out for the best :nervous:

[outlaw621]

Well I got fed up of waiting so I modified it [locally] to work on 3.5, and added an extra feature I wanted as well (backup all tables except those in a given list). Unfortunately, since it's still over 95% Trigunflames code, it's not possible for me to make it available.

However, I have attempted to contact the Author to see what plans he has for this, and if that's none, to see if he will give permission for me to make my 3.5 version available. If he plans to convert it himself then all well and good, but, if he does not reply, or does not give permission, then I guess there's not much I can do.

I guess you are still waiting for a response. I hope the response is a good one. This hack proved invaluable in the past and in my opinion is a must for any board.

[outlaw621]

I guess this may not end up getting ported to 3.5.x. What a shame as it is a great hack and it shoud be a standard part of VB.

[Paul M]

I guess you are still waiting for a response. I hope the response is a good one. No response at all.

[Robert Basil]

No response at all.

I wish I could say that I was surprised. It seems as though Trigunflame has dropped off the face of the earth. :(

This hack was (IMHO) was one of the best hacks ever created for VB and I sure do miss it since I have upgraded all of my sites (and my clients sites) to VB 3.5.1

[Zoints]

My company, Zoints Inc., has purchased the rights to this hack from TriGunFlame. We will be porting it to vBulletin 3.5.x, providing it for free, and work to make it a more robust solution over time. Unfortunately, I don't have an ETA for release yet.

[alraqee]

No response at all.

we are still waiting for 3.5.1 ...

please find a channel ... or start your own ..

[Robert Basil]

DChapman']My company, Zoints Inc., has purchased the rights to this hack from TriGunFlame. We will be porting it to vBulletin 3.5.x, providing it for free, and work to make it a more robust solution over time. Unfortunately, I don't have an ETA for release yet.

Please let us know as soon as you have a Beta as we really need this hack upgraded for 3.5.x

[Paul M]

I'm sure that now Zoints have taken it over, a version will soon be available. :)

[Todi]

Save us Zoints, you're our only hope!

(sorry, couldn't help myself)

[Robert Basil]

Save us Zoints, you're our only hope!

(sorry, couldn't help myself)

ROFLMAO! I just spit coffee all over my keyboard! :laugh:

[ADM]

Zoints: If you could implement a restore database from FTP option in the future 3.5 mod that would be great :)

[cclaerhout]

Zoints: If you could implement a restore database from FTP option in the future 3.5 mod that would be great :)

Any surprise for christmas ? :D

[Paul M]

Any surprise for christmas ? :DUnlikely.

He asked for a copy of the version I was using for 3.5 to look at, not heard a peep from him since .......

[cclaerhout]

Unlikely.

He asked for a copy of the version I was using for 3.5 to look at, not heard a peep from him since .......

Gloups :c

[Zoints]

Hi folks,

Paul M did a good job porting the hack to vBulletin 3.5.x (kudos to him for his coding prowess) but there are still issues that need to be resolved. Our hope is to have a fully functional and robust release for everyone around mid January along with quite a few other cool hacks. I sincerely apologize for the delay, we just can't release anything for public consumption that has issues like the current version.

[Paul M]

:up:

[cclaerhout]

DChapman']Hi folks,

Paul M did a good job porting the hack to vBulletin 3.5.x (kudos to him for his coding prowess) but there are still issues that need to be resolved. Our hope is to have a fully functional and robust release for everyone around mid January along with quite a few other cool hacks. I sincerely apologize for the delay, we just can't release anything for public consumption that has issues like the current version.


Thanks for your answer :)

[rsj1]

Zoints: If you could implement a restore database from FTP option in the future 3.5 mod that would be great :)

Inserting a database is easy... use Bigdump (available free http://www.ozerov.de/bigdump.php ) I have personally used this tiny script to insert 500mb+ databases with no problems so I see no reason it shouldn't work on much bigger ones ;) I keep a copy of it in my database backup directory :P (outside of the server root of course lol)

[FOZ13]

looking forward to the robusr release

[skokarl]

Hallo,

I have vBulletin 3.07 and mysqldumper 1.21.

After a backup I become a message :

Failover was initiated for MySQLDump Binary, but dump completed successfully

What this means ? Thanks

[Mosh]

Hallo,

I have vBulletin 3.07 and mysqldumper 1.21.

After a backup I become a message :

Failover was initiated for MySQLDump Binary, but dump completed successfully

What this means ? Thanks
It just means that you dont have access to the mysqldump binary via shell commands.

In this case, it is failing over into a manual PHP dump mode. As long as it is saving your dumps correctly, which they are by the looks of it, all is OK.

[IrPr]

Keep on workin Paul M and Zoints ;)

[Zoints]

*sigh*

I apologize folks, our update still isn't ready. I don't have an specific ETA, just a promise that it WILL be released.

Sorry :(

[alfaowner]

I am getting this in install:
Back Up Run

Failover was initiated for MySQLDump Binary & An error occured during the MySQL backup. Details (Could not open Destination SQL file for writing. (forumbackups/01_22_06.sql))


Whats up, ive tried all sorts of folders and also made them chmod to 777

any help appreciated

[alfaowner]

all sorted, went away and came back an the error was obvious.... just goes to show...

[Trigunflame]

Sorry about all the problems people; I have been away for nearly 6 months in college and working part time.

I am going to start working on the remake of this script for vb3 and 3.5 that should address almost all of the problem inherent to this version including timeouts on Very Large Databases as well as plenty of new features such as SFTP and other protocol supports.

Sorry for all the time I havnt been able to keep this updated, but unfortunately other priorities had taken over my time.

[derekivey]

Good to hear! :)

[Paul M]

I am going to start working on the remake of this script for vb3 and 3.5 that should address almost all of the problem inherent to this version including timeouts on Very Large Databases as well as plenty of new features such as SFTP and other protocol supports.I'm just a little confused. How does your post fit in with this ?

DChapman']My company, Zoints Inc., has purchased the rights to this hack from TriGunFlame. We will be porting it to vBulletin 3.5.x, providing it for free, and work to make it a more robust solution over time. Unfortunately, I don't have an ETA for release yet.

[Trigunflame]

I'm just a little confused. How does your post fit in with this ?

Because he owns right to that version.

The new version is made from scratch using none of the pre-existing codebase; of which Zoints has no copyright of; also it goes under a new Project name Vbulletin Backup Pro as it will do more than simply backup Databases, it will be an entire Forum/Site archiving tool.

[Milesian]

Any more news on the 3.5 port?

[Lea Verou]

Any more news on the 3.5 port?

In 5 days??? Geez, that's a big project there is no way it will be accomplished in 5, 10 or 15 days!

[Trigunflame]

In 5 days??? Geez, that's a big project there is no way it will be accomplished in 5, 10 or 15 days!

Ya, progress IS being made. If you looked in the 3.5 section Ive already created 1 new Hack (Plugin Accelerator) and ported 2 others; so this hack is in the queue to be "remade" and ported to 3.5 (and it will be backwards compatible with vb 3.0.x)

[Lea Verou]

Ya, progress IS being made. If you looked in the 3.5 section Ive already created 1 new Hack (Plugin Accelerator) and ported 2 others; so this hack is in the queue to be "remade" and ported to 3.5 (and it will be backwards compatible with vb 3.0.x)

Are you talking to me? I wasn't the one who asked about progress :confused:

[Trigunflame]

Are you talking to me? I wasn't the one who asked about progress :confused:

You were commenting on how long it would take, i was simply being informative.

[alfaowner]

Because he owns right to that version.

The new version is made from scratch using none of the pre-existing codebase; of which Zoints has no copyright of; also it goes under a new Project name Vbulletin Backup Pro as it will do more than simply backup Databases, it will be an entire Forum/Site archiving tool.

Cant wait to see it

[Milesian]

Ya, progress IS being made. If you looked in the 3.5 section Ive already created 1 new Hack (Plugin Accelerator) and ported 2 others; so this hack is in the queue to be "remade" and ported to 3.5 (and it will be backwards compatible with vb 3.0.x)
That's good news, thanks. I'm looking forward to this one :)

[dano]

Me too, I cant wait I really really need this!

[dazzlin]

I'm thrilled to see this is being worked on for 3.5. I can't wait. This is desperately needed.

[dano]

I'm thrilled to see this is being worked on for 3.5. I can't wait. This is desperately needed.

Totally agree!

[dazzlin]

Either Dchapman or Trigunflame:

Any progress on this from either of you? This is so desperately needed, that I'm sure everyone would be thrilled if either version came out.

[Ruler68jg]

OK ! just a quick question is this only to backup the database or both the database and structure too ? I mean once created a backup and in case of new server everything will be back sturcturevise with users topics subtopics and all the contents.

kind regards
ruler

[dano]

Either Dchapman or Trigunflame:

Any progress on this from either of you? This is so desperately needed, that I'm sure everyone would be thrilled if either version came out.

I agree. I know its a hard one you its going to take a while, its such a great hack and it is hard to wait. Let us know if you guys are getting near it. Thanks so much!

[Trigunflame]

Sorry guys, if you monitor vbulletin 3.5 hacks you would know ive been working on several projects simulataneously recently.. around 6 at the moment.

But dont fret this IS on my todo list.

[alfaowner]

Sorry guys, if you monitor vbulletin 3.5 hacks you would know ive been working on several projects simulataneously recently.. around 6 at the moment.

But dont fret this IS on my todo list.

Your a good man :)

[Trigunflame]

Vote Vbulletin World Map System OR Plugin Accelerator for HOTM (https://vborg.vbsupport.ru/showthread.php?p=926146)

[Allan]

Very nice your hack :), but when adaptation for vB3.5 ?

[SpyCam]

Hi, i run 3.0.13 and installed this hack today, unfortunately, when i hit "run now" button in scheduled tasks manager page, i get this message:

Could not fetch database options. Shutting backup down.

Any clue why is that?

[SpyCam]

anybody?

[Paul M]

It failed to read your database - have you actually set the correct database/user/password in the hacks config file ?

[SpyCam]

I surely did that, i just doublechecked that and it seems to be correct

[Paul M]

Well the fact remains that it is unable to read your database (the datastore table), so I suggest you check the values you have put against your vb config file.

[SpyCam]

I checked them once again, they are identical on both, vb config.php file and mysqlbackupconfig.php

[Paul M]

Then I cannot help you.

The problem is that it is trying to read the options from your datastore table and failing, so it gives up.

[SpyCam]

ok, i'll need to uninstall it.
thanks for help

[Trigunflame]

ok, i'll need to uninstall it.
thanks for help

This is a weird problem that happened very rarely, im pretty sure it has to do with the way it was reading the database.

The new version should fix a lot of these issues, I am working on it.. slowly but surely.

[Todi]

And we are patiently waiting for you to finish =)

[dano]

And we are patiently waiting for you to finish =)
Yep Yep

[dano]

^^^^^^

[camoman]

I am having an issue with my backups.. I get the following message:

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

I know that this means that it failed over to the php backup but my problem is it's not comining the tables to one sql file or compressing it? I have the settings configured to do this but I have had no luck?!?!

[dano]

Any news on the version for 3.5?

[dano]

Anything? I am willing to pay if need be

[Paul M]

Any news on the version for 3.5?As listed in the add-ons section in the main post.

https://vborg.vbsupport.ru/showthread.php?t=112304

Anything? I am willing to pay if need be
Feel free to donate ;)

[mxa055]

I tried running the script from the vbulletin cron manager manually and it just went into an endless loop. I had to delete the script files to stop it from generating the same files again and again. Now I have a few files in the backups\"date" directory that I cannot remove (eg .pureftpd-rename.15338.f2d9f751)

[desimasalaforum]

i am getting this error

Fatal error: Call to a member function on a non-object in /home/content/*********/html/board/global.php on line 235

any help ?

[rainyleaves]

I tried running the script from the vbulletin cron manager manually and it just went into an endless loop. I had to delete the script files to stop it from generating the same files again and again. Now I have a few files in the backups\"date" directory that I cannot remove (eg .pureftpd-rename.15338.f2d9f751)

You just change 'type' to 1 or 0.
You can fix it!

$backup['TYPE'] = 0;
$backup['TABLES'] = array();
$backup['COMBINE'] = 1;

[MrEyes]

Holy mod resurrection batman!!!

Is anybody using this with 3.6.8pl2 and has anybody tried it with 3.7?

Also this obviously performs a DB backup does anybody know of any tools that will perform scheduled backups of the server files? (i.e. everything in public_html). This would be very useful for those of use that are using the filesystem for storing attachments/avatars etc

[2guys1forum]

Nvm... old mod :\