The Official vBulletin Modifications Site.

steadicamop · #46 22 Sep 2006, 18:17

Originally Posted by dimeola

i have some problem. it works very good but when it tries to take post table`s backup, it stops. i changed timeout period but nothing changed. it doesn`t continue. so it doesn't take backups of tables after post table.

last taken table is Live-2006-09-21-post.sql

I have the same issue.....

**Paul M** · #47 23 Sep 2006, 04:47

There is nothing I can really tell you. Our post table is fractionally under 500MB and it backs up in just over 4 minutes. I can't see any reason you could not backup much larger tables. I can think your problem is server related, maybe your host can help you.

Edit: Are you running in safe mode, or on windows (IIS), they both can affect the timeout.

Also, manually run the backup from the cron manager and see if you get a timeout error.

dimeola · #48 23 Sep 2006, 08:06

safe_mode Off Off

and my hosting plan is linux. i started backup from cron manager, but i don`t get any message

steadicamop · #49 23 Sep 2006, 08:21

Ditto same, no safe and linux - the only one thing I could suspect is the hosting - they may have set a short execution time for PHP (?)

The manual backup also causes the same issue - it's something other than the software, but damn frustrating.

Cheers,

Jason

realgoldtalk · #50 23 Sep 2006, 08:30

Hi Paul M,
Thanks for the modification How can i run it manually to test it?
Thanks and Regards,
Saad

**Paul M** · #51 23 Sep 2006, 08:32

Go to your Scheduled Task Manager in the ACP and run the cron job.

realgoldtalk · #52 23 Sep 2006, 08:38

Hi,
It is giving me this error
Database Backup
An error occured during the MySQL backup. Details (Could not open Destination SQL file for writing.)
Saad

dimeola · #53 23 Sep 2006, 09:00

you must give full path for backup folder in mysqlbackupconfig.php.
like this /home/user/public_html/forum/databasebackup. after you give a permission mode 777 to this folder. After you can take backup.

realgoldtalk · #54 23 Sep 2006, 09:32

I did that

Saad

**Paul M** · #55 23 Sep 2006, 09:42

Well you haven't got it right - that is a simple permissions error, your web server does not have write permissions to the folder you have pointed the backups at.

dimeola · #56 23 Sep 2006, 11:34

Originally Posted by dimeola

safe_mode Off Off

and my hosting plan is linux. i started backup from cron manager, but i don`t get any message

Paul any different idea?

Catsgot9 · #57 23 Sep 2006, 15:49

An error occured during the MySQL backup. Details (Could not open Destination SQL file for writing.)

any idea why I am getting this?

**Paul M** · #58 23 Sep 2006, 19:27

Originally Posted by Catsgot9

An error occured during the MySQL backup. Details (Could not open Destination SQL file for writing.)

any idea why I am getting this?

Folder Permissions - Look back a few posts (to post #55).

Originally Posted by dimeola

Paul any different idea?

Not really, it works fine if the server allows it to run. About the only thing I can change is to reset the timeout at the start of each table - but tbh, that's unlikely to make any difference as it seems as though your host has somehow set php to ignore the directive.

Catsgot9 · #59 23 Sep 2006, 21:59

[quote=Paul M]Folder Permissions - Look back a few posts (to post #55).

I chmodded my folder

/httpsdocs/backup (no trailing backslash) to CHMOD 777

Any other ideas?

**Paul M** · #60 23 Sep 2006, 22:15

Nope, it's a permissions error, only you (or your host) can fix them.

New To Site?	Need Help?
About vBulletin.org You will need to register to Participate Review Our Site Rules What is Board Of The Month (BOTM)? What is Modification Of The Month (MOTM)?	Mark Forums Read Do Your Research Before Hiring! Site Map Meet Our Staff

The Official vBulletin Modifications Site.

vB Database Backup Pro (Lite) for vb 3.6