Everything installed well and I copied the same settings as my other forums that this mod works on, but this is the second day that it has not generated a backup.

Edited: Whoops..just noticed that my 'backups' folder was not CHMOD777. So, I just did that and will wait for the file to generate tonight and check it tomorrow morning.

same problem still.

My last backup was on nov 9, that one happened automatically, but it has not made another backup since that day.

No idea, Maybe you broke your cron system ?

The running of crons is core vb functionality, not something specific to this mod.

I'm using version 2.12, should I upgrade? Seems to be backing up fine.

my vbulletin has only 3 mods installed currently, and this is the only one that uses the cron system. so its has no changes or mods made to it at all.

There is no reason to upgrade if 2.12 is working fine for you.

Not sure if this has been asked yet, but will this mod work with large databases that cannot be downloaded via cpanel?

What do you mean by "large" ?

Databases that are 600mb+....Everytime I need a backup, the host has to do it on their end since neither VB or phpmyadmin will allow the download without timing out.

If it is too big for this add-on, you could try MySQLDumper

My database is bigger than 600M, works fine for me.

So this will backup the forum mysql or the whole forum including the directory ?
second question, i have added many arcade games, is there anyway i can have the games
move outside the forum ? my back from 300MB is now like 500 due to all the games i added.
same like the attachments or the avatars ? to save space on the backup ?

Is there any way to gzip a backup file? The file is too big - 110 MB. And I didn't include two big tables: word and postindex.

This will only back up the database, not the files.

Attachments and avatars etc will only be saved if they are set to be stored in your database, if they are stored as files you will need to perform a file backup to backup these files.

Distance

This works 100 %....thx...

Only problem with danish forums is our speciel letters = æ ø å

When restoring database...all speciel letters are gone....replaced with a ?

Should there be a workaround, so i can keep my speciel letters...like æ ø å

One more thing. Will this work with vB version 3.8

I've been using this mod for awhile, but had the first chance to restore the DB, and wanted to post up that it really was a pretty easy process. I have this mod configured to put the whole backup into a single text file. On my host, all that is necessary to restore the database is to put the backup file into the correct directory (_db_backups). You can get it there by FTP'ing it into there if you have it on your own computer, or you can move it over there from the host itself. The file can be named anything, but it has to end with ".sql". Then you just go into Hosting Manager, click on Databases, and hit the pencil icon on the right to edit/restore the database. It will pop up a menu that lists the .sql files in that directory, and one more click and it starts the restore. Thanks again Paul, for this incredibly useful mod.

I'm having trouble with the 30 second time-out. Moved to a new host awhile back with a small database, and all worked fine. Moved another site there with a larger database, and now the backups aren't completing. The script stops right at the 30 second point, with only 40MB or so in the dump file (of the 100 - 110 MB that should be in there).

PHP is not running in safe mode, other possibly relevant PHP settings are below:

max_input_time = 120
post_max_size = 128M
file_uploads = On
max_execution_time = 600
memory_limit = 256M
file_uploads = On
upload_max_filesize = 128M
mysql.connect_timeout = 120

All of those are set in a php.ini file, and correctly show as such in the PHP status from the admincp. Any suggestions on why the script is still stopping at the 30 second mark?

Thanks for any help anyone can provide.

I know you have answered this a million times, but I just can't seem to specify
the destination folder correctly.

On my Server, my Folder structure is:
anon_ftp
bin
cgi-bin
conf
error_docs
httpdocs
httpsdocs
pd
private
statistics
subdomains
web_users

I have added a folder under the anon_ftp folder and called it dbbackup
I have changed the attributes to 777 for this folder, AND for the anon_ftp parent folder.

All my vBulletin files/folders are stored directly under the httpdocs folder.

In my mysqlbackupconfig.php file, I am specifying the backup directory as

$backup['DUMP_PATH'] = '../../anon_ftp/dbbackup/';

I have tried it with 1 set of double dots, 2 sets, 3 sets, 4 sets, and no sets.....

When I run it, in ALL cases I get the infamous Error message........
"An error occured during the Backup : Could not open Destination SQL file for writing."

What in hell am I doing wrong ?????

THANK YOU! THANK YOU! THANK YOU!

This has saved me from the dreaded "phrase" file has crashed.

You probably have open_basedir restrictions in effect - this is common on plesk based servers.

Just wanted to know is this work with vbulletin 3.8 RC2 ?

Thank you Paul.

But... I am successfully able to use the vBulletin database backup to a file on the server...
the file pathname is "./dbbackup/filename", and this works.

Obviously it is being stored in a folder under the httpdocs folder, called dbbackup.

So this does work, and we have made no changes to the server configuration.

Does this make sense ?

Yes - all the (valid) options you tried were for folders outside of httpdocs - which is restricted by open_basdir on plesk servers.

Storing backups inside the httpdocs folder is a very bad idea as anyone can access them.

is this compatible with the new 3.8?

There is a 3.8 version.

Thanks!! Ssaw that and uploaded it!! Great Mod! :)

Thank you Paul M. Installed

Paul,

If this is installed and running perfectly in 3.7.4, would you expect any issues when upgrading to 3.8? I realize you have a 3.8 version but I hate to go through the upgrade/config hassles if this version should suffice.

Any ideas?

Thanks,

Tom

very nice.......

I believe it should work fine after you upgrade.

I installed this... For some reason, I can't get the directory right. I have no idea about relative directories... I stuck a folder named "Backups" in the Includes folder, CHMODded it to 777, and then pointed it to any number of locations... ../backups/, /public_html/forums/includes/backups/, ... Not sure what to do at this point...

Well, to start with you want your backup folder ABOVE the html root. The location you have it at now - "/public_html/forums/includes/backups/" - anyone could access that folder and download your database. And then guess what, all of your data no belongs to someone else.

The backup folder should be somewhere like - account_name/backups/public_html/forums

Get the path fixed before you get the script running.

Hi Paul,

I have been using this great script for a while now. I recently added a function in the cron to delete all backups that are 3 days or older when it performs a backup, because I had to constantly manually delete old files.

I placed it right after

echo $mysqlBackup->STATUS;

What I'd like to know is how to determine a successful status from the script. In case of failure I don't want to run the delete. Something like
if($status == 'success')
{
// my stuff here
}

Thanks

It should contain 'The Backup was completed successfully.'

You can change that (about line 27) in the mysqlbackup.php file if you wish.

I just can't get the directory right... I set up a folder in the server's root directory, and tried setting the dump path to just /(foldername)/. Then I tried (server username)/(foldername)/... How can I set this right? :(

Use a relative path, like ../../foldername

And what would the relative path be when the folder is in the server root? I honestly don't know how to use relative paths.

No idea, that depends on your server setup. Google is your friend, lookup reletive paths.

hi Paul is there away so i can make this run twice a day like say 10am and 10pm