Webmastersite.net
Register Log In

Backup Database no error but backup.sql

Comments on Backup Database no error but backup.sql

frankbeckers
Forum Regular

Usergroup: Customer
Joined: Dec 20, 2007
Location: Germany

Total Topics: 33
Total Comments: 106
Posted Aug 30, 2009 - 3:30 PM:

Hi Paul,

Backup Database writes "The backup file has been generated." but backup.sql has a size of 0KB (empty) and a timestamp from now.

Thanx,
Frank
Paul
developer

Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California

Total Topics: 61
Total Comments: 7868
Paul
0 of 1 people found this comment helpful
Posted Sep 01, 2009 - 3:55 AM:

Not reproducible, backups write fine here.
frankbeckers
Forum Regular

Usergroup: Customer
Joined: Dec 20, 2007
Location: Germany

Total Topics: 33
Total Comments: 106
Posted Sep 11, 2009 - 5:09 PM:

Do you have any tips for me for tracing or debugging this sitution. Changing the "Debug Level" don't help me an further.
Paul
developer

Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California

Total Topics: 61
Total Comments: 7868
Paul
Posted Sep 11, 2009 - 9:59 PM:

If your host's security settings prevent doing backups, I added a notice to explain that a couple betas ago.

If you're in apache mode without suPHP, it could be an admin directory permissions issue.

Maybe it's possible for mysqldump to not be on the server, or to not be accessible without some sort of absolute path, but I doubt it.

Otherwise, as always, site inspection service is the easy way to tell.
frankbeckers
Forum Regular

Usergroup: Customer
Joined: Dec 20, 2007
Location: Germany

Total Topics: 33
Total Comments: 106
Posted May 06, 2010 - 2:05 PM:

DB backup ist still not working in 5.1.33 Beta 7, so the db overwritten problems mentioned in another thread arem hardly to handle. Is there any chance to analyse this issue again?
Paul
developer

Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California

Total Topics: 61
Total Comments: 7868
Paul
Posted May 07, 2010 - 6:20 PM:

The only way I can tell you what's going on is if you let me have a look at it: http://www.wsnlinks.com/inspection.html

It's not a generic issue, it's specific to your server configuration.

It is a *nix host and not in safe_mode?
Paul
developer

Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California

Total Topics: 61
Total Comments: 7868
Paul
Posted May 11, 2010 - 5:16 AM:

The issue was the mysql socket specified in your host name: "localhost:/tmp/mysql5.sock". While php's mysql_connect can process that, the mysqldump command line utility can't handle socket specification in the host name and needs it in a separate -S parameter. I've changed WSN's backup utility so that it splits off the socket into the separate parameter, and it works for you now.
Search thread for
Download thread as
  • 0/5
  • 1
  • 2
  • 3
  • 4
  • 5



Sorry, you don't have permission to post posts. Log in, or register if you haven't yet.