As far as I can tell our cPanel password was discovered...not that I know how, trust me when I say it was long. In any event our entire FTP was erased, as were all our mySQL Databases.

I was beating myself up over this for days, the backup works fine when it's run by the schuduler, but when I manual do it, the forum wouldn't turn back on. It because the timeout for your web server to too low. I set mine to 300 and it worked on command.

My safemode is on. Is this a big deal?

It would be safer to turn it off.

Is that a play on words? Seriously, what does it do?

Read these:

http://uk.php.net/features.safe-mode
http://www.webhostgear.com/166.html

I run this through the cron section of the admin panel, it says everything worked fine, but no file is created in the specified directory. Does anyone know why this is.

Is your specified directory CHmoded to 777???

Yes it is. :surprised:

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).

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

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.

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.

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.

Great

Thanx

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

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.

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: [high]* Christine installs with thanks!![/high]

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?

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. :)

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...

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.

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

:(

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

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

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"

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.

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.

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).

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?

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.

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..

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

great! the exec() worked somehow :)

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

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

Could not fetch database options. Shutting backup down.

Help please?