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.

I think this is the same for all.

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.

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.

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

No go for me doing this.

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

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

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.

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.

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

It's 6am here (uk) - I work nights. :)

Too late - it makes my reply look a bit odd now tho .......... :)

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.

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 !

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

When you set 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.

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

Nope, it won't work in 3.5.0 without a few minor changes.

CAN ANYONE HELP ME???

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

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

any news on version 2?

The author has not been seen since June 17th ......

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

it should be in your httpd.conf

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.

Sorry, but your words suggested you were "fine" - hence my post.
More bad news for you as well - if you check the new feature at the top, you will see ;
So I don't think you will get an answer anytime soon. :(

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

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

Thankyou SOOOO much. :)

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.

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

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"?

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?

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?

Nope works fine for me.

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

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

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