Welcome to Geeklog Friday, August 23 2019 @ 03:41 am EDT

Geeklog Forums

Need Assistance with DB Backups


Status: offline

etegration

Forum User
Full Member
Registered: 20/02/02
Posts: 179
i get a Warning: OpenDir: No such file or directory (errno 2) in database.php on line 73 line 73 of database.php reads $backups = array(); Why is there an error? GL runs perfectly ok on my site, just this backup utility doesn't seem t obe working...
http://www.etegration.com.sg http://www.itcow.com http://www.ministryofhosting.com

Status: offline

Dirk

Site Admin
Admin
Registered: 12/01/02
Posts: 13073
Location:Stuttgart, Germany
You're off by one line, line 73 reads $fd = opendir($_CONF['backup_path']); So the backup directory you have configured there either does not exist or you don't have the proper access rights to it. bye, Dirk

Anonymous

Anonymous
what's the default backup path???

Status: offline

etegration

Forum User
Full Member
Registered: 20/02/02
Posts: 179
sorry but i think i found it on config.php and it reads $_CONF['backup_path'] = $_CONF['path'] . 'backups/'; Thanks. i'll try it, it should work. Thanks again
http://www.etegration.com.sg http://www.itcow.com http://www.ministryofhosting.com

Status: offline

lcox

Forum User
Junior
Registered: 12/07/02
Posts: 31
I got an identical error which I corrected by creating the backups directory as the conf specified spot. So, now the error is no longer happening and the claim is that the backup occurred successfully, but there's never anything in the backups directory nor is there ever anything listed in the last 10 backups list. So, on one hand it claims success, but something is still not acting right...now no error at all so don't have the clue I need to figure out the next step. Anyone else seen this?

Status: offline

efarmboy

Forum User
Full Member
Registered: 26/02/02
Posts: 147
Check your path to the backup program - line 64 in config.php. $_DB_mysqldump_path = '/usr/local/bin/mysqldump'; There will be additional checks placed in the code in the next release. Currently it does not complain if the path is wrong. I suggest everyone check the backup workds and a file > 40K is created.

Status: offline

lcox

Forum User
Junior
Registered: 12/07/02
Posts: 31
Thanks for the info. Unfortunately, that wasn't the problem as it turns out. My mysqldump path was correct. I had ug+rwx privledges on the backups directory. Apparently, it also needed 'other' as well. When I just said a+rwx, then backups began working. Was a little concerned about having to do that, but that's what I needed in my case. This is running on a web host, shared web server, so I have limited options in setting stuff up. If you have any better suggestion other than to give world access to my backup directory, I'd appreciate hearing it. Thanks, again. Landon

xsquared

Anonymous
Is there any way you could change the backup dir's group ID to be that of the web server so that only the web server program can read from and write to the backups directory? If you can, then you wouldn't need it to be world-readable/writeable to allow for backups of your database.

Status: offline

epretorious

Forum User
Junior
Registered: 02/07/02
Posts: 26
Has there been any resolution for this complaint? I'm not able to perform backups (though GL heralds that the backup was successfully).

  • I've verified $_DB_mysqldump_path is correct.
  • I've verified $_CONF['backup_path'] is correct and is readable/writable by all.
...but database.php still does not successfully perform backups.

Could this be a MySQL permissions problem?
Eric P. Sunnyvale, CA

Status: offline

epretorious

Forum User
Junior
Registered: 02/07/02
Posts: 26
The culprit seems to be the configuration of PHP's safe mode. (I haven't figured-out how to configure safe mode to allow only mysqldump but I'm working on it...)
Eric P. Sunnyvale, CA

All times are EDT. The time is now 03:41 am.

  • Normal Topic
  • Sticky Topic
  • Locked Topic
  • New Post
  • Sticky Topic W/ New Post
  • Locked Topic W/ New Post
  •  View Anonymous Posts
  •  Able to post
  •  Filtered HTML Allowed
  •  Censored Content